Issue 18721 - Error using a MS Excel 97 file with formulas (IF, ABS)
Summary: Error using a MS Excel 97 file with formulas (IF, ABS)
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows XP
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-27 10:49 UTC by iron51
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
MS Excel 97 file (14.50 KB, application/octet-stream)
2003-08-27 10:51 UTC, iron51 		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 iron51 2003-08-27 10:49:55 UTC 
OpenOffice 6.0.8639.500 (ENG) with Microsoft Windows XP (SP1)(ITA)

I have a spreadsheet created with Microsoft Excel 97 (Sr-2)(ITA)
When I open it in OO I got an error (ERR:511) in the cell
whith this:

right forumula in Excel:    IF((B2-A2)<0;24-Abs(B2-A2)*24;(B2-A2)*24)
wrong formula in OO:        IF((B2-A2)<0;24-(Abs;B2-A2)*24;(B2-A2)*24)
Comment 1 iron51 2003-08-27 10:51:51 UTC 
Created attachment 8802 [details]
MS Excel 97 file
Comment 2 daniel.rentz 2003-08-27 15:10:18 UTC 
In Italian Excel and OOo Calc the function is named ASS. Therefore the
entered function "Abs" is stored as unknown function call (you can see
it because it is not converted to uppercase letters). The attached
spreadsheet does not work correctly in Excel and OOo Calc (in cell B2,
try to enter a time less than the time in A2, you will get a #NAME!
error in Excel). The only difference is that OOo Calc detects the
error even if the condition in the IF function is false, and the part
with the wrong function is not evaluated. I see it as an advantage
that Calc immediately notifies the user about an error in the function.
Comment 3 daniel.rentz 2003-08-27 15:10:30 UTC 
invalid->closed