DeleteBlankRows() is deleting rows even if it has shapes on it

Aspose.Cells Product Family
1

Ideally, according to the documentation, DeleteBlankRows() should delete only rows which are empty i.e. the rows which does not have any content, images, charts, comments etc…

But in the attached file below, Even the rows that have objects i.e. image is getting deleted.
TEstTrail.zip (243.2 KB)

2

@shreyap
By testing on the latest version v24.8 using sample files and the following sample code, we can obtain the correct results. Please refer to the attachment. out_net.zip (244.3 KB)

Workbook wb = new Workbook(filePath + "TEstTrail.xlsx");
wb.Worksheets[0].Cells.DeleteBlankRows();
wb.Save(filePath + "out_net.xlsx");

If you still have questions, please provide your sample code. If you can take a screenshot and highlight the error location, it will be very helpful for us to locate the issue. We will check it soon.

3

@John.He ,
Please compare the output file and my file. In my file, Line no. 143 has shifted to line no. 101 after delete operation. Ideally I would expect after line 100, 101-126 to get deleted(as they are empty), then 127-140 would be shifted above to 101-114.
Line 141,142 to be deleted and 143 to be shifted to 115

4

@shreyap
Deleting rows and deleting blank lines have different processing logic for shape and other graphic objects, resulting in different outcomes. We can reproduce the issue through testing. Found that rows covered by shapes are deleted when deleting blank rows.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-56659

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

5

@John.He ,
By when can I expect the fix?
As this is a major issue for us, faster resolution is appreciated.
Thanks in advance!

6

@shreyap,

We kindly request a little time to thoroughly evaluate your issue. This will allow us to either resolve it promptly or provide an estimated time of resolution/completion if the issue is complex. Once we have any new information, we will update you accordingly.