We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cell throws stack overflow exception while deleting empty columns

Hi Aspose Support team,

Please see the attached file, we are getting stack overflow exceptions while removing empty columns and rows from it. As compared to other documents it has huge numbers of Rows and columns.

ThanksStack overflow exception.zip (85.9 KB)

Please provide us necessary fix.

@harshshah903,

I am able to reproduce the issue as you mentioned by using the following sample code. I found Aspose.Cells throws StackOverflowException while deleting empty columns:
e.g.
Sample code:

Workbook workbook = new Workbook("e:\\test2\\CP Sample 2.xlsx");
workbook.Worksheets[0].Cells.DeleteBlankRows();
workbook.Worksheets[0].Cells.DeleteBlankColumns();
workbook.Save("e:\\test2\\out1.xlsx");

I have logged a ticket with an id “CELLSNET-50096” for your issue. We will look into it and try to figure it out soon.

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

@harshshah903,

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

@harshshah903,

Please try our latest version/fix:
Aspose.Cells21.12.4 For .Net2_AuthenticodeSigned(1).Zip (5.6 MB)
Aspose.Cells21.12.4 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.12.4 For .NetStandard20.Zip (5.6 MB)

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