We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

CellsHelper.ConvertA1FormulaToR1C1 malfunction

ConvertA1FormulaToR1C1 throws an exception whenever it is passed a formula or string that contains a range name "Listx" where x is any integer. The exception is "Invalid Column Expression". To reproduce the problem, try this:

CellsHelper.ConvertA1FormulaToR1C1("=1+List2", 1, 1)

compared to this:

CellsHelper.ConvertA1FormulaToR1C1("=1+ListA", 1, 1)

It doesn't seem to matter whether Listx is a valid name or not, or what range it refers to. It also doesn't matter whether the formula is passed as a string or as the formula property of a cell.

Any ideas?

Hi Glynn,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue. The following line works fine

string sr = CellsHelper.ConvertA1FormulaToR1C1("=1+ListA", 1, 1);

but this line throws exception

string sr = CellsHelper.ConvertA1FormulaToR1C1("=1+List1", 1, 1);


An unhandled exception of type 'System.ApplicationException' occurred in AsposeProject.exe

Additional information: Invalid column expression: =1+List1

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42951.


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

We have fixed your issue now.

Let us know your feedback.

Thank you.

That’s fixed it, Amjad - many thanks for your fast response.


Thanks for your feedback.

Good to know that your issue is sorted out now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you

The issues you have found earlier (filed as CELLSNET-42951) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.