OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: 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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]