Issue 77453 - macros assigned to buttons aren't remembered for excel export/import
Summary: macros assigned to buttons aren't remembered for excel export/import
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2 RC4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-05-17 10:19 UTC by treaclle
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
excel file with button that doesn't remember macro assignment (87.00 KB, application/vnd.ms-excel)
2007-05-17 10:22 UTC, treaclle
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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