Exception when opening file containing custom number formatting

Aspose.Cells Product Family
1
  1. Create a new worksheet in Excel;
    2. Format the cells with the following custom formulas:

    - @.
    - @    -
    - @*_

    3. Enter some numerical values in the formatted cells;
    4. Save file (or use the attached file);
    5. Try to open the file in Aspose.Cells using this code:

    var worksheet = new Workbook(“C:\AsposeCellsCustomFormat.xlsx”);

    Exception is thrown: IndexOutOfRangeException(“Index was outside the bounds of the array.”)
2

Hi Adrian,

Thank you for reporting this issue to us.

We are able to replicate the said exception while using the latest version of Aspose.Cells for .NET v7.6.0.5. A ticket has been logged in bug tracking system to look further into is matter and to provide a fix at earliest. The ticket Id for your future reference is CELLSNET-42118. Please spare us little time to properly analyze the problem cause on our end. In meanwhile we will keep you posted with updates in this regard.

Please accept our apologies for your inconvenience.

3

Hi,

Thanks for using Aspose.Cells.

We have fixed this issue.

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