Issue 125301 - Basic functions not recognized on loading XLSM file
Summary: Basic functions not recognized on loading XLSM file
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.0
Hardware: All Windows 7
: P3 Minor (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-07-23 13:03 UTC by Bob
Modified: 2014-07-23 17:36 UTC (History)
0 users

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

Trivial spreadsheet in XLSM format, #NAME? on load (12.94 KB, application/
2014-07-23 13:03 UTC, Bob
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Bob 2014-07-23 13:03:59 UTC
Created attachment 83726 [details]
Trivial spreadsheet in XLSM format, #NAME? on load

When I open an excel XLSM file in LO 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