[Bug]: The setSortConfig setting is in effect, the page does not change, and the column size needs to be adjusted before it is displayed. about handsontable HOT 4 CLOSED

Hi @zhongguodong

Can you tell me a bit more about your use case?

When we go to the documentation for the setSortConfig method we can see that

Warn: Useful mainly for providing server side sort implementation (see in the example below). It doesn't sort the data set. It just sets sort configuration for all sorted columns. Note: Please keep in mind that this method doesn't re-render the table.

and this is how it works at the moment.

Reference: https://handsontable.com/docs/react-data-grid/api/multi-column-sorting/#setsortconfig

from handsontable.

Hi @AMBudnik
Haven't you noticed? The sort setting is successful, the title column is not sorted, the icon shows that setSortConfig is successful, you need to see the effect, but also adjust the size of the following appears, no display of the sorted rule.

from handsontable.

Ah yes, you are right - the arrow should appear without the need to resize the column.

Based on the documentation that I linked at https://handsontable.com/docs/react-data-grid/api/multi-column-sorting/#setsortconfig

beforeColumnSort: function(currentSortConfig, destinationSortConfigs) {
  const columnSortPlugin = this.getPlugin('multiColumnSorting');

  columnSortPlugin.setSortConfig(destinationSortConfigs);

  // const newData = ... // Calculated data set, ie. from an AJAX call.

  this.loadData(newData); // Load new data set and re-render the table.

  return false; // The blockade for the default sort action.
}

we call loadData(). However, that forces the plugin to reset so the arrows are not visible. (I will request that this example be altered.)

Now the table has to rerender to show an arrow. But we do not want the plugin to reset (it has to hold the sorting config) so instead of loadData() we need to call updateData().

Here is the demo for you to test https://jsfiddle.net/sj28q9cr/

Please let me know if it works for you.

from handsontable.

Issue closed due to inactivity.

from handsontable.