OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: Re: [office-formula] Semantics


On 3/2/06, Eike Rathke <erack@sun.com> wrote:
> Hi Tomas,
> > So, basically, staying consistent amongst locales is more important
> > than greater flexibility with string parsing.
>
> Especially this example isn't only about locales. OOoCalc allows numeric
> input in both, halfwidth (ASCII) and Unicode fullwidth digits, in any
> locale, and parses as number. If it _did_ interpret textual cell content
> as numbers on the fly, it might as well do so for both halfwidth and
> fullwidth. Now if another application that doesn't parse fullwidth
> digits as numbers read the document it would calculate different. In the
> same locale.


Hmmm. What about DEFINING the text-conversion routines, to be
locale-independent ? This is about a file format, right ? The apps
WILL have to store numbers in a locale-neutral way - probably using
the US locale. So, why not make it so that text constants can get
auto-converted to numbers using only the english locale ? For simple
numbers (integer), this will work normally, for the rest, it's the
same as if it was not supported at all - we get interoperability,
because everyone parses using the same rules, and we also get
flexibility. The best from both worlds :)

Sure, it won't make everyone happy, but that's the way it has to be.
Your solution wouldn't make everyone happy, either.

/ Tomas


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]