https://bugs.documentfoundation.org/show_bug.cgi?id=92453
Bug ID: 92453
Summary: Entire column functionality in formulae keyboard
shortcuts
Product: LibreOffice
Version: 5.1.0.0.alpha0+ Master
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
