Issue 55954 - OO miscalculates excel spreadsheets
Summary: OO miscalculates excel spreadsheets
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO 2.0 Beta2
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2005-10-13 23:14 UTC by daxkelson
Modified: 2005-10-14 00:59 UTC (History)
2 users (show)

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

Attachments
Excel file that OO mis calculates (15.00 KB, application/vnd.ms-excel)
2005-10-13 23:25 UTC, daxkelson 		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 daxkelson 2005-10-13 23:14:00 UTC 
I get a royalty report in Excel format emailed to me on a quarterly basis. It is
autogenerated in Excel.

When I open in any version of OpenOffice (v1 or v2.0 includes beta2) the owed
royalty is the wrong value! Both Excel, Gnumeric, and Documents to Go v7 (PalmOS
spreadsheet) produce the proper value.

This is a very serious defect, that could have had serious financial implications.

I have distilled a test case and am attaching it.
Comment 1 daxkelson 2005-10-13 23:25:31 UTC 
Created attachment 30414 [details]
Excel file that OO mis calculates
Comment 2 Regina Henschel 2005-10-14 00:58:28 UTC 
The table is ill-structured. The cells in column A with the dot are no numbers
but text. Try to format them with % and you can see it. On the other hand where
is determined whether a number uses the decimal delimiter dot or comma? OOo
cannot calculate with text. The issue 5658 for discussion.

*** This issue has been marked as a duplicate of 5658 ***
Comment 3 Regina Henschel 2005-10-14 00:59:11 UTC 
The table is ill-structured. The cells in column A with the dot are no numbers
but text. Try to format them with % and you can see it. On the other hand where
is determined whether a number uses the decimal delimiter dot or comma? OOo
cannot calculate with text. The issue 5658 for discussion.