[GH #8511] Auto update Formula after Row/ Column is Moved

Tags: #<Tag:0x00007f45251d0080> #<Tag:0x00007f45270d5ed0>

I have do some research and found this, on v9.0.0 it seem like the formula is updated after insert, but let say if I doing Move column, the formula is not updated based on the change. Is it about the visual and physical location of the cell or is it a pending enhancement?

Example
A B C
1 10 20 = A1

If move B to A, it will become
A B C
1 20 10 = A1
but on C1 it still shown it =A1 and have value of 10.

Hi @wongsaicjack
As you can see in our epic-issue related to integrating HyperFormula to Handsontable: https://github.com/handsontable/handsontable/issues/8511
functionalities such as:

  • moving
  • sorting
  • filtering
  • and a few more,
    are not currently supported.

To track work progress, you can subscribe to GitHub notifications in that issue. As soon as we start working on it, you will get an update.