Bug 122420 - FILESAVE: VBA Worksheet_Change Listener lost on saving .xlsm in LO
Summary: FILESAVE: VBA Worksheet_Change Listener lost on saving .xlsm in LO
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
: 122378 (view as bug list)
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
Reported: 2019-01-02 12:38 UTC by Oliver Brinzing
Modified: 2021-08-15 07:39 UTC (History)
3 users (show)

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

demo macro worksheet change (12.46 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2019-01-02 12:38 UTC, Oliver Brinzing

Note You need to log in before you can comment on or make changes to this bug.
Description Oliver Brinzing 2019-01-02 12:38:54 UTC
Created attachment 147933 [details]
demo  macro worksheet change

i noticed the problem while investigating issue

- open attached "demo_ macro_worksheet_change.xlsm" (created with excel 2016)
- enter text in cell A1
- Worksheet_Change() Macro will execute on cell change
- save as *.xlsm, close and reload
- enter text in cell A1
- nothing happens
Comment 1 Durgapriyanka 2019-01-02 21:48:30 UTC
Thank you for reporting the bug. I can not confirm the bug with 

Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 2 raal 2019-01-02 22:17:52 UTC
Confirm with Version:
Build ID: ef58bf56ad292656ad2de0a417eda72cc170f782
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: cs-CZ (cs_CZ.UTF-8); UI-Language: en-US

Build ID: a1b3ae95e35fe0669bcc9df020fa606e6a3cca75

In version Version:
Build ID: 721efbeb117962e9b0cd547b51ede4a6736042a6  this Worksheet_Change() Macro doesn't work. Macro started to work after commit:

author	Tamas Bunth <tamas.bunth@collabora.co.uk>	2017-07-06 10:46:48 +0200
committer	Tamás Bunth <btomi96@gmail.com>	2017-07-06 22:37:12 +0200
commit 5ee6862ee420f13133ade382d7ef2be319414d40 (patch)
tree dc255b1cf96f9e8f99d77c3a92b488af87c938db
parent 388041695d9626970b0d4dce89241c849eeffd0e (diff)
Create vba library if it did not exist before

Adding Cc: to Tamás Bunth ; Could you possibly take a look at this one?
Comment 3 Xisco Faulí 2019-08-09 11:17:52 UTC
*** Bug 122378 has been marked as a duplicate of this bug. ***
Comment 4 QA Administrators 2021-08-09 03:41:34 UTC Comment hidden (obsolete)
Comment 5 Roman Kuznetsov 2021-08-13 19:47:33 UTC
still rerpo in

Version: / LibreOffice Community
Build ID: 18771471f75685a6d3838a22d16dcff5c398e652
CPU threads: 4; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
Calc: threaded