Description: Using keyboard shortcut Ctrl+Page Down changes focus to next sheet, but not to the same cell. E.g. when cell B2 in Sheet1 is focused, pressing Ctrl+PageDown results in lately focused cell in Sheet2, not in cell B2. Similarly for a keyboard shortcut Ctrl+Page Up. Calc Guide (p. 28) states: "Ctrl+Page Down/Ctrl+Page Up Moves focus to the same cell on the next sheet to the right/left in sheet tabs if there are more sheets in that direction." Steps to Reproduce: 1. Change focus to specific cell (i.e. B2) in multi-sheet Calc document. 2. Press keyboard shortcut Ctrl+Page Down or Ctrl+Page Up. Actual Results: Focus moves to the next or previous sheet, but not to the same cell (i.e. B2) Expected Results: Focus moves to the next (when Ctrl+Page Down) or previous (Ctrl+Page Up) sheet AND to the same cell. Reproducible: Always User Profile Reset: No Additional Info: Verze: 6.4.4.2 ID sestavení: 6.4.4-1 Vlákna CPU: 4; OS: Linux 5.6; Vykreslování UI: výchozí; VCL: gtk3; Národní prostředí: cs-CZ (cs_CZ.utf8); Jazyk UI: cs-CZ Calc: threaded
Commands are: 'To Next Sheet' -- <Ctrl>+<Tab> or <Ctrl>+<PgDwn> -- .uno:JumpToNextTable or 'To Previous Sheet' -- <Ctrl>+<Shift>+<Tab> or <Ctrl>+<PgUp> -- .uno:JumpToPrvTable Current movement between sheets is consistent and expected. The Cell holding focus on sheet is maintained moving sheet to sheet. <Ctrl>+<Home> is available to reposition focus to the A1 cell on active sheet. See no reason to change. IMHO => NAB, and WF as enhancement.
Would also think it's by design. While some use cases may require to stick to the selected cell, the majority wants to keep the last position per sheet. So you better put a few lines of code together in a macro that gather the currently active cell, executes the next/previous sheet command, and focus the same cell. Shouldn't be too hard- and we have a cool macro team that is eager to help.
calc guide 4.1 (CG41-CalcGuideLO.odt) just loaded from https://documentation.libreoffice.org/en/english-documentation/calc/ says on pages 26 and 27: 'move to next sheet', but nothing about 'same cell',
(In reply to b. from comment #3) > calc guide 4.1 (CG41-CalcGuideLO.odt) just loaded from > https://documentation.libreoffice.org/en/english-documentation/calc/ says on > pages 26 and 27: 'move to next sheet', but nothing about 'same cell', While the 6.2 Calc guide, page 28 suggests a documentation issue: <quote> Ctrl + Page Down / Ctrl + Page Up Moves focus to the same cell on the next sheet to the right/left in sheet tabs if there are more sheets in that direction. </quote> That is not correctly notated. Does not match behavior, or the related Help [2]. =-ref-= [1] https://wiki.documentfoundation.org/images/c/c2/CG62-CalcGuide.pdf pg 28 [2] https://opengrok.libreoffice.org/xref/help/source/text/scalc/04/01020000.xhp?&h=188
yeah ... with reference it's much clearer ... your version is more recent ... but the guide is changed without changing the program? -> find the author of the guide, ask him why ... as current behaviour is quite easier for users i'd suggest enh. request, change guide.
(In reply to b. from comment #5) > yeah ... with reference it's much clearer ... > > your version is more recent ... but the guide is changed without changing > the program? -> find the author of the guide, ask him why ... > > as current behaviour is quite easier for users i'd suggest enh. request, > change guide. As it happens I am presently reviewing the section in the pending 6.4 Calc guide detailing keyboard shortcuts. The 6.4 Guide states only that CTL + Pg Up goes to next sheet (if there is one) and CTL+Pg Down goes the the previous page. No mention of 'same cell'.
(In reply to Drew Jensen from comment #6) > (In reply to b. from comment #5) > > yeah ... with reference it's much clearer ... > > > > your version is more recent ... but the guide is changed without changing > > the program? -> find the author of the guide, ask him why ... > > > > as current behaviour is quite easier for users i'd suggest enh. request, > > change guide. > > As it happens I am presently reviewing the section in the pending 6.4 Calc > guide detailing keyboard shortcuts. > > The 6.4 Guide states only that CTL + Pg Up goes to next sheet (if there is > one) and CTL+Pg Down goes the the previous page. No mention of 'same cell'. Oops - wrote that backwards Pg Up is previous and Pg Down is next sheet in the Guide.
The last active cell is remembered for each sheet individually on purpose. This behaviour should not be changed, one doesn't want to lose the last position just by switching sheets. The 6.2 guide is wrong, likely it was described after having added other sheets and all had the default first cell cursor position A1.