How can I see updated formula references after column move?

Tags: #<Tag:0x00007efc652785e0> #<Tag:0x00007efc652784a0>
#1

Hello,

when I move columns, the formula references in these columns are automatically updated.

But the updated references are not visible when I look at the formulas in a cell by double-clicking. For example, we have columns A, B, C, D. Cell A1 says =5+B1. If I now move column B behind column D, this calculation is still carried out correctly but cell A1 does not say =5+D1, I still see =5+B1 even though column B is now D.

The question now is, how can I update this column reference that has been updated in the background in the table as well?

How can I export (as CSV) updated formula references after column move?
#2

Hi @HakanAkkurt

I checked your scenario with the newest version of Handsontable - 14.4.0 and it seems to work as intended: https://jsfiddle.net/handsoncode/1rumxky4/ After moving column B after D the formula in cell A1 is updated.

1 Like
#3

Thank you, it works :slight_smile:
How can I download the table data with updated formulas using

 hot.getPlugin('exportFile').exportAsString('csv',
{ ... }
);

?
Or is there another method?
Thank you.

#4

@HakanAkkurt

Thank you for the confirmation, I’m glad that it’s solved. In this case, I will close the topic.

#5