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

List:       koffice
Subject:    Re: saving and loading cell types in oasis file format
From:       Nicolas Goutte <nicolasg () snafu ! de>
Date:       2004-08-21 20:55:10
Message-ID: 200408212255.10759.nicolasg () snafu ! de
[Download RAW message or body]

On Saturday 21 August 2004 22:26, Raul Fernandes wrote:
> Really. I didn't tested with large numbers, only smalls (< 1000). Maybe
> removing the dots from the number before changing the commas will resolve
> the issue. What do you think???

I do not know if it would fix all problems.

The numbers 123456.78 could be one of the following, depending on the locale 
settings:

123,456.78 (comma and dot)
123.456,78 (dot and comma)
123'456,78 (single quote and comma)
123 456,78 (space and comma)
123 456.78 (non-breaking space and dot)

(Note that the spaces are supposes to be non-breaking spaces but it might be 
that there are normal spaces instead. Note also that the previous list is not 
exhaustive.)

So I do not know how KSpread handles it exactly and if it does it correctly 
but if we save in OASIS we must be more careful.

So perhaps you can use KLocale to help to convert the formula but perhaps it 
will not work if the KSpread document was first created with another locale.

>
> Thanks

Have a nice day!

>
> Raul Fernandes
> rgfernandes@correioweb.com.br
>
> Em Sáb 21 Ago 2004 15:57, Nicolas Goutte escreveu:
> > As far as I understand, a number like "1,234,567.89" will also be
> > transformed to "1.234.567.89" which is not good either.
> >
> > Have a nice day!
> >
> > On Saturday 21 August 2004 19:49, Raul Fernandes wrote:
> > > The kspread doesn't save and load the cell types correctly when saving
> > > in oasis format. The kpspread saves Date, Time, Currency and String
> > > cells as Number cell and doesn't load these properties. It saves
> > > floating point numbers in formulas with "," as decimal separators, but
> > > the oasis spec says that the right separator is ".".
> > > I've made this patch to fix these issues (against today cvs version).
> > > I've tested with openoffice.org 1.9 m49 and it works well. Please, test
> > > and apply it if it's right.
> > >
> > > Thanks
> > >
> > > Raul Fernandes
> > > rgfernandes@correioweb.com.br
> >
> > ____________________________________
> > koffice mailing list
> > koffice@mail.kde.org
> > To unsubscribe please visit:
> > https://mail.kde.org/mailman/listinfo/koffice
>
> ____________________________________
> koffice mailing list
> koffice@mail.kde.org
> To unsubscribe please visit:
> https://mail.kde.org/mailman/listinfo/koffice

____________________________________
koffice mailing list
koffice@mail.kde.org
To unsubscribe please visit:
https://mail.kde.org/mailman/listinfo/koffice

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