Bug 155695 - No keyboard shortcut to go to the end of the sheet on macOS
Summary: No keyboard shortcut to go to the end of the sheet on macOS
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.2.2 release
Hardware: All macOS (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Shortcuts-Mac
  Show dependency treegraph
 
Reported: 2023-06-05 20:18 UTC by Dan Dascalescu
Modified: 2023-11-08 18:44 UTC (History)
3 users (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 Dan Dascalescu 2023-06-05 20:18:26 UTC
On macOS, it appears there's no keyboard shortcut to go to the end of the sheet.

Fn+Ctrl+DownArrow should do that.
Comment 1 Dan Dascalescu 2023-06-05 20:20:20 UTC
Use case: in any sheet tracking items chronologically (e.g. transactions), most often the input will happen at the end of the sheet. The inability to navigate they by keyboard is quite irritating, because navigating by pressing Fn+DownArrow repeatedly, or with the mouse/touchpad, are much slower.
Comment 2 steve 2023-10-30 13:18:58 UTC
macOS 13.6.1 + Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: b40e469887d973e1eea242749a90c3c2370da3a5
CPU threads: 8; OS: macOS 13.6.1; UI render: Skia/Raster; VCL: osx
Locale: en-US (en_DE.UTF-8); UI: en-US
Calc: threaded

Was able to reproduce that end key (fn + right arrow on laptop keyboards) does not go to last row with data. Currently it does nothing.

Marking this "new" and setting "enhancement" as this seems to be new functionality.
Comment 3 mbintener 2023-11-01 20:17:01 UTC
(In reply to Dan Dascalescu from comment #0)
> On macOS, it appears there's no keyboard shortcut to go to the end of the
> sheet.
> 
> Fn+Ctrl+DownArrow should do that.

Hello. I have just tried to replicate the issue on my Mac (macOS 14.1, LibreOffice 7.6.2.1). While Fn + Ctrl + Down does not work, hitting Cmd + Down should do the trick. Please note that you first need to select a cell in a column that contains data. Cmd + Down will then move the focus to the last cell in that column with data in it. If you do this with an empty cell selected, the focus will then shift to the very last cell in the spreadsheet, e.g. A1048576.
Comment 4 bintoro 2023-11-08 18:44:38 UTC
The shortcut to jump to the last cell of the sheet (i.e., the intersection of the last row & column that have data in them) is Cmd-End (or Fn-Cmd-Right). Correspondingly, Cmd-Home jumps to A1.

> Was able to reproduce that end key (fn + right arrow on laptop keyboards) 
> does not go to last row with data. Currently it does nothing.

AFAIK Home & End are supposed to jump to the first and last column, respectively. Can someone confirm that this doesn't work by default?

The actions in the keyboard shortcuts list are confusingly named, though. Home & End are bound to "To Document Begin" and "To Document End", which in Writer refer to jumping to the top and bottom of the document. But in Calc they refer to the UNO commands "GoToStartOfRow" and "GoToEndOfRow", respectively. The actions that jump to the ends of the worksheet are listed as "To File Begin" and "To File End".