Microsoft Excel entire row notation in formulae functionality 1. In cell A1 enter: =SUM( 2. Press the down arrow once (you should be in cell A2), and the formula in cell A1 should be: =SUM(A2 3. In Microsoft Excel, press Shift+SpaceBar (this selects the entire row), and the formula in cell A1 should be: =SUM(2:2 4. Press enter, and the formula in A1 autocompletes the right parentheses: =SUM(2:2) 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: Shift+SpaceBar to select an entire row.
Please accept my apologies for any confusion. LibreOffice does understand Shift+Space to select an entire row; however, not when it is used when creating a formula. Hence this bug relates to allowing it to be utilised while creating a formula. Thank you
Please accept my apologies for any confusion. LibreOffice does understand Shift+Space to select an entire row; however, not when it is used when creating a formula. Hence this bug relates to allowing Shift+Space (entire row selection) to be utilised while creating a formula. Thank you
Sounds ok to me -> NEW.
I would assume that in addition to full row selection, full column selection (Ctrl + Space) would also be wanted in formula edit mode. @Eike: Is this something feasible?
(In reply to Yousuf (Jay) Philips from comment #4) > I would assume that in addition to full row selection, full column selection > (Ctrl + Space) would also be wanted in formula edit mode. Additionally, entire sheet selection ( Ctrl+Shift+Space && Ctrl+A ) in formula edit mode. Thank you
*** Bug 99280 has been marked as a duplicate of this bug. ***
Hello! The article is really useful, I think it helps me improve my Microsoft Excel software skills. You should refer to the article https://geometrydashdeadlocked.com/ to have more skills on editing and creating on Excel.