Apache OpenOffice (AOO) Bugzilla – Issue 104808
VBA macro does not work
Last modified: 2014-03-06 14:35:18 UTC
I was sent an Excel sheet containing VBA macros. On my MacBook Pro (intel), OO 3.0 opened the sheet but refuses to run the macros, even with lowest security settings. After OO 3.1 was released, I thought it might work / not true. The same with OO 3.1.1. I remember having tried it some time ago on my PowerMac (PPC) running NeoOffice: no probs. As this is getting a real issue now, I also tried it with StarOffice 8 on Solaris (SPARC): no success. I asked a colleague to try it on Windows (OO 2.4): this works.
Of course, the macro security settings were identical in all cases. And for those who are wondering what "it doesn't work" means: instead of a result, just the "### MACRO ###" things appears in the affected cells.
Correct Version due to report. @fw89429: Can you please attach a sample document?
Created attachment 65306 [details] sample XLS file
I see the "MACRO?" string in "sample.xls", with other Load/Save VBA settings I get empty cells. May be particular macro code is not supported ba OOo? May be NeoOffice has improved VBA support? DUP of Issue 79854?
Another idea: I'm not 100% sure but maybe it works on those machines where M$ Office is installed. On my PowerMac, there is a trial version installed. As I re-installed MacOS on my MacBook Pro, there is no M$ Office. The same applies to Solaris :) ... and my colleague's Windows machine definitely has M$ Office besides OO. Is this a valid approach? Is there something like a libvba.dylib which we need?
Any updates on this?
Still broken in OOo 3.3
Read-Error. Internal import error. AOO410m1(Build:9750) - Rev. 1555399 2014-01-06_04:13:46 - Rev. 1555657 Debian
Currently I do not understand CONFIRMED and "Regression". * Do we KNOW any OO version and any Machine where the macro in the sample document works? * Has been checked whether document is in accordance with "VBA interoperability in OpenOffice"? * With what VBA Settings have the tests been done?
Did you open the file in comment 4? I can't!
Unfortunately I only have MS OFFICE Starter 2010, what does not support Macro execution. Remove "regression" because currently no OOo Version known where VBA macros of sample document @Edwin Sharp This report is concerning not working VBA Macros. If you have a problem to open the document ("Read-Error") please submit a separate bug, but do not hijack this one.
Created attachment 82803 [details] Excel 2010 vs. Calc 4.1
Confirmed with AOO410m14(Build:9760) - Rev. 1573601 2014-03-03 17:47:48 (Mo, 03 Mrz 2014) Win 7