InsertRows breaks existing formulas

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
shochberg
Posts: 17
Joined: Fri Aug 01, 2008 3:09 pm

InsertRows breaks existing formulas

Post 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.
Post Reply