Issue 16519 - Import Excel documents with calcuations go wrong
Summary: Import Excel documents with calcuations go wrong
Status: CLOSED DUPLICATE of issue 3851
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2003-07-07 05:32 UTC by waiterevo
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

Attachments
The Excel document that casues Calc problem (20.50 KB, application/octet-stream)
2003-07-07 05:34 UTC, waiterevo 		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 waiterevo 2003-07-07 05:32:38 UTC 
See the attachment.

When open in Excel 2002, the L column (Total) which is set to be column J * 
column K has correct values.

When the same file is open by OO1.1beta2, the L columns all set to zero. This 
is a fatal problem.
Comment 1 waiterevo 2003-07-07 05:34:15 UTC 
Created attachment 7447 [details]
The Excel document that casues Calc problem
Comment 2 dankegel 2003-07-07 06:25:12 UTC 
Verified on RH8 Linux x86.  Even gnumeric gets this right.  Tsk.
Thanks for the bug report!
I'm resetting priority to P2 -- that really is the right 
priority, according to the guidelines -- but this apears to be
a showstopper.
Comment 3 daniel.rentz 2003-07-07 09:20:09 UTC 
All cells in columns J and K are text. Calc hannot calculate with text
cells. See issue 3851 and issue 5658. And it will surely not be
changed in 1.1.

*** This issue has been marked as a duplicate of 3851 ***
Comment 4 daniel.rentz 2003-07-07 09:20:22 UTC 
double->closed