Bug 126221 - Frozen rows/columns + validity error + mouse click ends in range selection mode
Summary: Frozen rows/columns + validity error + mouse click ends in range selection mode
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Cell-Freeze
  Show dependency treegraph
Reported: 2019-07-04 06:15 UTC by Aron Budea
Modified: 2023-07-10 23:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Sample ODS (8.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-07-04 06:16 UTC, Aron Budea

Note You need to log in before you can comment on or make changes to this bug.
Description Aron Budea 2019-07-04 06:15:50 UTC
The attached spreadsheet includes:
- validity checks on the bordered cells,
- frozen rows + columns.

- Enter an invalid value in any of the bordered cells (eg. "a").
- Click somewhere else in the sheet. (don't just press Enter!)
- Dismiss the error dialog with clicking on OK or hitting Enter.
- Move mouse around.

=> You end up in range selection mode, as can be seen from the selection overlay.

Observed using LO 6.3 beta 2 & 3.3.0 / Windows 7.
Comment 1 Aron Budea 2019-07-04 06:16:21 UTC
Created attachment 152547 [details]
Sample ODS
Comment 2 Jacques Guilleron 2019-07-04 07:47:19 UTC
Hi Aron,

I reproduce with
LO (x86) Build ID: 719f4a93e46a6b397356dbb605d2867639ca3942
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: fr-FR (fr_FR); UI-Language: en-US Calc: CL
LO Version ID : 235ab8a-3802056-4a8fed3-2d66ea8-e241b80
So probably inherited from OOo

Comment 3 QA Administrators 2021-07-04 04:37:02 UTC Comment hidden (obsolete)
Comment 4 Aron Budea 2021-07-04 16:18:10 UTC
Still in LO Version: (5e37a1d89dfaa12690841213bce0cb6d05faf90a) / Ubuntu.
Comment 5 QA Administrators 2021-07-05 03:47:40 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2023-07-06 03:15:20 UTC Comment hidden (obsolete)
Comment 7 ady 2023-07-10 23:27:53 UTC
Still present in:

Version: (X86_64) / LibreOffice Community
Build ID: 81726f5af5fda25f0d92ffc8458d7f24eb16f408
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (es_AR); UI: en-US
Calc: CL threaded

Built: 2023-07-10