Bug 128678 - EDITING Unable to unselect merged cells using arrows keys when selecting from bottom or right
Summary: EDITING Unable to unselect merged cells using arrows keys when selecting from...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Selection
  Show dependency tree / graph
 
Reported: 2019-11-09 00:30 UTC by nilskemail+bugzilla
Modified: 2023-08-06 10:40 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
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 nilskemail+bugzilla 2019-11-09 00:30:28 UTC 
Description:
When adding merged cells to a selection which are to the top or left of the initial cell it is not possible to unselect them using Shift+Arrow in the direction they are merged.
Unselecting them using a mouse or escaping the merged cell perpendicular to it's merged direction still works however.

When selecting a mix of normal and merged cells (using a mouse or Shift+Arrow) the behaviour can get pretty strange.
This can be tested by making a circle of merged cells (X: merged):
0 X X 0
X 0 0 X
X 0 0 X
0 X X 0
The selection mechanism can now be tested by select a cell in an inner or outer corner and adding more cells to the selection.
It can be observed that above problem does not occur when the initall selected cell is to the top and/or left oft the merged cells.

Steps to Reproduce:
1. Merge cells A1 and B1
2. Select cell C1
3. Press Shift+LeftArrow to add A1:B1 to the selection
4. Try to remove A1:B1 from the selection using Shift+RightArrow

Actual Results:
Step 4 is impossible and you can't remove the merged cells from the selection

Expected Results:
After either 1 or 2 presses of the right arrow the merged cells should be excluded from the selection


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.2.2
Build ID: 1:6.3.2-0ubuntu2

CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 1 Oliver Brinzing 2019-11-09 15:08:59 UTC 
(In reply to nilskemail+bugzilla from comment #0)
> Steps to Reproduce:
> 1. Merge cells A1 and B1
> 2. Select cell C1
> 3. Press Shift+LeftArrow to add A1:B1 to the selection
> 4. Try to remove A1:B1 from the selection using Shift+RightArrow
> 
> Actual Results:
> Step 4 is impossible and you can't remove the merged cells from the selection
> 
> Expected Results:
> After either 1 or 2 presses of the right arrow the merged cells should be
> excluded from the selection

i can confirm this behaviour with:

Version: 6.3.3.2 (x64)
Build-ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

and with:

LO Version 3.6.7.2 (Build ID: e183d5b)

but it works with AOO 4.1.5 and ms excel 2016
Comment 2 QA Administrators 2021-11-09 04:38:06 UTC Comment hidden (obsolete)
Comment 3 BogdanB 2023-05-29 16:04:43 UTC 
Also in
Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 583c3fcea50b69ca9d3cd866050c9e722a8f780b
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 4 ady 2023-07-10 22:51:21 UTC 
Working correctly as of:

Version: 24.2.0.0.alpha0+ (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

Probably related to the patch posted in bug 155796 comment 1 for 24.2; a back-port / cherry-pick for prior (current) versions is not yet available ATM.