Hi,
One question - if I do a filter or sorting does the row# in the formula also change or does it stay the same throughout?
They do not change for filtering. We can test it here
When we open the formula for 2nd row we have
and the same happens when we filter out the first row. The formula is not changed to A1. It holds reference to A2, as the row exists but it is hidden (filtered out).
As mentioned for sorting the formula is changed.Here we sort the second column, and the reference changes to A47.
Ok thank you. I will try to simplify the demo
Hi Aleksandra,
I have decided to remove sorting via Handsontable and try to use custom code to renumber the formulas and reload the table with the new data as I am running out of time to complete my project. I will probably look into it again in the future. You can close this topic for now.
Thank you for the assistance.
Thank you for the update.
If you’d need any help please feel free to open a new thread.