[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]