Bug 102700 - UI - data selection
Summary: UI - data selection
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Selection
  Show dependency treegraph
Reported: 2016-09-27 21:02 UTC by esteban521
Modified: 2019-02-16 07:58 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description esteban521 2016-09-27 21:02:14 UTC
If you have a column of lets say 200 cells and you select the column by left clicking the first entry and while holding the button down you scroll down selecting the rest of the column, in LO Calc you will likely go past the last entry and continue selecting empty cells. If you need a precise selection of only the data filled cells, you will have to go back up and caferfully reverse the selection of empty cells.

MS office slows down the automatic scrolling speed when reaching the end of the column and stops briefly at the last entry. This functionality is really useful
Comment 1 m_a_riosv 2016-09-27 21:27:51 UTC
Comment 2 brucehohl 2016-09-28 01:25:03 UTC
If you need a precise selection of only the data filled cells ... Assumes an empty cell/row at end of data range.

You can do this:
(1) Click / move to the first cell in the column.
(2) Press Shift+Ctrl+DownArrow

Much faster & more precise than using mouse scrolling or paging.
Accomplished without annoying automatic speed changes or pauses.
Shift+Ctrl+RightArrow to select additional columns.
Comment 3 Heiko Tietze 2016-09-29 09:49:16 UTC
I agree with Bruce on the WONTFIX. Automatic scrolling isn't a precision feature. The effort to slow down scrolling speed should rather spend somewhere else.
Comment 4 m_a_riosv 2016-09-29 17:15:45 UTC
I'm used to the keyboard but it's no practice when in the middle there are empty cells.

There is [Shift+End] to select up the highest column with data on the sheet, but there is no a short-key for rows.

For Who are accustomed to using the mouse for selection it's really nice.