https://bugs.documentfoundation.org/show_bug.cgi?id=105813
Bug ID: 105813
Summary: VBA Macro assignment to control not saved to XLS
Product: LibreOffice
Version: unspecified
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 130967
--> https://bugs.documentfoundation.org/attachment.cgi?id=130967&action=edit
Petro-grades-05-05b.ods spreadsheet containing VBA macros linked to controls.
BRAVO for improving VBA support in LO! But:
Procedure to reproduce bug:
1) Open spreadsheet containing VBA code linked to controls.
2) Macro code works
3) Save to .ods
4) Macro code still works properly
5) Save to .xls
6) Macro assignment to controls is not saved.
Controls still work, macros still work, macros can be re-assigned to
their buttons, but cannot be saved to .xls.
This is critical functionality, as many of my colleagues do not have
LO and need the xls format.
enclosed are three filed:
Petro-grades-05-05b.ods spreadsheet containing VBA macros linked to controls.
Petro-grades-05-05c.ods (saved from LO) Macro buttons work
Petro-grades-05-05c.xls (saved from LO) Macro buttons don't work, macros do.
Recommendation: Save macro assignments to controls in xls export.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
