Error: Index was outside the bounds of the array- when using AutoFitRow

Aspose.Cells Product Family
1

Hi,


We are experiencing an issue in a critical part of our product:
When using the method “AutoFitRow” of a worksheet this throws an exception when the specified row contains data and a range has been inserted before calling the “AutoFitRow” method.
The exception is “Index was outside the bounds of the array”.

I attached a simple code sample and an Excel file by which you can easily reproduce the issue.

This issue still occurs in the latest available version of Aspose.Cells, 8.4.0.0.

Could you please give this issue high priority? We want to release a new version of our product, but this issue is holding back our release.

Kind regards,
Bastiaan.
2

Our reference: TT46627

3

Hi Bastiaan,

Thanks for your posting and using Aspose.Cells.

We were able to replicate this issue using the following code with your source Excel file using the latest version (8.4.0). The code throws index outside the bounds exception.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

  • CELLSNET-43499 - Index was outside the bounds of the array exception when using AutoFitRow

I have attached the source Excel file used in this code for a reference.

VB.NET

Dim objWorkbook As New Aspose.Cells.Workbook(“Test.xls”)


Dim objCellArea As New CellArea()

objCellArea.StartColumn = 1

objCellArea.StartRow = 0

objCellArea.EndColumn = 1

objCellArea.EndRow = 0


objWorkbook.Worksheets(“Tables”).Cells.InsertRange(objCellArea, 1, ShiftType.Right)


objWorkbook.Worksheets(“Tables”).AutoFitRow(0)



4

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.4.0.3 and let us know your feedback.

5

Hi,


Yes, the issue seems to be solved in version 8.4.0.3.
Thank you!

Kind regards,
Bastiaan.

6

Hi Bastiaan,


Thank you for the confirmation. Please feel free to get in touch if you need our further assistance with Aspose APIs.
7

The issues you have found earlier (filed as CELLSNET-43499) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.