Re: [sc-dev] Using text in calculation fails to raise error

Guido Ostkamp wrote: (*) 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. It's related. The error that others show is from failure to convert to a number. Our approac

[sc-dev] Using text in calculation fails to raise error

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