Page 1 of 1

InsertRows breaks existing formulas

Posted: Thu Dec 18, 2008 9:51 pm
by shochberg
OK, since you fixed the last one, let's try another, please

I am attaching (in a separate email) two files. The first, 12-17-08original.xls, has formulas
beginning in column U.

I then performed the following action on this file to create a second set of
blank rows following the original set.

XLSReadWriteII41.sheets[0].InsertRows(4901,4901);
XLSReadWriteII41.write;

The result is in the other file, 12-17-08result.xls

Note that the formulas in the original rows have been changed and are no
longer valid, staring in column U. Inserting additional rows should not
affect rows that are above the insert, but it apparently does.

Please advise. Thank you.