Free Support Forum - aspose.com

Cell R1C1Formula is throwing Exception

Hey,

I am having one XLSX file which is having some formulas.
When I try to get the formula using CELL.Formula It is working fine but when I am trying to get the R1C1Formula of the same cell Its not giving it to me.
It is throwing exception on it. The exception is irrelevant to the formula.

I am attaching one sample project and the file with in it.

AsposeSampleCodes.zip (5.3 MB)

@harshCIPL22,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47247 – Exception raised when Cell.R1C1Formula is called

Thank you for your quick response.

I have noticed one thing that there may be a issue in Parsing the Formulas.
When I am doing the following code the exception occurs:

objLoadOptions = New LoadOptions
objLoadOptions.ParsingFormulaOnOpen = False

But when I am using the below one it is working fine

objLoadOptions = New LoadOptions
objLoadOptions.ParsingFormulaOnOpen = True

I hope this may help you to investigate the issue more.

@harshCIPL22,
Thank you for providing more information. We will analyze it and provide our feedback accordingly.

@harshCIPL22,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Thank you so much for your fix.
I’ll wait for the new version.

@harshCIPL22,

Please try our latest version/fix: Aspose.Cells for .NET v20.3.3 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.3.3 For .Net2_AuthenticodeSigned.Zip (5.3 MB)
Aspose.Cells20.3.3 For .Net4.0.Zip (5.3 MB)