XLL+ Class Library (6.3)

CXlRef::GetRowColumnLetters

Returns the letters used for RC style addresses

static BOOL GetRowColumnLetters(
   char& chRow,
   char& chColumn,
   BOOL bLocalLanguage
);
static BOOL GetRowColumnLetters(
   wchar_t& chRow,
   wchar_t& chColumn,
   BOOL bLocalLanguage
);

Parameters

chRow

If successful, will contain the letter used for rows in RC-style addresses.

chColumn

If successful, will contain the letter used for columns in RC-style addresses.

bLocalLanguage

TRUE if the letters are for the local language; FALSE for English. R1C1 format addresses use different letters in different languages: thus the English address "R1C2" is written as "Z1S2" in German. If bLocalLanguage is TRUE, then the local letters are returned; if bLocalLanguage is FALSE, then the results are always "R" and "C".

Return Value

TRUE if the letters are found; FALSE otherwise.

Remarks

This function gets the letters used in RC-style addresses. These are used in the string functions ToString() and FromString().

Availability

If bLocalLanguage is TRUE, this function can only be called from macro functions, or from worksheet functions that have been marked as "Defer recalculation". It will always fail if called from worksheet functions that have not been marked as "Defer recalculation", if bLocalLanguage is TRUE.

Requirements

Header: xllplus.h

See Also

CXlRef Class | CXlRef Methods