Bug 117266 - FILESAVE: xlsm- spreedsheet looses macro-linked buttons (and links) after saving
Summary: FILESAVE: xlsm- spreedsheet looses macro-linked buttons (and links) 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
: 120374 (view as bug list)
Depends on:
Blocks: XLSX Macro-VBA
  Show dependency treegraph
Reported: 2018-04-27 06:19 UTC by georg.weickelt
Modified: 2022-09-23 23:08 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:
Regression By:

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
Comment 5 QA Administrators 2021-05-02 03:50:06 UTC Comment hidden (obsolete)
Comment 6 johnks 2021-05-04 14:00:42 UTC
yes. confirmed with my software. I downloaded the file, opened it, the buttons showed up and clicking them showed a blank window.
open again.

buttons are gone.

Version: / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded
Comment 7 Timur 2021-09-22 10:58:41 UTC
*** Bug 120374 has been marked as a duplicate of this bug. ***
Comment 8 Timur 2022-03-21 15:31:28 UTC
*** Bug 139938 has been marked as a duplicate of this bug. ***
Comment 9 Timur 2022-03-21 15:31:43 UTC
*** Bug 146083 has been marked as a duplicate of this bug. ***
Comment 10 Justin L 2022-09-23 23:08:27 UTC
We have bug 124203 that focuses on the macro link being lost. Lets focus this one more on the lost buttons.