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
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.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.