https://bugs.documentfoundation.org/show_bug.cgi?id=165369
Bug ID: 165369
Summary: Confusing and erroneous behaviour of spreadsheet using
"Selection changed" event
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 199361
--> https://bugs.documentfoundation.org/attachment.cgi?id=199361&action=edit
Simple sheet demonstrating the described behaviour
The attached Calc document has set a very simple event handler for "Selection
changed" included by Basic code. The sheet shows very strange behaviour:
58 =SHOWCOUNTCALLS() + NOW()*0 [58 is the shown result of the formula.]
If I select a different single cell using the arrow (cursor) keys,
the counter value increases by 1 per step as expected.
If the selection of a range is extended or reduced by Shift+Arrow,
the counter increases by 2 per step.
If I select by clicking into a differeent cell the counter increases by 4.
An additional click into the cell already having the focus, the counter
increases by 3.
Lots of additional issues.
How to explain this behaviour?
IMO it's a bug making a reasonable usage of the event "Selection changed" next
to impossible
In addition: Having set a handler like in this example disallows manual editing
of cell contents!
(AOO 4.1.7: Similar, but different in some details.)
Can there ever have been a reliable usage of the event?
--
You are receiving this mail because:
You are the assignee for the bug.
