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: NUMBERVALUE (was: [office-formula] NUMBERVALUE and VALUE)


Any opinions on NUMBERVALUE regarding the points I mentioned:

- Introduction of a third parameter for group AKA thousand separator.
  Strictly spoken, for a group separator we'd also need a fourth
  parameter to define the grouping, defaulted to "3" (for Western
  1,000,000), which could be set to "23" (for Indic 1,00,00,000).

- Do not define it as yet another "try to parse as much as possible"
  function, hence no fallback to VALUE with exchanged separators. Parse
  only numbers, do not try to attempt parsing dates/times/currencies/...


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

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