Remove the sorting and filter for specific hyperformula row

Tags: #<Tag:0x00007f135d0a94a8> #<Tag:0x00007f135d0a9368>
#1

Need to remove the sorting and filter for specific hyperformula row, user can edit that row like add a hyperformula but it not include in sorting and filter in angular

#2

Hi @saran123

You can exclude some rows from sorting. Here https://handsontable.com/docs/javascript-data-grid/rows-sorting/#exclude-rows-from-sorting is a description with a demo, but we do not have the same mechanism for filtering. You can only block an action of filtering within the beforeFilter hook. Reference: https://handsontable.com/docs/javascript-data-grid/api/hooks/#beforefilter.

#3

For row sorting, if use editable footer row with hyperformula, at the time “handsontableInstance.rowIndexMapper.moveIndexes(handsontableInstance.toVisualRow(lastRowIndex), lastRowIndex);” is working but sorting result show wrong like

A B C
1 1 1
2 2 2

after click sorting
A B C
2 1 2
1 2 1 -> it show like this

Footer row formula showing will sorting the column
#4

Could you send me the demo with your latest progress and steps on how to replicate the issue, @saran123?