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?
Bookmarks