Issue 18721

Summary: Error using a MS Excel 97 file with formulas (IF, ABS)
Product: Calc Reporter: iron51 <iron51>
Component: codeAssignee: oc
Status: CLOSED NOT_AN_OOO_ISSUE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P5 (lowest) CC: issues
Version: OOo 1.1 RC3   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
MS Excel 97 file none

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