tablesort icon indicating copy to clipboard operation
tablesort copied to clipboard

Empty cell sorting order

Open tikn opened this issue 7 years ago • 5 comments

It would be nice if empty cells always sorted to the bottom, like this. Or add options emptyToBottom and emptyToTop

tikn avatar Feb 13 '18 05:02 tikn

imho, empty cells should either be always lower than any other value or always higher than any other value. ie, they should be either at the top or at the bottom, depending on the sort order (not always at the bottom, regardless of the order).

tripu avatar Feb 14 '18 12:02 tripu

Came here looking to see if this was available as well. It would be great if empty cells were always at the bottom.

bridgeport avatar May 19 '18 18:05 bridgeport

I think that would be unexpected and surprising behaviour. I don't think sorting works like this almost anywhere else; eg, in desktop spreadsheets. “Sorting the same thing in reverse order” should produce “exactly the same result, but with the order reversed”; not “exactly the same result, but with the order reversed, except for empty or null values which stay where they were”.

tripu avatar May 22 '18 15:05 tripu

@bridgeport , just go here for more intuitive sorting table, there is an option to sort empty table cell to the bottom, doc. But i still hope option like this also available in this repo..

tikn avatar May 23 '18 04:05 tikn

Really missing this option. And it's impossible to implement that through sorting methods without hacking of the package itself which really makes me sad :(

Stalinko avatar Oct 17 '18 14:10 Stalinko