Bug 92453 - Entire column functionality in formulae keyboard shortcuts
Summary: Entire column functionality in formulae keyboard shortcuts
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.0.0.alpha0+ Master
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 96969
Blocks: Shortcuts-Accelerators
  Show dependency tree / graph
 
Reported: 2015-06-30 11:59 UTC by Óvári
Modified: 2016-04-17 21:56 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Óvári 2015-06-30 11:59:35 UTC 
Microsoft Excel entire column notation in formulae functionality
1. In cell A1 enter: =SUM(
2. Press the right arrow once (you should be in cell B1), and the formula in cell A1 should be: =SUM(B1
3. In Microsoft Excel, press Ctrl+SpaceBar (this selects the entire column), and the formula in cell A1 should be: =SUM(B:B
4. Press enter, and the formula in A1 autocompletes the right parentheses: =SUM(B:B)

Eike Rathke has done wonderful work in enabling LibreOffice to understand entire row(s)/column(s) 1:1/A:A notation in formulae.

However, LibreOffice 5.1.0.0.alpha1+ doesn't understand step 3 above, i.e. the keyboard shortcut:
Ctrl+SpaceBar to select an entire column.
Comment 1 Buovjaga 2015-07-02 14:34:14 UTC 
Alrighty -> NEW.
Comment 2 Óvári 2016-01-09 10:19:27 UTC 
Bug 92453 depends on bug 96969
Bug 96969 blocks bug 92453