Bug 92452 - Keyboard to select entire row or column or sheet when in formulae mode
Summary: Keyboard to select entire row or column or sheet when in formulae mode
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
QA Contact:
URL:
Whiteboard:
Keywords:
: 99280 (view as bug list)
Depends on:
Blocks: Shortcuts-Accelerators
  Show dependency treegraph
 
Reported: 2015-06-30 11:52 UTC by Óvári
Modified: 2016-05-11 11:05 UTC (History)
5 users (show)

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 Óvári 2015-06-30 11:52:48 UTC
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.
Comment 1 Óvári 2015-06-30 12:04:05 UTC
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
Comment 2 Óvári 2015-06-30 12:04:53 UTC
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
Comment 3 Buovjaga 2015-07-02 14:25:20 UTC
Sounds ok to me -> NEW.
Comment 4 Yousuf Philips (jay) 2016-03-07 09:28:29 UTC
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?
Comment 5 Óvári 2016-03-07 20:06:26 UTC
(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
Comment 6 raal 2016-05-11 11:05:40 UTC
*** Bug 99280 has been marked as a duplicate of this bug. ***