As a finance guy, this is a massive, massive impediment to me "maining" Linux. Without my long-ingrained Excel shortcuts I'm not getting very far. I was previously planning to investigate a couple of "containerised" ways to run 365 (the names escape me) and I may yet have to in order to be able to use the collab/live edit features of Office, but this is a big step if it does what it says on the tin. Thanks for sharing!
EDIT: On second look, it looks like this might only bring over the native/bespoke hotkeys rather than the "Alt Codes" which are the majority of (my) shortcuts? e.g. Alt + H - I - S for Insert Sheet. Will have to have a look at it properly
> You wouldn't expect a Vim user to just abandon their muscle memory and just switch to Emacs.
Expect to just abandon, no. Expect to spend a reasonable time learning and trying out the new interaction paradigm to see if it could (after controlling for unfamilliarity) also suit them, yes. (The ultimate answer may turn out to be negative, like for me in the case of Emacs.)
The macOS version of Office has finally gotten native support for alt+shortcuts, would have been nice if LibreOffice had exploited that neglect by Microsoft :(
Speaking of shortcuts... yesterday I noticed that excel online opens in a localized version.. and with grey letters it tells what shortcut to use to jump to search bar: Alt+Ē
Meh... non-ascii chars as hotkeys maybe work in some languages, but not mine where I have to press silent letter (Apostrophe) to make e -> ē, but it doesn't work within shortcuts: ALT + (' + E)
> "Alt Codes" which are the majority of (my) shortcuts? e.g. Alt + H - I - S for Insert Sheet
Alt + H opens whatever menu H stands for, then the subsequent letters hit the appropriate menu items. The menus and their hotkeys would have to match the Office counterparts as well, and that's unlikely in normal free software clones. Not sure if it'll be that case here.
edit: After looking at what this tool does, I actually would not be surprised if you could just rewrite all the menus and their hotkeys...
Yeah, I do/did doubt this would port over the Alt Codes, though as you say I'm not sure someone couldn't just long-hand re-write the Alt Codes in either a mod/add-on/config file for any given Office competitor suite.
After all, the majority of the "mappings" are arbitrary/obscure anyway as only one option can "match" the letter (e.g. F is for File, so ForMulas needs to use M. I and D are used for legacy Office Shortcut compatibility so iNsert and dAtA use N and A respectively).
In other words, looking for a logic to these codes even in Office is a hiding to nothing anyway and it's really just a case of building muscle memory (or coming up with a bizarro-logic that helps e.g. "A is for dAtA").
It would be incredible to just be able to install a "365 Mode" or config where the full re-map has been done. I'm semi surprised this hasn't already existed for a long time, even to the point of being shipped built-in.
I'm currently transitioning from Windows to Linux and getting familiar with LibreOffice. To make the switch smoother, I created a tool that maps (almost) all MS Office shortcuts to LibreOffice equivalents.
I used Jules agent to help build and refine the repository. I figured others making the same transition might find it useful.
Would love feedback from the community about improvements to the mapping!
Libre Office does allow customising shortcuts. I got peeved when Ctrl+Plus (or Ctrl+Shift+=) is not available to add rows or columns, but found that it is very much possible to add it within Libre Office Calc itself.
From my notes (MD):-
- The shortcut can be reassigned under Tools > Customise > keyboard
- Add Ctrl+Shift+= (Equals to not Plus) too
- Select category All commands, scroll down there are 2 Insert Cells
- Hover mouse over. It shows the Uno command. Pick the one with `.uno:InsertCell`
- Under Shrtcut Keys select Shift+Ctrl+= and click on Assign
EDIT: On second look, it looks like this might only bring over the native/bespoke hotkeys rather than the "Alt Codes" which are the majority of (my) shortcuts? e.g. Alt + H - I - S for Insert Sheet. Will have to have a look at it properly
I have the same issue with Google Sheets. Non-experts don't understand how much of an impediment this is.
People need to watch a Shrekli video on YouTube to see how much some of us rely on the keyboard shortcuts.
You wouldn't expect a Vim user to just abandon their muscle memory and just switch to Emacs.
Expect to just abandon, no. Expect to spend a reasonable time learning and trying out the new interaction paradigm to see if it could (after controlling for unfamilliarity) also suit them, yes. (The ultimate answer may turn out to be negative, like for me in the case of Emacs.)
The macOS version of Office has finally gotten native support for alt+shortcuts, would have been nice if LibreOffice had exploited that neglect by Microsoft :(
Meh... non-ascii chars as hotkeys maybe work in some languages, but not mine where I have to press silent letter (Apostrophe) to make e -> ē, but it doesn't work within shortcuts: ALT + (' + E)
Alt + H opens whatever menu H stands for, then the subsequent letters hit the appropriate menu items. The menus and their hotkeys would have to match the Office counterparts as well, and that's unlikely in normal free software clones. Not sure if it'll be that case here.
edit: After looking at what this tool does, I actually would not be surprised if you could just rewrite all the menus and their hotkeys...
After all, the majority of the "mappings" are arbitrary/obscure anyway as only one option can "match" the letter (e.g. F is for File, so ForMulas needs to use M. I and D are used for legacy Office Shortcut compatibility so iNsert and dAtA use N and A respectively).
In other words, looking for a logic to these codes even in Office is a hiding to nothing anyway and it's really just a case of building muscle memory (or coming up with a bizarro-logic that helps e.g. "A is for dAtA").
It would be incredible to just be able to install a "365 Mode" or config where the full re-map has been done. I'm semi surprised this hasn't already existed for a long time, even to the point of being shipped built-in.
I used Jules agent to help build and refine the repository. I figured others making the same transition might find it useful.
Would love feedback from the community about improvements to the mapping!
From my notes (MD):-
- The shortcut can be reassigned under Tools > Customise > keyboard
- Add Ctrl+Shift+= (Equals to not Plus) too
- Select category All commands, scroll down there are 2 Insert Cells
- Hover mouse over. It shows the Uno command. Pick the one with `.uno:InsertCell`
- Under Shrtcut Keys select Shift+Ctrl+= and click on Assign