Free Support Forum - aspose.com

Invalid formula error while opening workbook

Dear Team,

We are getting following Invalid formula error while opening workbook. Can you please suggest what could be the issue. Or is it possible to get the error cells details if any.
Invalid formula"="'x000d x000d x000d x000d x000d x000d x000d x000d '"".

We are using the following method to open.
Workbook oXWb = new Workbook(sTemplateName);

The same file can be opened in excel without any issues.

Regards
Anish

@Anishc,

Thanks for providing us details.

Please provide us your template file which you are opening via Aspose.Cells, we will check it soon.

@Amjad_Sahi

Thanks for the quick turnaround. Please find the file attached.

b43315f6-bbd7-4ebe-903e-893b81b07861.zip (630.9 KB)

Regards
Anish

@Anishc,

Please try our latest version/fix: Aspose.Cells for .NET v18.9.5

I have tested your issue using your line of code with it, it works fine.

Thanks but we are using the Aspose.Cells for .NET 7.3.5.0. We are unable to upgrade our application to a latest version at this moment. Can you please help to identify the error so that we can ask the users to correct the errors in the file and try.

Regards
Anish

@Anishc,

I am afraid to mention that here at Aspose, support is provided for the latest versions only. You may please use latest version for your testing or if you want to test Aspose.Cells without evaluation version limitations, you can also request a 30 Day Temporary License.

@Anishc,

For your issue, if you cannot upgrade to new fixes/versions but can modify the template manually, then you may remove those hidden defined names heading with “_AMO_”. After removing those names the file should be able to be loaded by old versions of Aspose.Cells.