handsontable/handsontable

Sorting on multiple columns

krzysztofspilka asked for this feature about 2 years ago — 5 comments

krzysztofspilka commented about 2 years ago Admin

| YipYipX4 commented almost 2 years ago

This important feature should be a lot easier to implement than some of the other feature requests.

You just need a sort algorithm that preserves existing order for rows that match on the column being sorted, and then sort the columns in the opposite order that the user clicked and shift+clicked. Thus, if the user clicks on "Last Name" and then shift+clicks on "First Name", you will first sort by "First Name", then sort by "Last Name" (while preserving existing order for rows that have matching values for "Last Name"). You will then have a table with rows sorted by Last Name and any matching Last Name values will be sorted by First Name (but you don't need to individually sort these groups). The same applies for any number of columns.

Thanks!

| yiyzhang commented almost 2 years ago

It will be really nice to have this feature added. Cannot wait to try out hiis new feature. Thanks!

sclcxn commented over 1 year ago

Looking forward to have enhanced sort feature with fixed header row.

| sandys commented over 1 year ago

please consider using github.com/crossfilter/crossfilter to implement this.

Join the discussion!

Sign-in with GitHub to comment