Description: Is this possible to automatically import MS-office shortcuts in libre office? Also while writing formulas in calc it would be better if pressing tab automatically completes the formula just like WPS excel. While writing formulas a list will be very helpful to see the available formulas. Actual Results: It's very difficult to add all the shortcuts manually Expected Results: Should import them automatically Reproducible: Always User Profile Reset: No Additional Info:
Need love from UX-team My 5 cents: It need to realize different presets of shortcuts sets. But, LibreOffice isn't a clone of MSO anyway and if MS will be change its shortcuts again and again, then LibreOffice devs must be repeat this change again and again in LO. I don't like the idea
(In reply to A.K. from comment #0) > Description: > Is this possible to automatically import MS-office shortcuts in libre office? > This question has been asked for years on the various LibO (and before, OOo) discussion channels. This actually can be done: someone with good MSO knowledge could provide a comprehensive list of shortcuts for a given MSO version. As LibreOffice allows to save the current set of shortcuts (Tools > Customize > Keyboard, Save), it would then be feasible to integrate them to the corresponding LibO options (just amend the /Configuration2/accelerator/current.xml file). Once the said file is setup, just reload it into LibO to get advantage of the MSO shortcuts :) So, I can't see why noone involved would'nt go and try that route. This doesn't require any LibO change, since the options are there already.
Rather than loading some weird alien format we should make the shortcuts extensionizable. Meaning you or someone else collects the MSO shortcuts and provides this list for user customization. I adjust the summary accordingly.
@Heiko Tietze will these lists work: Excel: https://exceljet.net/sites/default/files/downloads/Exceljet_Excel_Shortcuts_160623.pdf Word: https://support.office.com/en-us/article/Keyboard-shortcuts-for-Microsoft-Word-on-Windows-95EF89DD-7142-4B50-AFB2-F762F663CEB2#bkmk_reference Please Also take a look at this post: https://ask.libreoffice.org/en/question/184537/ms-office-shortcuts-and-calc/
(In reply to A.K. from comment #4) > @Heiko Tietze will these lists work: > ... The point is not what shortcut exactly is assigned but how we do it. First, we have to make sure that "extended" characters are accepted (Ä,Д,ξ, etc) and then we should sharing different solutions. Today we have hard-coded keyevents restricted to English and you can configure the shortcuts yourself via Tools > Customize. The envisioned extension would allow to share these self-made assignments.
(In reply to Heiko Tietze from comment #3) > we should make the shortcuts extensionizable. This is already possible. Shortcuts are part of the configuration, so it is possible to override them from an extension. The wiki has a guide about creating configuration extensions: https://wiki.documentfoundation.org/images/b/b0/LibreOffice_config_extension_writing.pdf Of course, there is also the other approach with the Load.../Save... buttons in the Keyboard tab of the customization dialog, like mentioned in comment 2. This results with a xml file inside zip, which can be edited and shared with other people as well.
(In reply to Maxim Monastirsky from comment #6) > This is already possible. Shortcuts are part of the configuration... Super cool. Then we have a very simple, design-oriented easy hack. Who wants to take it?
Rania, you might be interested in this topic.
*** Bug 151106 has been marked as a duplicate of this bug. ***
*** Bug 158355 has been marked as a duplicate of this bug. ***