Apache OpenOffice (AOO) Bugzilla – Issue 12053
maths on undefined text should produce an error.
Last modified: 2013-02-07 22:35:11 UTC
set A1 to "6", B1 to "5", and C1 to "=A1+B1". C1 is 11. if B1 is accidently entered as text (e.g. hitting "t"), it treats it as zero, and C1=6. Because "t" is not defined in Insert->Names, the C1 formula should instead result in an error. Although obvious in this case, if A1 and B1 were meant to be dates (d/m/y), typing "25/3/1927" would result in a date, though "30/2/1998" would be a text string, thus treated as zero. This mistake would not immediately be visible unless an Err code was shown.
Hi Tristan, this is an Feature request and not an defect. I've set the flags accordingly. Have you tried the Value Highlighting (CTRL+F8) ? Blue are Values, Green are formula results and black is text. Frank Hi Bettina, one for you Frank
no i didn't know about Value Highlighting :), it's a good feature. but unless an erroneous result was obvious, or you always wrote spreadsheets with V.H. turned on, you could still miss a mistake. thanks for the quick reply! :D
Set to "NEW"
I'd call it "feature", if the user could turn on/off the attitude of the program as an option. The automatical interpretation as zero can produce fatal results. Greetings, Claudia By the way: doesn't mean this issue the same as 45313?
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".