Issue 103456 - Complex formula would not work for .xls, Formula Wizard fixes it.
Summary: Complex formula would not work for .xls, Formula Wizard fixes it.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-07-10 15:29 UTC by kpalagin
Modified: 2013-01-29 21:40 UTC (History)
3 users (show)

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

Attachments
See cells J2:O33 (18.50 KB, application/vnd.ms-excel)
2009-08-20 07:23 UTC, kpalagin 		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 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.