I am a heavy & proficient Excel user and do 95% of the commands using keyboard shortcuts. I think OnlyOffice is already quite good with keyboard shortcuts (e.g. “Alt + letters” to navigate the ribbon) but there are a few improvements I’d like to suggest:
- Adjust the ribbon navigation (Alt + letters) to more closely match Excel. Some examples for Excel ribbon shortcuts I use daily:
- alt + hsb/hsbr/hsbl/hsbo/hsbs/hsbn for borders (bottom, right, left, top, all sides, none)
- alt + hal/har/hac for align left/right/center
- alt + hm for merge and center
- alt + hw for wrapping text
- alt + ag/au for grouping/ungrouping rows and columns
This is just an example, there’s many more. I noticed that OnlyOffice has slightly different shortcuts and I think it would be better to match the Excel ribbon shortcuts if possible. Many people are proficient with Excel’s shortcuts but very few want to re-learn them for OnlyOffice.
- Some useful “normal” shortcuts (not ribbon navigation) that are currently missing but present in Excel:
- ctrl + d/r for dragging down/right the current cell (i.e. copy-pasting the current cell into the selected cells below or to the right)
- alt + est/esv/esf/esc to paste only style/values/formulas/comments
- alt + oca/hoa to automatically fit the column width/row height to the cell contents
- (Alternative) Ability to define your own keyboard shortcuts, both for keys pressed at the same time (like press Ctrl + D at the same time) or pressed in a sequence (like while pressing Alt you press O then C then A). This would solve all the other requests people may have and if you have an ability to export/import custom shortcuts it would even be possible to a member of the community to create a carbon copy of all of the Excel shortcuts (as long as the corresponding features exist in OnlyOffice of course). This would be a major differentiator compared to e.g. LibreOffice and would make it much easier for experienced people who don’t want to re-learn all shortcuts to change from Excel to OnlyOffice.
