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

Tags: #<Tag:0x00007f24a25b7b10> #<Tag:0x00007f24a25b7930>

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.

Any update or workaround for formula not working on filtering ?

Hi @ashishs

The issue regarding filtering formulas was actually solved in Handsontable v.12.0.0

Hi @adrian.szymanski

I’m using 12.0.0. Strangely its not working in the example given in that issue either https://jsfiddle.net/Lk2fbr6q/

I’ve resorted to reloading the filtered data but would defintely like this feature to work.

Hi @ashishs

I also tested it with v. 12.0.0 and the problem described GitHub issue is gone. When you filter out everything but the formula cell it works correctly: https://jsfiddle.net/aszymanski/16o7h2tu/

Can you please clarify what is your expected behavior?

Hi @adrian.szymanski,

Yes, its working in your fiddle. Is there a possibility Hyperformula will support objects in the future?

Hi @ashishs

I suggest you to report it as an improvement suggestion here: https://github.com/handsontable/hyperformula/issues

That way we will be able to see what is the demand for such an improvement and you will be able to track its status.