Issue 126255 - DDE does not trigger XModifyListener
Summary: DDE does not trigger XModifyListener
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.1
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2015-04-20 18:10 UTC by Tom
Modified: 2015-04-29 16:08 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Tom 2015-04-20 18:10:24 UTC
I have placed an XModifyListener onto a cell which has a DDE link in it. The cell values are constantly changing but the listener is never triggered. The listener is only triggered if I manually type new info into the cell.

If I'm not mistaken, this bug has been known since at least Oct of 2011. See

Comment 1 oooforum (fr) 2015-04-29 08:44:47 UTC
I confirm that only user action is handle by events sheet.

If I assign through Edit > Sheet > Events a macro on "Content changed" event, any formulas does not trigger this macro.

I change issue type to ENHANCEMENT
Comment 2 Tom 2015-04-29 16:08:01 UTC
I understand your desire to re-characterize this bug as an enhancement request. And as I am not volunteering my time to produce, repair, and enhance this free software for the whole world to use, I will not complain if this enhancement request gets sidelined.

However, I do think it would be appropriate to change the name or explanation of these events so that it is clear to users that the events are not kicked off whenever a cell is modified, but rather only when the user actually edits a cell. The difference is far more than merely semantic. The events, as currently labeled and described, do not perform as any reasonable person would expect.