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