Hi Eike,
Eike Rathke wrote (7-8-2008 1:59)
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
OK. But still the difference is (no judgement) that Excel gives an error
message and Calc neglects the non numeric argument.
The reason why interpreting strings as numeric values on the fly is
harmful and we do not want to implement it. There's an issue for that
I don't find at the moment, I think you know that one.
Hmm, could it be #5658 ;-)
Solution would be to always generate an error in such case.
You mean an error if an formula holds an non numeric argument. This is
the same as Excel does, 'only' with this difference that Excel in some
formulas uses text that can be interpreted as number, and in other also
simply neglects it. Which - with my limited knowledge - looks as a sort
of a mess. And I have the impression that it differs over various
versions of Excel as well.
>> Anyone with basic or comprehensive data on the way different
versions of Excel handles text in different formula's??
Would be much appreciated! (reason further below)
So the Excel way is not something I propose.
The solution to always generate an error or warning, makes more sense, IMO.
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.
No reason to disagree. The only thing is that I provide a tool for
people that have to cope with this ugly situation:
http://extensions.services.openoffice.org/project/CT2N
(Next version with some date conversion, changes, bugfix,... coming
soon. - Feedback always appreciated, of course)
Kindest regards,
Cor
--
"The Year of 3" -2008- "Het jaar van 3"
Cor Nouws - Arnhem - Netherlands
> marketing contact - http://nl.OpenOffice.org
> Zeker van OpenOffice.org - www.nouenoff.nl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
