How to set always first desc order on click header columns?

Tags: #<Tag:0x00007f13602c6e18> #<Tag:0x00007f13602c6c88>
#1

How to show column data in desc order first, then asc order, while click on header columns every time?
Is this possible in v.7.0.0?

#2

Hi @karthi.gm1

I am not sure if I understand correctly. Do you want to do an initial sorting setup? If so, here https://handsontable.com/docs/javascript-data-grid/rows-sorting/#set-an-initial-sort-order is a tutorial with a demo. You need to use initialConfigwithin the columnSorting setup.

And yes, it works well also in v7.0.0. Here https://jsfiddle.net/84ybhz92/ is a demo that sorts a single column on initialization with the use of Handsontable v7.0.0.

#3

Thanks for your reply aleksandra.
While i click on every header columns Model, Price in https://jsfiddle.net/84ybhz92/, it first shows the data in ascending order.
I am asking to show it in descending order first. Then on my next click, it can be show in ascending order.
I need to setup like this.

#4

There is no option to control the desc/asc type of order on the header click. However, you can try to use afterColumnSort hook to run sort() again on the same column.

#5

Thanks for your suggestion @aleksandra_budnik.

#6

You’re welcome @karthi.gm1

I will close the topic as solved. However, please feel free to create a new one when needed.

#7