Strange behavior of multiple sort

[Vlczech]

There is a strange behavior of multisorting:
I click a "+" button on name for example (this column is sorted first), then click "+" button" on surname for example (this column is sorted second). There are "+" buttons on these columns still.

Now I would like to change sort the name column (firstly sorted column) from ASC to DESC order. So let's try it by click to:

• column name => oh no, this is single sort and my previous multi-sort was killed.
• displayed sorting arrow => this does not function (however this icon does make sense to use for change the order of sort; for example with 180° rotated icon on hover)
• "+" button => OK, the order of sort is changed.

And what about to change back the name column from DESC to ASC order preserving firstly sorting?

• OK, i know: "+" changed me in the previous step => click => oh no, my first sort is now on surname only and previous name column sort by first was killed (if I had only 2 multisorts). Actually the "+" button has no function of add multiple sort, but has the function of drop current column from multiple sort realistically.

---

Proposed solution:

• "+" button is used only to add the column to multisort
• for changing between ASC and DESC order is used "^" or "v" icon hovered to opposite site
• after the column is added to multisort "+" icon is replaced by "x" button to cancel sort on this column

EDIT:
For consideration:

• after multisorting is activated, click on column label has the meaning of change the order instead of cancel multisort order to column-only order

[uestla]

I see, maybe the "+" sign is counter-intuitive since it's not about adding.

The basic rule here is

Use label for one-column sorting and "+" button for multisorting

There are 3 states of sorting:

• ASC
• DESC
• not sorted

You are switching between these 3 states in a loop as you are sorting by certain column (i.e. clicking either on label or "+" button). When the grid is sorted by 2+ columns, you can see that thanks to number labels next to the "+" button.

Furthermore I don't see a quick way to reset multisort back to single-column sorting in your solution.

[Vlczech]

In my solution, if you once selected multisort, then you need to cancel it gradually by "x" button (or "-" button, if you want). It follows the same steps you need to do for multisort init.

or the 2nd point, that i mentioned at #27:

some checkbox or radiobox (for example above the table) to change behavior between single sort and multi sort

And reaction to 3 states of sorting:

There are 3 states of sorting: ASC, DESC, not sorted

But this is not so practical, when you can try to switch between ASC to DESC and then return to ASC.