Bug 98296 - UNO Commands to insert a new sheet to the left and right of the current sheet
Summary: UNO Commands to insert a new sheet to the left and right of the current sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.0.0.alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval, topicUI
Depends on:
Blocks: UNO-Command-New
  Show dependency treegraph
 
Reported: 2016-03-01 07:34 UTC by Yousuf Philips (jay) (retired)
Modified: 2016-03-02 06:50 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 Yousuf Philips (jay) (retired) 2016-03-01 07:34:46 UTC
We currently have an UNO command to open up the Insert Sheet dialog (.uno:Insert), but we dont have UNO commands that could have shortcuts attached to them that would make it easy to insert a new sheet by keyboard.

The new UNO commands should likely be named .uno:InsertSheetLeft and .uno:InsertSheetRight and should have the shortcuts Shift + F10 and Shift + F11.
Comment 1 Regina Henschel 2016-03-01 16:33:54 UTC
I think, a new uno command is not necessary.

We have
.uno:Insert (Insert Sheet, category Insert)
It opens full Insert dialog. Because it has 'Before' preselected, it works fine for insert left.

But we have also
.uno:Add (Append Sheet, category Insert)
It opens a name field with default name and preselect OK. It inserts right.

.uno:Move (Move or Copy Sheet, category Edit)
It opens a dialog which you can use with tab and arrow-keys.

.uno:Remove (Delete Sheet, category Edit)
It deletes the active sheet.

We have Ctrl+PageUp/Down for sheet tab navigation.

So there are enough commands to assign to a shortcut key and methods for using only keyboard.



The shortcut Shift-F10 is not possible, because it is against Windows guidelines[1], there it is shortcut for opening the context menu.

[1] https://msdn.microsoft.com/en-us/library/ms971323 | section "General Shortcut Keys for Applications"


Combinations with F11 are used for things around styles, and therefore it is not good to mix it with sheet management. Currently Shift+F11 in Calc opens the Template Manager. [It might be good to make the F11, Shift+F11, Ctrl+F11 consistent for all modules, but that is another issue.]
Comment 2 Yousuf Philips (jay) (retired) 2016-03-02 06:50:23 UTC
(In reply to Regina Henschel from comment #1)
> I think, a new uno command is not necessary.

It isnt a necessity, but it still is an advantage to keyboard users who like their shortcut keys not to immediately do an action and not show a dialog.

> We have
> .uno:Insert (Insert Sheet, category Insert)
> It opens full Insert dialog. Because it has 'Before' preselected, it works
> fine for insert left.

True.

> But we have also
> .uno:Add (Append Sheet, category Insert)
> It opens a name field with default name and preselect OK. It inserts right.

Thanks as i didnt know about this and will add it to the menu bar.

> .uno:Move (Move or Copy Sheet, category Edit)
> It opens a dialog which you can use with tab and arrow-keys.
> 
> .uno:Remove (Delete Sheet, category Edit)
> It deletes the active sheet.
> 
> We have Ctrl+PageUp/Down for sheet tab navigation.
> 
> So there are enough commands to assign to a shortcut key and methods for
> using only keyboard.

Never thought to add shortcut keys for Move and Remove, but am welcome to suggestions for new shortcuts key.

> The shortcut Shift-F10 is not possible, because it is against Windows
> guidelines[1], there it is shortcut for opening the context menu.
> 
> [1] https://msdn.microsoft.com/en-us/library/ms971323 | section "General
> Shortcut Keys for Applications"

Thanks for noticing. :D

> Combinations with F11 are used for things around styles, and therefore it is
> not good to mix it with sheet management. Currently Shift+F11 in Calc opens
> the Template Manager. [It might be good to make the F11, Shift+F11, Ctrl+F11
> consistent for all modules, but that is another issue.]

I've proposed changing the various F11 style shortcuts (bug 98333) as they are are not constant across apps/modules. Shift + F11 is a shortcut used in spreadsheet apps (Excel, Google Sheets, WPS/Kingsoft) to create a new sheet and this combination should be ideally also be present in Calc.