Download it now!
Bug 117266 - FILESAVE: xlsm- spreedsheet looses function after saving
Summary: FILESAVE: xlsm- spreedsheet looses function after saving
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Macro-VBA XLS
  Show dependency treegraph
Reported: 2018-04-27 06:19 UTC by georg.weickelt
Modified: 2019-05-02 08:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

excel- file with macros (forms) (50.56 KB, application/zip)
2018-04-27 06:20 UTC, georg.weickelt

Note You need to log in before you can comment on or make changes to this bug.
Description georg.weickelt 2018-04-27 06:19:28 UTC
After saving a file with embedded macros it is no longer working.

Steps to Reproduce:
1. open attached file, activate macros
2. klick the buttons (Typ I) - a form opens, you can choose a answer
3. save as with a new name1, as xlsm- file
4. save as with a new name2, als ods
5. open name1: Buttons are no longer visible
6. open name2: buttons visible, but after klick a basic- error pops up

Actual Results:  
Excel- macros not working after saving files

Expected Results:
buttons should be visible and working

Reproducible: Always

User Profile Reset: No

OpenGL enabled: Yes

Additional Info:
In Options/VBA "save original basic-code" is ticked

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0
Comment 1 georg.weickelt 2018-04-27 06:20:48 UTC
Created attachment 141667 [details]
excel- file with macros (forms)
Comment 2 raal 2018-04-28 15:25:58 UTC
I can confirm with Version:
Build ID: 930a3cbaeeaf6bca594f8651c4d5dffc1e5391d4
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
Comment 3 QA Administrators 2019-04-30 02:41:44 UTC Comment hidden (obsolete)
Comment 4 georg.weickelt 2019-05-02 08:56:25 UTC
Problem still exists.
Version: (x64)
Build-ID: aecc05fe267cc68dde00352a451aa867b3b546ac
CPU-Threads: 8; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: CL