Function (SUM) not beeing extended on inserting new rows

[MLG]

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

[larsa]

Hello

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

[MLG]

Thank you, I'll try that then