Am 27.07.2012 07:32, Lei Wang wrote:
In my point of view it is better to support more scenarioes to convert a
text value to a number, such as decimal. Though different locale has
different decimal separator, AOO can support decimal separator for current
locale and standard decimal separator, ".". It will be more complicated for
date format.
What's your suggestion?
Hi,
=VALUE("1,234";"de-DE") is my suggestion. But that would be incompatible.
VALUE("1,234") returns different values in German and English versions
of MS Excel. This is inacceptable.
The current behaviour which converts unambiguous ISO and integer only is
a good compromise. Personally I would prefer #VALUE! over any implicit
conversion. Broken spreadsheets deserve to be fixed.
Just my 2 Cents,
A.S
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
