Bug 124679 - Calc: implement a feature for keyboard users to type select-ranges
Summary: Calc: implement a feature for keyboard users to type select-ranges
Status: CLOSED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.0.beta1+
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: accessibility
Depends on:
Blocks:
 
Reported: 2019-04-11 09:40 UTC by Victor
Modified: 2019-04-11 16:43 UTC (History)
0 users

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 Victor 2019-04-11 09:40:04 UTC
Description:
Hi
If user needs to select cell contents from range a1 to g100. How to do it?
Someone may not able to use mouse to select it.
Could we implement a feature for keyboard users to type select-ranges?



Steps to Reproduce:
1. Open Calc.
2. Select a1 through g100.

Actual Results:
case1: Press shift+arrows to select the range.


case2: To select a range, select a cell, then hold the right bottom edge and drag over the cell range. 



Expected Results:
Could we implement "go to" function for keyboard user to type ranges? E.G. (a1:g100)



Reproducible: Always


User Profile Reset: No



Additional Info:
In Excel, we could get this feature by pressing f5 and typing ranges.
Comment 1 Eike Rathke 2019-04-11 10:25:09 UTC
It already exists:
Press Shift+Ctrl+T to go to the Name Box
Enter A1:G100
Hit Enter

Next please ask on https://ask.libreoffice.org/ first if a functionality exists. Thanks.
Comment 2 Victor 2019-04-11 16:43:24 UTC
(In reply to Eike Rathke from comment #1)
> It already exists:
> Press Shift+Ctrl+T to go to the Name Box
> Enter A1:G100
> Hit Enter

Thank you for the quick reply. This feature is very useful.

Confirmmed: Do we have already added this shortcut (control+shift+t) to the document [Shortcut Keys for Spreadsheets - LibreOffice Help](https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets).
Or could we find this feature in the edit menu?

Thank you for your kindly assistance.