Hello Niklas & others,
on the German users list the question was raised why a cell with pure text
contents used in a calculation formula does not (!) raise an error (*)
For example:
A1: 1
A2: blabla
A3: =A1+A2
A3 shows result 1 - and I'm puzzled.
In issue <http://de.openoffice.org/issues/show_bug.cgi?id=65604> Frank
Schönheit (fst) said:
"Text is text and not a number so you can't calculate with text."
Taking this into account it appears absolutely logical to expect an error
in A3 (and that's exactly what happens in M$-Excel and Softmaker's
Planmaker with something like '#VALUE!'). Checks on A3 with =IFERROR()
don't work with OOo Calc in this case and may render sheets useless.
Before I raise an issue, I wanted to hear the developers thoughts about
this. Can you please give us some insight?
Regards
Guido
(*) This is _not_ one of the typical "we want numbers erroneously
formatted as text to be still treated as numbers as in Excel" questions as
handled in many issues like #5658 etc.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
