Bug 167866 - Use validity function to cell range cause partial freeze of Calc
Summary: Use validity function to cell range cause partial freeze of Calc
Status: RESOLVED DUPLICATE of bug 166527
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-08-08 12:40 UTC by andis.lazdins
Modified: 2025-08-08 12:51 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description andis.lazdins 2025-08-08 12:40:01 UTC
Description:
When I'm choosing Validity > Cell range function and trying to select a cell range, I can't select it. I can't also switch to other sheet. When I close Validity dialogue, I can't any more switch other sheets and I can close the file only by killing application, while I can close the writer windows.

Steps to Reproduce:
1. Open LibreOffice Calc with a new, empty spreadsheet.
2. Create a second sheet (Sheet2) and enter some data into cells A1:A5. This data will be the source for the data validation list.
3. Go back to the first sheet (Sheet1).
4. Select a cell where you want to apply data validation (e.g., cell B2).
5. Go to Data > Validity....
6. Select Cell range and double click on Source so that small Validity window appears.
7. Move mouse to spreadsheet cells area and try to press on Seet2 or select any cell range in Sheet1. 

Actual Results:
It is not possible to select cell range in Sheet1 and not possible to switch to Sheet2, respectively, it is not possible to select any cell range. After closing Validity dialogue I can't switch to Sheet2 and I can't close file.

Expected Results:
I should be able to select any range in Sheet1 and switch to Sheet2 to select any range there.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 25.8.0.2 (X86_64)
Build ID: 80a8bc2ef75d415a197e282da0ebf917315d5e24
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: lv-LV (en_US.UTF-8); UI: en-US
Calc: CL threaded
Comment 1 nobu 2025-08-08 12:51:40 UTC

*** This bug has been marked as a duplicate of bug 166527 ***