Issue 6157 - Formula not calculating properly in imported Excel sheet
Summary: Formula not calculating properly in imported Excel sheet
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-06-26 23:27 UTC by Unknown
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
Excel file where extended price comes up zero but shouldn't. (250.50 KB, application/octet-stream)
2002-06-26 23:31 UTC, Unknown 		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 Unknown 2002-06-26 23:27:53 UTC 
I recently received a Excel file that worked well in Excel but not in 
OpenOffice.  
Cell J14   had the formula =ROUND(C14*(E14*(1-F14))*(I14/366)*0.2;0)
C14 = 1
E14 = 520
F14 = empty, no value 
G14 = 03/04/03 (date MM/DD/YY)
H14 = 07/01/04 (date MM/DD/YY)
I14 = =IF(H14-G14<=1;"";H14-G14+1)

The cell J14 is displaying 0.00 when it should display 138.00

Only 1 row is correct.
C17 = 1
E17 = 9,995
F17 = empty, no value
G17 = 01/12/02 (date MM/DD/YY)
H17 = 01/01/04 (date MM/DD/YY)
Formulas are same as in row 14. And J17 displays 4296.00 as it should.

I hope I have described this adequately.
Regards
Rick Baseley
Comment 1 Unknown 2002-06-26 23:31:09 UTC 
Created attachment 2098 [details]
Excel file where extended price comes up zero but shouldn't.
Comment 2 frank 2002-06-27 09:23:30 UTC 
Hi Rick,

this is not a bug. OOo can't calculate with numbers formated as text.
C14, C15, C18 and C19 are formated as text. Only C17 is a 'true'
number. So only the calculation which involves C17 can give the
correct result.

Never the less this is a double to Issue 5658.

Best regards

Frank

*** This issue has been marked as a duplicate of 5658 ***
Comment 3 frank 2002-06-27 09:37:26 UTC 
closed as duplicate