Bug 102700

Summary: UI - data selection
Product: LibreOffice Reporter: esteban521
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: heiko.tietze, miguelangelrv
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 109139    

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 
Fine
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.