- 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.
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.
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.
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?
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.