Issue 94612 - Excel incompatibility - string in a Math formula
Summary: Excel incompatibility - string in a Math formula
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.4.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-03 10:49 UTC by kkeane
Modified: 2008-10-04 00:05 UTC (History)
1 user (show)

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

Attachments
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 kkeane 2008-10-03 10:49:06 UTC 
When you use a string that contains a numeric string, Excel will use it as a
number. OpenOffice treats it as a zero regardless of the actual value.

Example:
B12: 8
E12: =IF(B12<5,"$59.99",IF(B12<15,"$49.99"))
F12: 1.99
G12: 1.5
M12: =SUM((E12+F12+G12)+(E12+F12+G12)*0.069)*B12

(all cells except B12 formatted as currency)

In this scenario, Excel will display:

B12 | ... |   E12  |  F12  |  G12  | .... | M12
8     ... | $49.99 | $1.99 | $1.50 | .... | $457.36

OpenOffice will display
8 ... $49.99 $1.99 $1.50 .... $29.85

This is similar to bug 6768, which I believe should not have been closed.
Regardless of whether Excel's behavior is philosophically "logical" or
"correct", when OpenOffice yields different mathematical results than Excel,
that undermines trust in OpenOffice.
Comment 1 frank 2008-10-04 00:05:10 UTC 
Sorry, but a string is a string and not a number.
And BTW it's a double to Issue 5658 as stated in the Issue you mentioned.



*** This issue has been marked as a duplicate of 5658 ***
Comment 2 frank 2008-10-04 00:05:31 UTC 
closed double