This is such a standard in the online world now. You have a bunch of columns and if you want the page to sort by one column you just click or double click the top of it. So simple. So logical. Alt+D, A, Enter is a hassle sometimes. (I can’t believe I’m preferring a mouse click over a keyboard shortcut but sometimes it is easier and more fluid.) Is this possible to do in Calc? So many things seem so awkward in this program. I’m not familiar with Excel or other spreadsheets, just word processors. So often I use keyboard shortcuts that don’t work where it would seem they could if they just allowed them to. And its not as if the shortcut is being used for something else.
The ways to work with spreadsheets are older than your ideas how things work “online”. And changing this would mean: Tell every learned user to change their trained working, because some new people are not familiar with reading manuals. (Usually this old user-base will not like this… )
.
The other point is: “Online” you usually don’t have much other options than sorting. In Calc you mark the column to do something with the marked range - also a very traditional concept. (Then you may choose a sort-button from a toolbar.)
.
For your simplistic approach: How do you differ between sorting the column itself or sort the whole table with the column as key (not even mentioning, how to sort with more than one column)?
.
Most things are possible. There are macros, there are keyboard-bindings and there are manuals:
https://documentation.libreoffice.org/en/english-documentation/
But don’t expect Calc to be a data-browser, because this is only one aspect of the game.
1 Like