To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=58903
Issue #:|58903
Summary:|Illegal arithmetic operations on text cells
|undetected
Component:|Spreadsheet
Version:|OOo 2.0
Platform:|All
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|code
Assigned to:|spreadsheet
Reported by:|jrkrideau
------- Additional comments from [EMAIL PROTECTED] Mon Dec 5 08:11:20 -0800
2005 -------
It is possible to carry out arithmetic operations on text cells. If one has a
text value of '9999 in a cell formatted as a text cell an arithmetic operation
does not return an error but rather it returns a number. The number returned is
dependent upon the operation Note that Excel does this in some circumstances
but the values returned are not the same as Calc's.
Below are some examples of operations on text 'numbers' on a real number both
for Calc and Excel. In my opinion the results from both of these are
unacceptable and very dangerous in some situations.
Calc Version 2.0.0 (Final)
Check of arithmetic operations on text cells.
A1 = 5 A2 = foo C1=999 <- C1 is a Text formated cell
Operation Result
Add A1 + B1 5
Sum (A1:B1) 5
Multiply A1*B1 0
Sum (A1:C1) 5
Add A1 + C1 5
Sum(A1:C1) 5
Multiply A1+C1 0
All of these operations should have returned an error of #Value.
The equivalent results from Excel (2003) are
A1 = 5 B1 = foo C1 = 999 <- C1 is a Text formated cell
Operation Result
Add A1 + B1 #VALUE!
Sum (A1:B1) 5
Multiply A1*B1 #VALUE!
Add A1 + C1 #VALUE!
Sum (A1:C1) 5
Multiply A1*C1 4995
All of these operations should have returned an error of #Value.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
