Hi,
I've an unexpected behavior using DeleteColumn and DeleteRow. I've a sheet with the following content:
 A  B  C  D  E 
1 
 =SUM(B2 : B4)  =SUM(C2 : C4)  =SUM(D2 : D4) 

2  =SUM(B2 : D2)  1  4  7  =SUM(B2 : D2) 
3  =SUM(B3 : D3)  2  5  8  =SUM(B3 : D3) 
4  =SUM(B4 : D4)  3  6  9  =SUM(B4 : D4) 
5 
 =SUM(B2 : B4)  =SUM(C2 : C4)  =SUM(D2 : D4) 
Now i delete column C and row 3:
sheet.Cells.DeleteColumn(2);
sheet.Cells.DeleteRow(2);
The result is:
 A  B  C  D 
1 
 =SUM(B2 : B4)  =SUM(C2 : C4) 

2  =SUM(B2 : D2)  1  7  =SUM(B2 : C2) 
3  =SUM(B3 : D3)  3  8  =SUM(B3 : C3) 
4 
 =SUM(B2 : B3)  =SUM(C2 : C3) 
The formulas after the deleted column (in column D) are adapted, also are the formulas after the deleted row (row 4).
But the formulas before the deleted column/row (column A and row 1) aren't.
Andreas