[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-formula] Semantics
On 3/6/06, Eike Rathke <erack@sun.com> wrote: > That is the "C" locale, which is already used for all numeric content. > You still don't solve any string-to-number conversion issues with that. Don't I ? What I'm proposing is that automated string-to-number conversions, while computing, are done using the C locale. Hence: if your locale has "," as comma separator, then: ="3"+3 is 6 ="3"+3,0 is 6 ="3.0"+3,0 is 6 ="3,0"+3,0 is ERROR =VALUE("3,0")+3,0 is 6 (VALUE uses locale-aware conversion). / Tomas
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]