As inserting and removing cells, rows and columns are the number one function used in calc, it would be useful to add keyboard shortcuts for the addition and removal of rows and columns, as a number of users are setting them themselves. We currently have [Ctrl + plus] to adding a cell and [Ctrl + minus] for deleting a cell and i was thinking that we could use Ctrl + Insert for insert row, Ctrl + Delete for delete row, Ctrl + Shift + Insert for insert column and Ctrl + Shift + Delete for delete column.
Potencially dangerous actions should not have shortcuts.
(In reply to Urmas from comment #1) > Potencially dangerous actions should not have shortcuts. I dont see how it is potentially dangerous when you can undo.
This is a fine enhancement request but should get UX input. Marking as NEW for now and requesting UX team to have a look.
Working with shortcuts, I hit Shft+Space and then Ctrl++ Or Ctrl+Shft+Space and then Ctrl+- or somesuch. People working with shortcuts should need to know that, so no need to add more. (And potential conflicts maybe)
(In reply to Cor Nouws from comment #4) > Working with shortcuts, I hit Shft+Space and then Ctrl++ > Or Ctrl+Shft+Space and then Ctrl+- > or somesuch. > People working with shortcuts should need to know that, so no need to add > more. > (And potential conflicts maybe) Yep i had checked what the shortcuts for Excel by searching and they were saying the same thing of using a combination, but of course we cant include that combination in the menu. :D
(In reply to Jay Philips from comment #5) > saying the same thing of using a combination, but of course we cant include > that combination in the menu. :D Hmm, that's true. Still I'm hesitant because I expect that this is quite invasive to change for heavy key board users / different platforms...
(In reply to Cor Nouws from comment #6) > Still I'm hesitant because I expect that this is quite invasive to change > for heavy key board users / different platforms... Its not being changed, we are simply adding a direct means of them doing these functions to supplement the combination approach.
(In reply to Jay Philips from comment #7) > Its not being changed, we are simply adding a direct means of them doing > these functions to supplement the combination approach. Yes, that is clear. sorry. I mean that it may conflict with use of the combinations in various environments. And in editing mode of a cell, the Ctrl+DEL deletes a whole word , Ctrl+Shift+DEL the rest of a sentence. Ctrl+Ins is used for pasting .. I'm rather undecided about this. Would really love the opinion of other heavy spreadsheet users.
(In reply to Jay Philips from comment #0) > We currently have [Ctrl + plus] to adding a cell and [Ctrl + minus] for > deleting a cell and i was thinking that we could use Ctrl + Insert for > insert row, Ctrl + Delete for delete row, Ctrl + Shift + Insert for insert > column and Ctrl + Shift + Delete for delete column. Ctrl+Insert is an alternative for Copy (along with Shift+Insert for Paste). And the question is where you insert the new column/row - left or right. Okay, right now it's only the col left and the row above which can be added by menu. My first idea was ctr+left/right/up/down but these shortcuts are used to jump to the next filled cell (I use it always). And together with Shift it selects the cells between the current and the next one. Alt+left/right increases/decreases the col width; we could override this IMHO. On the other hand, it's in fact dangerous to just press two buttons and loose all data. If you don't see it immediately the undo function wouldn't help. Therefore my (non-working) shortcuts do only add cols/rows. Putting all together I think we should keep the current behavior. If it's unclear where col/rows should be added/deleted, a dialog is shown (unclear in terms of only one or a few cell are selected). However when a column or row is selected the shortcut works immediately as expected. And the new toolbar buttons makes it very easy to modify the sheet.
(In reply to Cor Nouws from comment #8) > I'm rather undecided about this. Would really love the opinion of other > heavy spreadsheet users. Yes it would be nice to get feedback from calc users, especially ones who do set these shortcuts, as some were when i look at the OOo stats. (In reply to Heiko Tietze from comment #9) > Ctrl+Insert is an alternative for Copy (along with Shift+Insert for Paste). > And the question is where you insert the new column/row - left or right. > Okay, right now it's only the col left and the row above which can be added > by menu. Yes these would act no different than the Insert > Row, etc. > On the other hand, it's in fact dangerous to just press two buttons and > loose all data. If you don't see it immediately the undo function wouldn't > help. Therefore my (non-working) shortcuts do only add cols/rows. Yes that sounds like a first good step of just doing the insert ones. > Putting all together I think we should keep the current behavior. If it's > unclear where col/rows should be added/deleted, a dialog is shown (unclear > in terms of only one or a few cell are selected). However when a column or > row is selected the shortcut works immediately as expected. And the new > toolbar buttons makes it very easy to modify the sheet. Yes i believe the toolbar buttons will definitely help users avoid going to the menu, but heavy spreadsheet users are heavily into shortcuts and it would be good to assign an appropriate shortcut for these insert operations, rather than them doing shortcut combinations.
BTW, the choice after [Ctrl][+] / [Ctrl][-], remains up to the next LibreOffice session. In addition to c#4, selecting columns/rows with the mouse plus [Ctrl][+] / [Ctrl][-] works just fine, I think less prone to unwanted errors. Perhaps could be closed.
We're replacing our use of the 'ux-advise' component with a keyword: Component -> LibreOffice Add Keyword: needsUXEval [NinjaEdit]
Can we please add a menu item under Insert -> Row? Many users have a strong muscle memory of Excel's shortcut to add a row: Alt+I, R. The very same shortcut works in Google Sheets.
(In reply to Dan Dascalescu from comment #13) > Can we please add a menu item under Insert -> Row? > > Many users have a strong muscle memory of Excel's shortcut to add a row: > Alt+I, R. > > The very same shortcut works in Google Sheets. This no way matches naturally with the menu entries. But You can customize the menu bar (Tools > Customize > Menus) if your prefer a different arrangement. (In reply to m.a.riosv from comment #11) > BTW, the choice after [Ctrl][+] / [Ctrl][-], remains up to the next > LibreOffice session. > In addition to c#4, selecting columns/rows with the mouse plus [Ctrl][+] / > [Ctrl][-] works just fine, I think less prone to unwanted errors. > > Perhaps could be closed. Yep, seems wise.