Detect relative reference style letters - different languages

Originally Posted by Izandol

You can use XLApp.International(6) to obtain the local equivalent of R and XLApp.International(7) to obtain the local equivalent of C but you must then parse the formula which may not be easy if your formulas are more complicated than your example.

This really fixed my problem but had to use brackets instead parentheses: XLApp.International[6] and XLApp.International[7].

Thanks.

Edit:
Don't know what happened but with Excel 2013 it worked for a while and stopped after some testing. Now even if XLApp.International returns 'W' and 'K' for formulas I need to use 'R' and 'C' for referencing. Posted procedure gives:

Formula:='=WK[-2]*WK[-1]';
Formula2:='=RC[-2]*RC[-1]';
S1:=Excel.ConvertFormula(Formula, -4150, 1); // gives '=XFC1*XFD1'
S2:=Excel.ConvertFormula(Formula2, -4150, 1); // gives an exception

Don't know how to fix it.

Edit 2:

Already found the solution. There are plenty of properties starting with Formula, just needed to use FormulaR1C1Local so it will always accept localized formula notation.