Re: [office-formula] Semantics

["Tomas Mecir" <mecirt@gmail.com>]

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