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 22.214.171.124.alpha1+ doesn't understand step 3 above, i.e. the keyboard shortcut:
Ctrl+SpaceBar to select an entire column.
Alrighty -> NEW.
Bug 92453 depends on bug 96969
Bug 96969 blocks bug 92453