Detect relative reference style letters - different languages

I write an application in Delphi which also exports results to Excel using OleObjects.
It exports formulas using relative referencing for example: '=RC[-1]*RC[-2]'.
It doesn't work for example with Polish version of Excel 2000 because the formula
letters of row and column should be W and K, so formula looks '=WK[-1]*WK[-2]'.

I would like to know how to detect reference style letters if I should use RC or WK
or anything else depending on version and language of installed Excel.

Is there any function to detect those letters for referencing?

What is your code to load the formulas? If it uses FormulaR1C1 the RC references would be valid I think because that property uses American formats.

What is returned if you call

Please Login or Register  to view this content.

where data is your formula string? 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.

Can't check already what is returned from given call because I need to go to other computer to compile application and run it and see on another.
Anyway those international values are what I exactly needed and I think they will fix my problem.

I made a comparison of on which settings Execel 2000 and 2013 work. I've only set XlApp.RefernceStyle to xlR1C1.

For Excel 2000 PL it is:

Formula string type	Method Value	Method FormulaR1C1
RC	not working	not working
WK	working	working

For Excel 2013 PL:

Formula string type	Method Value	Method FormulaR1C1
RC	working	working
WK	not working	not working