Hi Eike,
Eike Rathke wrote:
Hi Cor,
On Tuesday, 2008-07-22 22:29:09 +0200, Cor Nouws wrote:
Example:
A1 = '1.5
B1 = A1-1
Result Excel #VALUE!
Result OOo -1
In Excel that's when loaded in a locale where the decimal separator is
not the '.' dot. If it was, you'd get 0.5
The reason why interpreting strings as numeric values on the fly is
harmful and we do not want to implement it.
BUT you do it. You interpret it *always* as 0. This is the worst
possible scenario.
As I mentioned in the previous post: raising an error is one option (the
best), but it depends on some pre-requisites:
- ability to easily find string-as-number cells
- easy conversion to number
[I know that Cor's extension does exist,
BUT Calc should do it natively]
- and ability to keep the user's format
that is why the user used a string in the first place!!!
Sincerely,
Leonard
There's an issue for that
I don't find at the moment, I think you know that one. Solution would be
to always generate an error in such case.
Time to include a quote:
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.
Eike
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
