Cells.DeleteColumn and Cells.DeleteRow


#1

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

#2

Sorry for the duplicate posts. Please delete the others. Thanks.


Andreas


#3

Hi Andreas,

That’s a bug in DeleteColumn method. I will fix it ASAP.