Bug 148459 - Spreadsheet selection misbehaves after element selected from cell data-validity dropdown
Summary: Spreadsheet selection misbehaves after element selected from cell data-validi...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-04-08 04:43 UTC by wajohnsen
Modified: 2022-10-14 03:18 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample worksheet with 2 values in drop-diwn (7.63 KB, application/octet-stream)
2022-07-18 06:57 UTC, klivmanis
Details

Note You need to log in before you can comment on or make changes to this bug.
Description wajohnsen 2022-04-08 04:43:41 UTC
Description:
After selecting an element from a dropdown list - produced by applying a Data Validity to a cell - and then selecting any other UI item outside the boundary of the worksheet cells, the selected worksheet cell changes.

Steps to Reproduce:
1. Select any cell *not* adjacent to the edge of a blank worksheet
2. Apply a Data...Validity...Criteria...Allow...List/Cell Range restriction to any cell 
3. Select from the dropdown icon next to the cell that received the data validity criteria
4. Select any element in the list
5. Do not click on any other cell in the worksheet
6. Click on any menu item or worksheet tab beyond the boundary of the worksheet cells


Actual Results:
The cell selected in step 1 changes to a different cell

Expected Results:
The cell in step 1 should remain as the selected cell


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.3.2.2 (x64) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Comment 1 giger.jonathan 2022-04-08 19:29:01 UTC
I can confirm this happens on my build. Note that the contents of the cell are not changing, the problem is just that a different cell gets selected. Also, the menu buttons are not "clicked" the first time they are clicked on, as in, they do not react.
Comment 2 giger.jonathan 2022-04-08 19:29:24 UTC
Version: 7.2.6.2 (x64) / LibreOffice Community
Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 3 ornanovitch 2022-06-09 10:44:18 UTC
I can confirm this is happening systematically. It all happens as if the cursor was still considered as inside the sheet

Version: 7.3.3.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.18; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
7.3.3-3
Calc: threaded
Comment 4 klivmanis 2022-07-18 06:57:26 UTC
Created attachment 181298 [details]
Sample worksheet with 2 values in drop-diwn

It seems that drop-downs capture the mouse cursor focus and fails to release it properly, or something like that.

Observed behaviour after selecting a value in drop-down:
*)Upon mouse click outside of Calc cells(buttons in toolbars, other application windows) the currently selected cell will change.
*)*buntu+KDE environment - Inactive windows do not receive mouse scroll events, scroll events are captured by the calc window.

Attached a sample worksheet, containing a dropdown with 2 values.

Additional information:
Version: 7.3.4.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 12; OS: Linux 5.17; UI render: default; VCL: gtk3
Locale: lv-LV (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.4-0ubuntu0.22.04.1
Calc: threaded
Comment 5 klivmanis 2022-10-13 06:43:17 UTC
Version: 7.3.6.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 12; OS: Linux 5.17; UI render: default; VCL: gtk3
Locale: lv-LV (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.6-0ubuntu0.22.04.1
Calc: threaded

At this version the behaviour has been fixed. Mouse cursor focus gets properly released.
Can this ticket be closed?
Comment 6 wajohnsen 2022-10-14 03:18:58 UTC
Yes, this bug can be closed. thank you.