Bug 144204 - Javascript macro not saved to XLS and XLSX
Summary: Javascript macro not saved to XLS and XLSX
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
7.2.0.2 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-08-31 07:50 UTC by Timur
Modified: 2023-01-06 13:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Timur 2021-08-31 07:50:00 UTC 
Open ODS attachment 143194 [details] with Javascript macro from bug 118440.
Save as XLS, XLSX, XLSM.
Open in MSO, buttons are there but without macros.
Comment 1 Timur 2021-08-31 07:51:33 UTC 
Note a separate bug 97827. So not clear if there should be any development on the existing engine.
Comment 2 Roman Kuznetsov 2021-09-18 07:33:20 UTC 
I don't think XLS or XLSX formats allow to save JS scripts inside file

Mike, we need some expert opinion here, could you help?
Comment 3 Mike Kaganski 2021-09-18 08:21:14 UTC 
(In reply to Roman Kuznetsov from comment #2)
> I don't think XLS or XLSX formats allow to save JS scripts inside file

I also doubt that this is supported by OOXML formats - or at least by MS Office. But I might be wrong, I'm not an expert in MS Office supported features.
Comment 4 Buovjaga 2023-01-06 13:12:39 UTC 
There is a JS API for Excel, but of course it is different from our API: https://learn.microsoft.com/en-us/office/dev/add-ins/reference/overview/excel-add-ins-reference-overview