Description: Grouping and collapsing to the last column, Ctrl + Right Arrow will not move the cursor. Steps to Reproduce: 1. Open New Calc. 2. select columns [D:XFD] , and group columns. ( F12 ) 3. Collapse the group. 4. Select Cell [A1] 5. Ctrl + Right Arrow Actual Results: 6. The cursor remains at [A1]. Expected Results: 6. The cursor moves to [C1]. Reproducible: Always User Profile Reset: No Additional Info: --- --- --- --- Reference Information If [D:XFC] is grouped and [XFD] is not, Ctrl + Right Arrow works. Ctrl + Shift + Right Arrow appears to work correctly. --- --- --- --- Not Reproduced with Version: 7.3.7.2 (x64) / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL Reproducible with Version: 7.5.9.2 (X86_64) / LibreOffice Community Build ID: cdeefe45c17511d326101eed8008ac4092f278a9 CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded Reproducible with Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 8501cb20627e5bc36d760b53b0990f4105c4ff65 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 10240); UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded
Reproducible with Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: default; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: threaded
There are some key factors in order to reproduce the problem: * Within the grouped cells, there is no data (empty blank cells) and there has been no cell format modification either. * The group includes the last column, XFD. * The group is at least 3 columns wide (e.g. XFB:XFD). If only the last 2 columns are grouped, there is no problem. All those conditions are needed in order to reproduce the problem. The equivalent problem with grouped rows (ctrl+down_arrow) instead of columns does not seem to be happening; this is happening with grouped columns only, not with rows. Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 8501cb20627e5bc36d760b53b0990f4105c4ff65 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded
BTW, the last column is XFD since LO 7.4, in which the problem is reproduced. The problem is not reproduced in LO 7.3, in which the last default column was AMJ. So this is at least a regression, but maybe this is also an implementation error. Simplified STR: 1. New Calc. 2.a. Introduce XFB:XFD in the Name box (and press [ENTER]). (or, alternatively, 2.b. [CTRL]+[R_arrow] and select the last 3 columns of the spreadsheet). 3. Press [F12] (in order to group the last 3 columns). 4. Click on the "-" mini-icon in order to collapse the group. 5. [CTRL]+[HOME]. 6. [CTRL]+[R_arrow] > no movement. Expected: After step 6, the active cell should be cell XFA1.
This bug also occurs when you hide a column. The cause is likely to be the same.
(In reply to nobu from comment #4) > This bug also occurs when you hide a column. The cause is likely to be the > same. Not just "a column"; you have to comply with the same conditions as in comment 2 in order to reproduce the problem. The only difference is that instead of hiding the group, you hide at least the last 3 columns.
(In reply to ady from comment #3) > BTW, the last column is XFD since LO 7.4, in which the problem is reproduced. > > The problem is not reproduced in LO 7.3, in which the last default column > was AMJ. > > So this is at least a regression, but maybe this is also an implementation > error. > Hm, probably not implementation error, because issue does occur on commit with XFD as the last column, so likely regression. -------------------------------------- Bibisected on win64-7.4. Added Luboš Luňák to cc. Regression introduced by https://git.libreoffice.org/core/+/dddee125cc32f1ad5228e598a7de04e9654e65c1 commit dddee125cc32f1ad5228e598a7de04e9654e65c1 [log] author Luboš Luňák <l.lunak@collabora.com> Thu Mar 10 15:03:25 2022 +0100 committer Luboš Luňák <l.lunak@collabora.com> Fri Mar 11 10:09:03 2022 +0100 tree 19c35052c83886c8807fa6d7d45d333b2e57eeac parent 69b5f0b6579c6574a8fe68ab2a64208ec767db55 [diff] ------------------------- Reproduced on: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 67dc0edb688d345607ae6afe3ad849f143804e28 CPU threads: 6; OS: Windows 11 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: dddee125cc32f1ad5228e598a7de04e9654e65c1 CPU threads: 6; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL BTW, my results are similar to ady's.
Luboš Luňák has not been active for some time now. Maybe someone else (from Collabora or elsewhere) will be able to resolve the issue. FTR and JIC, this is _not_ some corner case. It would help if someone would test with other OS.
Reproduced with both gen and gtk3 VCL plugins: Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 5a75414d1772d1fd998f405e3b9bd80b1f10c51f CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded