tablesort
tablesort copied to clipboard
Empty cell sorting order
It would be nice if empty cells always sorted to the bottom, like this. Or add options emptyToBottom
and emptyToTop
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).
Came here looking to see if this was available as well. It would be great if empty cells were always at the bottom.
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”.
@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..
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 :(