Hi,
Please download and try our latest fix/version: Aspose.Cells for .NET (Latest Version) if it works fine.
If you still find the issue, kindly attach your template file and sample code (runnable) to reproduce the issue on our end, we will check your issue soon.
Thank you.
Aspose version is 7.4.2.0
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
When we tried to run your code. Visual Studio complained no Load function is out there. Could you please check it at your end. Load method does not exist. We used the latest version of Aspose.Cells assembly.
Hi,
I provided you minimum code to reproduce the problem. You are absolutely right template.Process(); throws exception. Moreover the issue was introduced in recent releases, year old aspose library was working fine. BTW template.Workbook.CalculateFormula(); will throw the same exception as well.
Hi,
Thanks for your posting and using Aspose.Cells.
After investigation, we were able to replicate the issue. We are getting the same exception in workbook.calculateFormula.
We
have logged this issue in our database. We will look into it and fix
it. Once the issue is fixed or we have some other update for you, we
will let you know asap.
This issue has been logged as CELLSNET-41583
C#
string filePath = @“F:\Shak-Data-RW\Downloads\PearsonWeeklyReportTemplate(1).xlsx”;
Workbook workbook = new Workbook(filePath);
workbook.CalculateFormula();
Console.WriteLine(workbook.Worksheets[“Calculation1”].Cells[“B5”].StringValue);
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
We have fixed the issue.
Please download and try this fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.