[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Re: koffice doesn't read formulas correctly (testcase)
From:       Martin Ellis <m.a.ellis () ncl ! ac ! uk>
Date:       2006-03-16 16:19:14
Message-ID: 200603161619.14358.m.a.ellis () ncl ! ac ! uk
[Download RAW message or body]

> > > On Wednesday 15 March 2006 22.11, Raul Fernandes wrote:
> > > > When saving, kspread saves the formula replacing the commas to dot
> > > > (it is ok as openoffice.org uses dot),
> > > > but when loading, it doesn't convert to
> > > > commas again.  So, the result is:
> > > >
> > > > 36 (not 3,6)

> > > This is as it should be.  The storage format should not be localized,
> > > even though the GUI is.

> It eliminates the thousands separator (in your case '.'). With a space as
> thousands separator it works.

While this is being fixed, you can work around the problem by putting your 
formula in parenthesis:

  =(1,5+2,1)
... produces ...
 3,6
... after saving.

Martin
_______________________________________________
koffice-devel mailing list
koffice-devel@kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread]