Issue 126255

Summary: DDE does not trigger XModifyListener
Product: Calc Reporter: Tom <t_hafner>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: oooforum
Version: 4.1.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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.