Use Microsoft Office Shortcuts in Libre Office
github.com35 points by Zaki101Aslam 3 days ago
35 points by Zaki101Aslam 3 days ago
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
Was just going to say this!
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 :(
This, so much this!
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.
> "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.
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
I used to really like the Apple suite, but with their move to the subscription version I might be moving to Libre office as well.
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!
Try onlyoffice.