Bug 120465 - The sheet event 'Content changed' is not raised if an array-formula was edited
Summary: The sheet event 'Content changed' is not raised if an array-formula was edited
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro
  Show dependency treegraph
 
Reported: 2018-10-09 16:49 UTC by Wolfgang Jäger
Modified: 2023-07-28 20:20 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
The demo announced in the report. (13.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-10-09 16:49 UTC, Wolfgang Jäger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Wolfgang Jäger 2018-10-09 16:49:33 UTC
Created attachment 145540 [details]
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)
Comment 1 raal 2018-10-09 19:06:27 UTC
I can confirm with Version: 6.2.0.0.alpha0+
Build ID: e9c1cbce903d325b1e19602d72765511589f5bf2
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
Comment 2 QA Administrators 2019-10-10 02:40:16 UTC Comment hidden (obsolete)
Comment 3 Wolfgang Jäger 2019-10-21 12:27:34 UTC
Bug still living in V 6.3.3.1
Comment 4 Wolfgang Jäger 2019-10-22 13:48:33 UTC
Might Eike throw a glance on this topic and the "see aöso"?
Comment 5 Wolfgang Jäger 2020-12-04 11:05:31 UTC
Bug still living in V 7.1.0.0.beta1
Comment 6 QA Administrators 2022-12-05 03:32:59 UTC Comment hidden (obsolete)
Comment 7 Wolfgang Jäger 2022-12-09 11:57:51 UTC
Tested with V 7.4.3.2 under Win 10: Bug still present; details unchanged.