LibO on Windows XP.
You can use the keyboard shortcuts Ctrl+Arrow to move in any of the four arrow directions to the end of the current data range, and Ctrl+Shift+Arrow to select from the current cell to the end of the data range. You would expect this to work when entering a formula: the formula-editing process allows you to move to and select cells whose references are then inserted into the formula.
However, when entering a formula, none of Ctrl+Down Arrow, Ctrl+Up Arrow, Ctrl+Shift+Down Arrow and Ctrl+Shift+Up Arrow work correctly: they move to or select to the edge of the spreadsheet, not the end of the data range.
Strangely, all of Ctrl+Left Arrow, Ctrl+Right Arrow, Ctrl+Shift+Left Arrow and Ctrl+Shift+Right Arrow do all work correctly: they move to or select to the end of the data range.
Thanks for bugreport
Please, verify if in last version of LibreOffice still reproducible
I am marking this as WORKSFORME as everything I tried seemed to work flawlessly with LibO 126.96.36.199. If this is still a problem for you can you reopen as UNCONFIRMED and provide your LibO version.
Thanks in advance
*** This bug has been marked as a duplicate of bug 37230 ***