Issue 103456

Summary: Complex formula would not work for .xls, Formula Wizard fixes it.
Product: Calc Reporter: kpalagin <kpalagin>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: frank, issues, rb.henschel
Version: OOo 2.4.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
See cells J2:O33 none

Description kpalagin 2009-07-10 15:29:29 UTC
(File is confidential and will be sent to fst).

Open supplied file - in column G you get #MACRO?.
Click in, say, G8 and bring up Formula Wizard, click OK - you get a date 
result.
Saving to .ods and reopening fixes the problem too.
Problem first discovered in 2.4.1 and still exists in m51.
Comment 1 kpalagin 2009-08-20 07:21:37 UTC
Here is simplistic file - base(a1;32) will display #MACRO? when round-triping 
to .xls.
Comment 2 kpalagin 2009-08-20 07:23:09 UTC
Created attachment 64259 [details]
See cells J2:O33
Comment 3 Regina Henschel 2009-08-20 13:42:44 UTC
I think that it is the same problem as reported in issue 99075 and earlier in
issue 79854.
The function BASE is unknown in Excel.

For me the error is, that after saving to ods-format you need to reload the
document and that 'Hard Recalculate" does not remove the #MACRO? remark on the
now ods-document.