Re: [office-formula] Semantics

From
Tomas Mecir <>
Date
2006-03-06T16:21:42+00:00
ID
Thread
Re: [office-formula] Semantics
> ="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).

Oh, just as a clarification, this is from user's view-point, the
non-string numbers (3 and 3,0) would be stored as 3.0 in the output
file. Strings like "3" or "3.0" would be stored as-is and
auto-converted when needed.

/ Tomas