[Bug 119325] New: Multiple SelectionChanged events with no reason in Calc

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119325

          Priority: P3
            Bug ID: 119325
          Assignee: ooo-issues@incubator.apache.org
           Summary: Multiple SelectionChanged events with no reason in
                    Calc
          Severity: major
        Issue Type: DEFECT
    Classification: Application
                OS: Windows 7
          Reporter: j.tronel@hotmail.fr
          Hardware: PC
            Status: UNCONFIRMED
           Version: OOo 3.3
         Component: ui
           Product: spreadsheet

Created attachment 77522
  --> https://issues.apache.org/ooo/attachment.cgi?id=77522&action=edit
Select cells and click button to display number of events

Hello,

A SelectionChanged event seems to be triggered several times at a single
modification of cell selection in Calc. It even occurs four times (on my
system) when I click on an already selected cell!!!

Here is a sample Calc file with macros:
***************************************
Global count As Integer

Sub SelectionChanged(evt)
     count = count+1
     SelectionChanged=true
End Sub

Sub Display
     Print count
     count = 0
End Sub
***************************************

count is incremented each time SelectionChanged is executed (on a
SelectionChanged event in sheet 1).

Display is called by button on the same sheet and shows current value of count,
then resets it for further trials.

Now, select any cell or cell range (using mouse or keyboard) then click on the
button; strange isn't it?

If not wrong, I'd expect no event at all when the selection is not changed, and
just one when changed.

Badly needing that feature, I use this workaround:
***************************************
Global ref As String

Sub SelectionChanged(evt)
     If evt.absoluteName = ref then Exit Sub
     ref = evt.absoluteName
     'commands............
End Sub
***************************************
(supposing one will only select cells or cell ranges)

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 119325] Multiple SelectionChanged events with no reason in Calc

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119325

Li Feng Wang <ph...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |CONFIRMED
                 CC|                            |phoenix.wanglf@gmail.com
     Ever confirmed|0                           |1

--- Comment #4 from Li Feng Wang <ph...@gmail.com> ---
On AOO3.4 release version:
 1)when I click on an already selected cell many times, no more event to be
triggered.
 2)when I selected cell changed more than 2 times, event count is wrong.
 3)when select cell range, the number is strange. But I don't know how to count
the event number for this kind(select cell range via mouse)

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 119325] Multiple SelectionChanged events with no reason in Calc

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119325

--- Comment #1 from j.tronel@hotmail.fr ---
Bug related to bugs 108859, 111176

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 119325] Multiple SelectionChanged events with no reason in Calc

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119325

--- Comment #6 from j.tronel@hotmail.fr ---
Hi,

Bug still creeping as of version 4.0.0! (see previous attachment; being honest,
I notice just two macro calls when selecting a single cell; go on, this will be
solved in version 15!)

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.

[Bug 119325] Multiple SelectionChanged events with no reason in Calc

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119325

--- Comment #5 from j.tronel@hotmail.fr ---
Created attachment 81363
  --> https://issues.apache.org/ooo/attachment.cgi?id=81363&action=edit
click in any cell (ought to increment cell by one)

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.

[Bug 119325] Multiple SelectionChanged events with no reason in Calc

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119325

--- Comment #2 from j.tronel@hotmail.fr ---
An even more shocking and simpler demonstration of this behaviour is this short
code:

Sub Main(evt)
    If evt.SupportsService("com.sun.star.sheet.SheetCell") Then
        evt.value = evt.value+1
    End If
End Sub

It supposedly increments by one the newly selected cell (not an already
selected cell).

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 119325] Multiple SelectionChanged events with no reason in Calc

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119325

--- Comment #3 from j.tronel@hotmail.fr ---
Same behaviour using an XSelectionChangeListener

-- 
You are receiving this mail because:
You are the assignee for the bug.