https://issues.apache.org/ooo/show_bug.cgi?id=125301
Issue ID: 125301
Issue Type: DEFECT
Summary: Basic functions not recognized on loading XSLM file
Product: Calc
Version: 4.1.0
Hardware: All
OS: Windows 7
Status: UNCONFIRMED
Severity: minor
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
Created attachment 83726
--> https://issues.apache.org/ooo/attachment.cgi?id=83726&action=edit
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
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
