Apache OpenOffice (AOO) Bugzilla – Issue 77453
macros assigned to buttons aren't remembered for excel export/import
Last modified: 2013-08-07 15:12:27 UTC
hi, i'm aware that OO doesn't support excel macros, but this is different because the macro was created by recording it in OO. i then created a button and assigned the macro to run every time a mouse button is pressed on the button. i always save as an excel spreadsheet to maintain compatibility with my blackberry. however, when i save and reload the file, the button and macro both exist as they should, but the macro is no longer assigned to the "mouse button pressed" event of the button. every time i reload i have to go to design view, right click on the button, choose control, select the events tab, click "..." next to "mouse button pressed", and find my way to the macro each time to reassign it. can this be fixed? would u like me to send in an example file? how would i do that? thank you very much for your time, alex =)
Created attachment 45184 [details] excel file with button that doesn't remember macro assignment
I can confirm this. And can't find (which doesn't mean that much ;-) ) an already existing issue for this. So set to new.
Hi, IMHO not a bug because Excel does not know from twhere it should get the code and also can't undersatnd the OOo Code. Therefore the Event itself is stripped if saved to XLS. So this is an enhancement request for keeping the event and the Macrocode in the XLS file. Something for the requirements team. Frank