Bug 155796 - Deselecting merged cells using Shift+⬆ doesn't work in some cases
Summary: Deselecting merged cells using Shift+⬆ doesn't work in some cases
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:24.2.0 target:7.6.1
Keywords:
Depends on:
Blocks: Cell-Selection
  Show dependency treegraph
 
Reported: 2023-06-12 19:37 UTC by Aron Budea
Modified: 2024-05-12 20:32 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 Aron Budea 2023-06-12 19:37:03 UTC
- In an empty spreadsheet, merge cells A1:A3 and A4:A6,
- Starting A1:A3, select A4:A6 using Shift+⬇,
- Try going back up using Shift+⬆.

=> Doesn't work, the selection alternates between A1:A5 and A1:A6.

Reproduced in LO 7.6.0.0.alpha0+ (1f373260cf25ca2f36a929e1a27fde00641e5c09) / Ubuntu.
In 3.3.0 the second step fails already, so it can be assumed it never worked.

Seems similar to bug 128678, but the steps and result are slightly different.
Comment 1 Commit Notification 2023-07-07 06:59:53 UTC
Jaume Pujantell committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/341029de72cf957b7bc7775e51544070d4a49874

tdf#155796 sc: fix select with merged cells

It will be available in 24.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 2 ady 2023-07-07 08:32:48 UTC
I have not tested the result of the patch yet. I will test this as soon as I can, but in the meantime...

Quote from the aforementioned commit:

"
When selecting multiple cells or modifying a selection with shift+arrow
make sure that a merge group is never partially selected.
"

I'm not sure such limitation is adequate. Selection should be allowed however users want and need, considering that every cell can have its own content even when it is displayed as merged with others. Such need can be seen in bug 155799.
Comment 3 ady 2023-07-10 22:14:31 UTC
This bug 155796 is not yet ASSIGNED and the ASSIGNEE field is still "not assigned", in spite of the patch in comment 1.

Tested ok with:

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

I would guess that a back-port / cherry-pick for LO 7.6 would be possible?
Comment 4 Commit Notification 2023-08-03 08:31:46 UTC
Jaume Pujantell committed a patch related to this issue.
It has been pushed to "libreoffice-7-6":

https://git.libreoffice.org/core/commit/39aa1f6424390821579bfb6b6ba14e9ce11040ce

tdf#155796 sc: fix select with merged cells

It will be available in 7.6.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.