Issue 12053 - maths on undefined text should produce an error.
Summary: maths on undefined text should produce an error.
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-03-05 05:45 UTC by tristanb
Modified: 2013-02-07 22:35 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description tristanb 2003-03-05 05:45:25 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.
Comment 1 frank 2003-03-05 10:10:24 UTC
Hi Tristan,

this is an Feature request and not an defect. I've set the flags

Have you tried the Value Highlighting (CTRL+F8) ? Blue are Values,
Green are formula results and black is text.


Hi Bettina,

one for you

Comment 2 tristanb 2003-03-06 03:38:15 UTC
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
Comment 3 eric.savary 2003-04-16 15:33:45 UTC
Set to "NEW"
Comment 4 claudiadzm 2007-08-17 06:38:16 UTC
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?
Comment 5 bettina.haberer 2010-05-21 14:56:40 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".