Axolot Data

Hello,
I'm using Version 4.00.58.
e.g.: I have a function SUM(A2:A5) in an existing Sheet. I then try to insert a new row between A2 and A5. I expect the Function to extend the range to SUM(A2:A6) automatically, but that doesn't happen. The function remains the same, no matter at what position I insert a new row.
When I open the file in Excel and manually add a row, the range gets updated. Can't this be achieved through your component?


Thanks for your response,
Michele

Hello

Use MoveCells instead and you have options on how cells are adjusted.

Thank you, I'll try that then