|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Basic functions not recognized on loading XLSM file | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | Bob <bobbuxton> | ||||
| Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||
| Status: | UNCONFIRMED --- | QA Contact: | |||||
| Severity: | Minor | ||||||
| Priority: | P3 | ||||||
| Version: | 4.1.0 | ||||||
| Target Milestone: | --- | ||||||
| Hardware: | All | ||||||
| OS: | Windows 7 | ||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
| Developer Difficulty: | --- | ||||||
| Attachments: |
|
||||||
Created attachment 83726 [details] Trivial spreadsheet in XLSM format, #NAME? on load When I open an excel XLSM file in LO 4.2.5.2 or OO 4.1.0 all references to functions written in VBA appear as #NAME? If I open the macro source I can see all of the functions are present and correct and if I make a dummy change to the spreadsheet formula they are then recognized and work correctly, eg Replace all = by = Requesting recalculation of the sheet is not sufficient to cause recognition. Perhaps this is a timing window within file load, the check for valid function names is being made before the Basic environment has been fully loaded with macros. It appears that 95% of the work to be able to read XLSM files has been done and it is a pity to have to resort to tricks to get macros recognized. The same spreadsheet in XLS format loads without problem