Sort selective rows

Getting help Questions
1

Hi,
I have an handsontable instance. There are few rows that have some text and some null values. As shown in the link

http://jsfiddle.net/mumcrkwz/1/

Each of the Mens, Kids and Womens and the three rows follow them are one single group. Rows[1…4] is one group, rows[5…8] is second group and rows[9…12] is third group. Clicking on Column Header A, B, C, E should sort only rows 1, 5 and 9. (Please ignore column D).

Is it possible to write a custom sort function to achieve this.

Thanks in advance.

2

Hi @uzumaki.praveen

Yes, there is an option like that. Here’s a demo http://jsfiddle.net/handsoncode/y2ttkwt6/ where we define that we do not want to sort rows with indexes 0 and 1.

3

Hi @aleksandra_budnik ,

Thanks a lot for the tip. Also i need one more detail regarding sorting group of data. In the example that I shared, if I have to sort groups of four or n rows. i.e. considering group of four or n rows as single entity.
How would the sorting work in that scenario. can I use the same idea that you shared in that case.

Sorry for asking lot of questions. I am bit short on time to go through documents. I will be trying out different ways till I get a reply.

Thanks in advance

4

[answer left at issue #1136]