Issue 125301 - Basic functions not recognized on loading XLSM file
Summary: Basic functions not recognized on loading XLSM file
Status: UNCONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Trivial spreadsheet in XLSM format, #NAME? on load (12.94 KB, application/vnd.ms-excel.sheet.macroenabled.12)
2014-07-23 13:03 UTC, Bob 		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 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 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