[GH #1975] Hyperformula not working while sorting the column

Getting help Issues
,
1

When I tried to sort the column hyperformula throw error in angular, i use handsontable 14.3 version.

I have a fixedrowbottom:1 and In the footer row I used a formula calculation row. So when i sorting the column at the time hyperformula throw error in handsontable version 14.3.

I do some analyzed some of the handsontable version maximum version 12.3.3 work fine. like when i sorting the column at the time formula show the same value and it doesn’t throw error. I add a demo of column sorting in handsontable version 12.3.3. here: Demo

I need a same functionality in handsontable 14.3.0. how to achieve it in angular.

2

Hi @saran123

Can you please send the example showing the actual issue? It will be easier to check what the problem is.

3

demo link https://jsfiddle.net/shanmugam/f5nuk84a/3/

Here column sorting work fine with hyperformula in footer, Just change the version like 14.3 in cdn link and again check the column sorting it throw error in hyperformula

4

There is any update?

5

Hi @saran123

I’m sorry for the late response. I checked you case and we have this issue reported internally. However, it’s yet to be decided if it’s a bug, because we are in line with Google Sheets with the behavior. I’ll update this topic once we have more information.

1 Like
6

Thanks for your response. Let me know for any updates on this issue. I think this is important, because sorting throw some formula error, after sorting the column that contains footer formula. So, just consider as a bug.