Deleting rows in a named ranges does not modify formulas?

[marius]

Hello Lars,

Sigh, sorry man, I stumbled on yet another formula problem, the DeleteRows (the correct one this time) does not adjust formula's.

After the sample code the original formula SUM(A1:A25) is SUM(A1:A35), same for the other vertical formula's, horizontal formula is also affected.
The named range is not reduced data=Sheet1!$A$1:$E$25 vs data=Sheet1!$A$1:$E35

You can reuse the sample i send to you, just replace the (only) line in the TfrmMain.btnCopyClick with this.
XLS[0].InsertRows(10, 5);
XLS[0].InsertRows(10, 5);
XLS[0].DeleteRows(10, 14);
XLS[0].DeleteRows(10, 14);

[larsa]

Hello

Will be fixed in update 5.20.07, ready by the beginning of next week.