Wrong formula reference after deleting rows

Aspose.Cells Product Family
1

Hi, I’m trying evaluation version of Aspose.Cells v21.1.0. I’m getting formula reference “move” to next column after deleting row (s), it happen when I delete row(s) at the last of the range.

Here is the code

        var wb = new Workbook("Test.xlsx");
        var ws = wb.Worksheets["Phanbo"];
        var cells = ws.Cells;

        cells.DeleteRow(9);
        cells.DeleteRows(60, 2);
        wb.Save("out.xlsx");

Ex: B67 has: =SUM(B10:B66) after deleting 2 rows (as the code above) the formula become: =SUM(C10:C64).

Edit: When I remove this line

        cells.DeleteRow(9);

The error don’t happen.

Please check attach images and xlsx.
Before deleting
Regard.Formula-before-deleting-row.jpg (89.0 KB)
After deleting
Formula-after-deleting-row.jpg (89.9 KB)

https://drive.google.com/drive/folders/113TQcSAJXqnmbtz6G4rShVt7WVdPCWcd?usp=sharing

Regard.

2

@riverstore,

Please notice, I am able to reproduce the issue as you mentioned. It seems the cells.DeleteRow(9); is the culprit line which is not working as expected. Anyways, we have to look into your issue thoroughly. I have logged a ticket with an id “CELLSNET-47847” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

1 Like
3

@Amjad_Sahi Thanks a lot for quick responding. I check and see that it’s work fine when delete row(s) one time.

4

@riverstore,

Yes, you may use cells.DeleteRows() method for the time being and we will continue to investigate on why it is not working properly when using with cells.DeleteRow() method. Hopefully, we will figure out your issue soon.

1 Like
5

@riverstore,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

1 Like
6

The issues you have found earlier (filed as CELLSNET-47847) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao

1 Like