| Summary: | Basic functions not recognized on loading XSLM file | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Bob <bobbuxton> |
| Component: | BASIC | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | minor | CC: | serval2412 |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | Windows (All) | ||
| Whiteboard: | (target:4.2.6) | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Trivial spreadsheet in XLSM format, #NAME? on load | ||
Minor correction
> The same spreadsheet in XLS format loads withOUT problem
On pc Debian x86-64 with LO Debian package 4.2.5, I could reproduce the problem. I don't reproduce this with 4.2 sources updated 15 days ago (and with 4.3 sources updated yesterday) For the test, could you give a try to 4.2.6RC1 http://www.libreoffice.org/download/libreoffice-fresh/?version=4.2.6 If it doesn't work, you also give a try to future 4.2.7 with daily build (see http://dev-builds.libreoffice.org/daily/libreoffice-4-2/Win-x86@42/current/) I am happy to confirm problem no longer exists in 4.2.6.1 and for this bug to be closed Thank you Bob for your feedback. I put this to WFM since there's no specific fix. |
Created attachment 103333 [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 with problem