Error loading workbook with invalid formula

Aspose.Cells Product Family
1

Hello,
when upgrading from version 17.11 to 18.6 we have noticed that the new version can no longer load the
following workbook.

https://www.dropbox.com/s/24awf0l8in1wtld/Google-Sheet-Invalid-Formula.xlsx?dl=0

Any help would be appreciated

2

@PeteLee

Thanks for using Aspose APIs.

Your Excel file is corrupt. When you open it in Microsoft Excel, it prompts the error message and repair the Excel file as shown in the following screenshot.

Please note, you cannot open corrupt Excel file using Aspose.Cells APIs.

Screenshot showing the Excel file Corruption:

3

@PeteLee,

Thanks for the template file.

We were able to reproduce the exception “Invalid parameters for function iferror…” when loading your template file. We have logged a ticket with an id “CELLSNET-46206” for your issue. We will try to enhance the product to handle such kind of issue (e.g “ignore invalid formulas while importing template files”, etc.).

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

4

@PeteLee,

This is to inform you that we have fixed your issue “CELLSNET-46206” now. We will soon provide you the fixed version in the next few days (3-5) after performing QA and incorporating other enhancements and fixes.

5

@PeteLee

Thanks for using Aspose APIs.

Please download and try the following fix and let us know your feedback.

6

The issues you have found earlier (filed as CELLSNET-46206) have been fixed in Aspose.Cells for .NET v18.7. Please also check the document/article for your reference: Install Aspose Cells through NuGet|Documentation