https://bugs.documentfoundation.org/show_bug.cgi?id=120465
Bug ID: 120465
Summary: The sheet event 'Content changed' is not raised if an
array-formula was edited.
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 145540
--> https://bugs.documentfoundation.org/attachment.cgi?id=145540&action=edit
The demo announced in the report.
If the sheet event 'Content changed' (so described in the dialog) got assigned
a user Sub, this Sub is (shoud be) called everytime something was edited in the
sheet. (The event should be renamed "Content edited" as it also is raised if
editing results in unchanged content.)
This works with entereing, deleting, editing any content of type text or
number.
It also works if ordinary formulas are edited, if "=sqrt(2)" gets replaced with
"=PI()" e.g.
The routine is NOT called if a formula for array-evaluation is entered or
edited.
(Del and Undo are a different thing in this case.)
This even holds if a formula is/was unnecessarily entered for array evaluation,
and does not lock an output range.
The attached example contains a extremely simple Sub assigned to the mentioned
event.
Edit any of the formulas therein to verify may claim for all the mentioned
cases.
This is "heritage". I even created the example with V3.3.
However, I stumbled over the behaviour using V6.1.1.2. (release)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
