Issue 25977 - empty cells or cells with text are handled like cells with a "0" when calculating
Summary: empty cells or cells with text are handled like cells with a "0" when calcula...
Status: CLOSED DUPLICATE of issue 3851
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-02-28 12:46 UTC by norbert2
Modified: 2004-03-26 17:22 UTC (History)
1 user (show)

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

Attachments
example spreadsheet (5.22 KB, application/vnd.sun.xml.calc)
2004-02-28 12:47 UTC, norbert2 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2004-02-28 12:46:53 UTC 
OOo-spreadsheet-application does handle empty cells or cells with text like
cells with a "0" when calculating!
This is a very big problem! Please have a look at the example spreadsheet I have
attached:
"Hello" * "5" = "0" !!!
or
EMPTY * 5 = 0 !!!

Excel does print an error in the result-cell if one of the cells it is
calculatet of does not include a number! OOo should also do so!

Please change this!!!
Comment 1 norbert2 2004-02-28 12:47:30 UTC 
Created attachment 13493 [details]
example spreadsheet
Comment 2 frank 2004-03-01 10:01:55 UTC 
Hi,

Prio is much to high, I corrected this.

Also this is not a bug but could be seen as an enhancement request. So I changed
the Issue type and re-assign it to Bettina.

Frank
Comment 3 norbert2 2004-03-02 21:17:47 UTC 
Please see this as user! I think I'm not the only one using Calc for complex
calculations that are important. And if the fact that if there is a empty cell
where the user has forgotten to enter a value that is included in the formula
does not mark the result as not-calculateable can lead to very big irritations,
believe me!

Allow me to correct the priority.
Comment 4 norbert2 2004-03-03 20:46:24 UTC 
"Hello" * 5 = 0
... is not a bug!? Maybe you have learned other math-laws than I...
Comment 5 norbert2 2004-03-21 12:09:00 UTC 
I think Text should be in general lead to an error when trying to calculate 
with it.

But the handling of empty cells (if it leads to an error or is handled as "0") 
could be added as document option, where the user can decide for each document 
how to handle empty cells.
How do you think about this?
Comment 6 norbert2 2004-03-21 13:38:48 UTC 
Excel 2002 seems to handle empty cells now as "0", Gnumeric behaves same. I 
still think that a documen-toption to handle this would be the best solution.

But both, Excel AND Gnumeric set the result invalid if a cell used in a 
formula contains text. OOo-Calc seems the only spreadsheet-program that does 
handle text as "0".
So please think about to change this!
Comment 7 daniel.rentz 2004-03-26 17:22:10 UTC 
double to issue 3851

*** This issue has been marked as a duplicate of 3851 ***
Comment 8 daniel.rentz 2004-03-26 17:22:30 UTC 
double -> closed