Free Support Forum - aspose.com

Exception while calling Cells.DeleteBlankRows

#1

Hi @ahsaniqbalsidiqui

Thank you for providing new URLs. Unfortunately we were still able to reproduce the issue using Aspose.Cells 18.12.1. Upon calling sheet.Cells.DeleteBlankRows() we get the following exception:

System.ArgumentException: Destination array is not long enough to copy all the items in the collection. Check array index and length.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.BitConverter.ToInt32(Byte[] value, Int32 startIndex)
at .(Worksheet , Boolean , Int32 , Int32, Int32 , Int32 , Int32 , Int32 , Byte[] )
at ? .(Int32 , Int32 , Worksheet , Boolean)
at Aspose.Cells.RowCollection(Int32 , Int32 )
at Aspose.Cells.Cells.(Int32 , Int32 , DeleteOptions )
at Aspose.Cells.Cells.DeleteBlankRows(DeleteOptions options)

We’ve created a sample console app which allows to easily reproduce the issue, including the Excel file: https://we.tl/t-6BOqZzB7cF

Looking forward to your feedback. Please let us know if you need more info.

Thanks!

Exceptions: "System.ArgumentException: Destination array is not long enough to copy all the items in the collection. Check array index and length."
#2

@Stylelabs,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46543 - Exception while calling Cells.DeleteBlankRows
#3

@Stylelabs,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46543”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

#4

@Stylelabs,

Please try our latest version/fix: Aspose.Cells for .NET v18.12.9 (attached)

Your issue should be fixed in it.

Let us know your feedback.

Aspose.Cells18.12.9 For .Net4.0.Zip (4.7 MB)
Aspose.Cells18.12.9 For .Net2_AuthenticodeSigned.Zip (4.7 MB)

#5

@ahsaniqbalsidiqui the provided assembly does fix our issue. Do you know when we can expect this version released via the following NuGet feed: https://www.nuget.org/packages/Aspose.Cells ? Many thanks!

#6

@Stylelabs,

We will release new updated version via NuGet in about 10 days. You will be notified here once new version is released and ready for download.

#7

The issues you have found earlier (filed as CELLSNET-46543) have been fixed in Aspose.Cells for .NET v19.1. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi