https://bugs.freedesktop.org/show_bug.cgi?id=86786
Bug ID: 86786
Summary: OpenOffice crashing when a macro is triggered by a
change listener
Product: LibreOffice
Version: 4.3.4.1 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Created attachment 110126
--> https://bugs.freedesktop.org/attachment.cgi?id=110126&action=edit
Sample spreadsheet to reproduce the problem
Description:
I am trying to create a change listener (XModifyListener) and associate it with
several cells (not the cell range, since I want the source object of the event
to be the modified cell only).
The macro executed creates a new sheet from a template (copyByName).
Actual results:
Depending on the version of LibreOffice and OS I run into various issues...:
- On Linux with 4.3.4.1, LibreOffice simply crashes when the macro completes.
- On Windows with 4.2.5.2, I continuously get the message "Protected cells can
not be modified" and I have to forcefully kill LibreOffice.
With the sample spreadsheet that I attached, it looks like I can sometimes
modify one cell without running into the error, but it eventually fails on
subsequent attempts.
Note: the macro is working perfectly fine when it is not triggered by the
listener...
On the more complex spreadsheet that I am working on, I also noticed that the
events are triggered when I delete the sheets with the DeleteSheet macro, even
though this doesn't modify the cells associated with the listener (but will
change other cells in the same sheet).
Steps to reproduce the crash/error with the sample provided:
- open the document.
- run the macro 'AddChangeListener' (this adds a listener on Monitored.A1:A3)
- modify any cell from Monitored.A1:A3
- a new sheet (a cpoy of the 'Template' sheet) should get created.
=> if there is no error/crash, try to modify another value, LO will eventually
crash.
Note that you can run the macros 'CreateSheet' and 'DeleteSheet' any number of
times without any problem as long as they are not triggered by the listener (so
if the macro is executed manually rather than by change the cell value).
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
