Bug 127643 - Macro organizer fail to save module in .xls file
Summary: Macro organizer fail to save module in .xls file
Status: RESOLVED DUPLICATE of bug 46736
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.7.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-09-19 13:46 UTC by Nikola
Modified: 2019-09-19 21:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Test file created (5.50 KB, application/x-ole-storage)
2019-09-19 13:48 UTC, Nikola
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nikola 2019-09-19 13:46:51 UTC
Description:
Open macro organizer in .xls file and create a new module. All looks ok until file closed, after reopen module is missing. Saving file makes no difference.

Steps to Reproduce:
1.Create new spreadsheet file. Save it as .xls and reopen to be sure.
2.Tools/Macro/Libre office Basic.. New for named file. It is shown as it should, can enter function also.. Module1 or whatever.
3. Save on LibreOffice Basic window.. Save file.. whatever, then close.
4. Reopen test .xls file, module missing.

Actual Results:
Module is missing..

Expected Results:
Module should exist..


Reproducible: Always


User Profile Reset: No



Additional Info:
If same is done with .ods it just works as it should. Also there is no ref on what happening, all is excepted and looks like saved, then just missing when file closed and opened.
Comment 1 Nikola 2019-09-19 13:48:33 UTC
Created attachment 154294 [details]
Test file created

File given as result of described operation. Probably no point in sending it, but maybe it has some trace of saved code..
Comment 2 Roman Kuznetsov 2019-09-19 21:02:47 UTC
Nikola, LibreOffice can't save any macro in MSO xls/xlsx files. 
It can save macro only to ods files.

*** This bug has been marked as a duplicate of bug 46736 ***