SSDC already works with many keyboard shortcuts and that’s great. I just wanted to start a thread specifically for listing the keyboard shortcuts that I miss. Sometimes you don’t realize how much you use them until they aren’t available, so this post is a list of the shortcuts I’m currently missing:
#1: F4 - Toggle a reference between A1, $A$1, A$1, $A1
#2: Ctrl+D - Copy the cell(s) above. If you have multiple cells/rows selected, copies the first selected cell/row to fill current selection. I use Ctrl+D a lot, but in a chrome browser that bookmarks the page, so I’ve been bookmarking the page a lot instead.
#3: SHIFT+Spacebar - Select the current row or group of rows.
#4: CTRL+Arrow - Move to the edge of the current region in the direction of the arrow. In combination with SHIFT+CTRL+Arrow to extend the selection. Would like this to work with row selection as well.
#5: CTRL+SHIFT+` (tilde) - For converting the format (data type) to Automatic. This converts the number format to “General” in Excel and GS.
#1 - F4 while editing formulas is under development
#2, #3, #4 : Thanks for the feedback, we’ll add to TODO
Is there a shortcut key to validate the rich text cells ? If not, please add it to the todo list with high priority !
@Dimitri_G - Not sure I understand what ‘validate rich text’ means. Could you elaborate please?
The shortcut has to have the same behavior than ENTER on text fields.
Got it - you can TAB out. I wonder is Alt+Enter should be the equivalent of Enter in Text/Automatic fields
Thank you for TAB
ALT + ENTER should be very good because SHIFT+ENTER is already used for new lines in Text fields.
After a bit of reflection, I think the behavior of the RichText should be aligned on the behavior of Text cells. ENTER should validate and SHIFT+ENTER to input line returns.
Maybe a special mode with a big modal window would be a good idea ; in this mode, ENTER would be used for line returns and there would be two buttons OK and Cancel (with window-style shortcuts) to exit.
I agree. Both Alt+Enter and Shift+Enter are popular keyboard shortcuts and probably should retain their universally expected behaviours.
I’m thinking of Ctrl+Enter as a possible candidate.