Convert R1C1 formula to A1-style formula

Aspose.Cells Product Family
1

Hello,


How do I do the following with Aspose.Cells please?

VB.NET code:

Dim startCell as String
Dim endCell as String

startCell = Excel.Application .ConvertFormula(“R” & nFirst & “C” & CStr(nCnt), Excel.XlReferenceStyle.xlR1C1, Excel.XlReferenceStyle.xlA1)
endCell = Excel.Application .ConvertFormula(“R” & nLast & “C” & CStr(nCnt), Excel.XlReferenceStyle.xlR1C1, Excel.XlReferenceStyle.xlA1)

I found this post but I don’t want to set a Cell with the formula (eg. using Cell(n,n).R1C1Formula property), I just want to convert the formula string to use it elsewhere.

Thank you.

2

Hi,


Well, you may try to use some static methods for CellsHelper utility class directly for your needs, e.g
CellsHelper.ConvertR1C1FormulaToA1()


Thank you.
3

Thank you.


I ended it up using it as:
CellsHelper.ConvertR1C1FormulaToA1(formula, 0, 0)

and it seems to work fine.
4

Hi,


Good to know that it figures out your issue 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.