Dear support,
when we run following code (Aspose Version 17.9.0.0)
workbook.CalculateFormula(true);
with this workbook FormulasUnitTest.zip (10.6 KB),
the cell ‘A39’ shows us an error but the cell below with the similar formula not.
In Excel both formula works as expected.
The differences are the uppercase letters ‘R’ and ‘C’.
We face this error already in 2015 with Aspose, which were resolved in the meantime but now it occurs again.
So for us it is a HIGH REGRESSION bug and needs to be resolved asap.
Kind regards,
SAP
@christoph_schroeder0,
Thanks for the template file and details.
After an initial test, I observed the issue as you mentioned by using the following sample code with his template file. I found that Aspose.Cells formula calculation engine resolves formula (("=INDIRECT(“Data!r17c5”,FALSE)")) unexpectedly to error:
e.g
Sample code:
Workbook workbook = new Workbook("e:\\test2\\FormulasUnitTest.xlsx");
workbook.CalculateFormula(true);
Console.WriteLine(workbook.Worksheets[0].Cells["A39"].StringValue);//#REF!
I have logged a ticket with an id “CELLSNET-45719” for your issue. We will look into it soon.
Once we have an update on it, we will let you know here.
@christoph_schroeder0
Thanks for using Aspose APIs.
This is to inform you that we have fixed your issue CELLSNET-45719 now. We will soon provide the fix after performing QA and including other enhancements and fixes.
@christoph_schroeder0,
Please try our latest version/fix: Aspose.Cells for .NET (Latest Version) .
It should fix your issue “CELLSNET-45719” now,
Let us know your feedback.
The issues you have found earlier (filed as CELLSNET-45719) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
Please also check the following article:
Thank you very much for the information.