Bug 150004 - Validation dropdown stays visible when changing rows/columns
Summary: Validation dropdown stays visible when changing rows/columns
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.4.2 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Validity
  Show dependency tree / graph
 
Reported: 2022-07-15 11:19 UTC by Gabor Kelemen (allotropia)
Modified: 2024-01-15 10:45 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Example file to demonstrate the issue (11.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-07-15 11:19 UTC, Gabor Kelemen (allotropia) 		Details
The example file before changes (40.10 KB, image/png)
2022-07-15 11:26 UTC, Gabor Kelemen (allotropia) 		Details
After inserting a row above, the dropdown is still visible in B2, yet it has no validation set (94.54 KB, image/png)
2022-07-15 11:28 UTC, Gabor Kelemen (allotropia) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2022-07-15 11:19:40 UTC 
Created attachment 181277 [details]
Example file to demonstrate the issue

This is similar to bug 61623

The attached file contains a validation in B2.
Several column/row/cell operations change the position of the validated cell, and the validation dropdown is still visible after these. However changing the cell selection makes it disappear.

1, Open attached file
2, Select a value from the validation dropdown and keep the cell selection on the B2 cell.
3, Do one of the below operations:
Sheet - Insert cells - (choose any option)
Sheet - Delete cells - (choose any option)
Sheet - Insert rows - Row above
Sheet - Insert columns - Column before
Sheet - Delete rows
Sheet - Delete columns
Sheet - Fill cells - Fill Down/Fill Up/Fill Right/Fill Left

There should be no dropdown visible, since it disappears after a click inside the highlighted cell.

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 11937a68aecb8db9aebb1c929d940c5b85a0ecec
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded
Comment 1 Gabor Kelemen (allotropia) 2022-07-15 11:26:49 UTC 
Created attachment 181278 [details]
The example file before changes
Comment 2 Gabor Kelemen (allotropia) 2022-07-15 11:28:31 UTC 
Created attachment 181279 [details]
After inserting a row above, the dropdown is still visible in B2, yet it has no validation set
Comment 3 Rafael Lima 2022-07-15 23:15:50 UTC 
Repro with

Version: 7.3.4.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.4-0ubuntu0.22.04.1
Calc: threaded

Also repro in

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 61f5c991a97de8990badfed6ef840941b5aa8c7f
CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Calc: threaded

The dropdown arrow remains visible even when you delete the cell that contains it. Clicking any other cell updates the view.

Another bug: in 7.5 the selection list is opening in the wrong position, way below cell B2. In Lo 7.3.4 the selection list opens right below cell B2 (as expected).