Issue 127378 - Handlers / Listeners are being disconnected but still exists during BASIC code edition
Summary: Handlers / Listeners are being disconnected but still exists during BASIC cod...
Status: UNCONFIRMED
Alias: None
Product: App Dev
Classification: Unclassified
Component: vba (show other issues)
Version: 4.2.0-dev
Hardware: PC All
: P5 (lowest) Normal
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-03-28 13:14 UTC by s1w_
Modified: 2017-03-29 13:16 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Calc sheet with events to run and description (12.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-03-28 16:49 UTC, s1w_
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description s1w_ 2017-03-28 13:14:07 UTC
When BASIC source is being modified, variables are being resetted. There remain problem with Listeners / Handlers, where only link to them is removed, but they still exists. During every code RUN, they are being duplicated / triplicated...

There is no way to detect duplicated handlers (IsNull variable is useless while Handlers loose their link to variable).
Comment 1 mroe 2017-03-28 13:40:59 UTC
Please provide a document with a code snippet, with that the problem can be reproduced.
Comment 2 s1w_ 2017-03-28 16:49:17 UTC
Created attachment 85996 [details]
Calc sheet with events to run and description
Comment 3 oooforum (fr) 2017-03-28 18:46:13 UTC
Instead of coding listeners, use inner events with menu Edit > Sheets > Events...
Comment 4 s1w_ 2017-03-29 13:16:30 UTC
oooforum (fr): I have reported anomaly, what does it have to do with what i do?

I am tired of those comments like "I know better about ur needs", have you took into consideration, that I needed a code that was formatting whole csv into ods that enduser wouldnt bother about creating events that they even dont understand?

Anyway this issue occurs only while editing basic, so its not my nor enduser problem, but inadvertency of mechanism.