Getting display style of all cells throws IndexOutOfRangeException

Aspose.Cells Product Family
1

Hello,

In the attached excel chart we have a table with 66 cells. If we are to open it with Aspose and call GetDisplayStyle on any cell, we get an exception: “Index was outside the bounds of the array”.

Here is the code used to reproduce this issue:
------------------------
var workbook = new Workbook(“testFile.xlsx”);
var cells = workbook.Worksheets[0].Cells;
Exception ex = null;

foreach (Cell cell in cells)
{
try
{
cell.GetDisplayStyle();
}
catch (Exception e)
{
ex = e;
Console.WriteLine("Cell " + cell.Name + ", value " + cell.Value + “, threw exception”);
}
}

Console.WriteLine(Environment.NewLine + ex);
------------------------

As you can see, I printed the name and value of every cell that throws an exception when calling GetDisplayStyle. In addition, you can see the full exception printed at the end.

InternalID: 32179

Best regards,
Jean-Alexandru Stanescu
Junior Developer
IBM Romania

2

Hi Jean,


Thank you for sharing the sample spreadsheet.

We have evaluated the presented scenario while using the latest revision of Aspose.Cells for .NET 8.6.0.3, and we are able to replicate the IndexOutOfRangeException. We have logged this incident in our bug tracking system under the ticket CELLSNET-43964 for further investigation. Our product team will further look into the details of this problem and we will keep you updated on the status of correction. We apologize for your inconvenience.
3

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSNET-43964 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

4
Hi,

Please try our latest version/ fix: Aspose.Cells for .NET v8.6.0.7

We have fixed your issue now.

Let us know your feedback.

Thank you.
5

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

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