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. 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 -- PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication. Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
pgp9Qg6yjoI9O.pgp
Description: PGP signature
