Issue 77453

Summary: macros assigned to buttons aren't remembered for excel export/import
Product: Calc Reporter: treaclle <treaclle>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: cno, issues
Version: OOo 2.2 RC4   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
excel file with button that doesn't remember macro assignment none

Description treaclle 2007-05-17 10:19:04 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 =)
Comment 1 treaclle 2007-05-17 10:22:43 UTC 
Created attachment 45184 [details]
excel file with button that doesn't remember macro assignment
Comment 2 cno 2007-05-17 23:10:43 UTC 
I can confirm this.
And can't find (which doesn't mean that much ;-) ) an already existing issue for
this.
So set to new.
Comment 3 frank 2007-07-09 13:16:05 UTC 
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