Professional User Interface Suite, Copyright FOSS Software Inc. Help Published with Permission.

Classes

CanBeFirstChar Returns true if the specified character can be the first character in the cell reference name.
~CExtFormulaAlphabet Destructor.
CExtFormulaAlphabet Constructor.
GetAlphabetSize Returns the number of characters in the alphabet.
GetAlphaCharIndex Returns an index of the specified character in the alphabet or a negative value if the character is not defined in the alphabet.
GetAlphaStr Returns the alphabet-based name of the specified index.
GetInverseNamingMode Returns true if the inverse naming mode is used by the alphabet class or false otherwise. By default, the inverse naming mode is turned off and the alpha character based naming is used for columns if the digit-based naming is used for rows.
GetLocationStr Returns the cell reference name which specifies the location of the specified cell or an empty string if the specified row and/or column indices are invalid.
GetMaxAlphaStrLen Returns the maximum length of the alpha character-based part of cell reference name.
GetMaxAlphaStrVal Returns the maximum index which can be encoded/decoded using alpha characters.
GetMaxNumStrVal Returns the maximum length of the digit character-based part of cell reference name.
GetMaxValue �Returns the maximum index which can be encoded/decoded using digit characters.
GetRangeLocationStr Returns the name of the specified cell range object.
IsAlphaChar Returns true if the specified character is defined in the alphabet or false otherwise.
OnQueryAlphabetArray Returns a pointer to the array with an ascending serial sequence of all alphabet characters.
ParseCellName Parses the cell reference name and returns the row and column indices of the cell. The method returns a CPoint with negative values if the parsing fails.
ParseCheckEmptySpaceChar Returns true if the specified character is a space or a tabulation, which can be skipped while parsing cell reference names.
ParsePassEmptySpace Increments the referenced string pointer by skipping space and tabulation characters at start.
ParseRangeNamet Parses the rectangular cell reference range name and returns a rectangle object with normalized row and column indices. All returned indices can be negative values if the parsing fails.
ParseStrPartAlpha Parses part of the cell reference name based on alpha characters and returns an index encoded in the parsed text. The method returns a negative value if parsing fails.
ParseStrPartNum Parses part of the cell reference name based on digit characters and returns an index encoded in the parsed text. The method returns a negative value if parsing fails.
PreTranslateAlphaChar Modifies the alpha characters during cell reference name parsing or generation. The default implementation converts all alphabet characters to uppercase. The method returns true if succeeded or false otherwise.

See Also

CExtFormulaAlphabet Overview | Hierarchy Chart