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

Properties

m_arrRangeRefColors Array of color values used for highlighting cell references in the edited formula text.
m_bDrawLinesForNamedRanges Indicates that the formula grid control highlights named cell references defined in the edited formula text if true.
m_bDrawLinesForSimpleRanges �Indicates that the formula grid control highlights unnamed cell references defined in the edited formula text if true.
m_clrFuncCall Color for highlighting function names in the edited formula text, with COLORREF(-1L) being the default color.
m_clrNumericConstant Color for highlighting numeric constants in the edited formula text, with COLORREF(-1L) being the default color.
m_clrStringConstant �Color for highlighting string constants in the edited formula text, with COLORREF(-1L) being the default color.
m_listEditedFormulaRanges List of formula objects representing all cell references in the edited formula text.
m_listEditedFunctions List of formula item objects representing all function invocations in the edited formula text.
m_nAlphaForNamedRanges Alpha channel value for highlighting named cell ranges in the edited formula text. All grid cells in a range are highlighted with a single color bitmap drawn with the specified alpha level of transparency.
m_nAlphaForSimpleRanges �Alpha channel value for highlighting unnamed cell ranges in the edited formula text. All grid cells in a range are highlighted with a single color bitmap drawn with the specified alpha level of transparency.

Classes

~CExtFormulaDataManager Destructor.
CExtFormulaDataManager Constructor.
GetFormulaCell Returns the formula grid cell at the specified location. The method returns NULL if the location is invalid or other type of grid cell is instantiated at the specified location.
NamedRange_Get Returns a range object by its name or NULL if no range object is registered with the specified name string.
NamedRange_GetCount Returns the number of registered named ranges.
NamedRange_GetNext Returns the next named range and its name by the specified position in the internal map of named ranges and increments the position for next enumeration. The method returns NULL if the position is invalid.
NamedRange_GetStartPosition Returns the start position for enumerating registered named ranges.
NamedRange_IsValidName Returns true if the specified string can be used as a range name. The rage name should be non-empty.
NamedRange_Remove Unregisters the range by its name and returns true if succeeded or false otherwise.
NamedRange_RemoveAll Unregisters all named ranges and returns the number of unregistered ranges.
NamedRange_Set Registers a named range and returns true if succeeded or false otherwise.

Overridables

OnGetFormulaCell Instantiates a formula grid cell at the specified location and returns true if succeeded or false otherwise.
OnQueryDataProvider Returns a reference to the data provider object used by the formula data manager for accessing cell objects.
OnQueryFormulaAlphabet Returns a reference to the formula alphabet object used by the formula data manager for generating and parsing the strings that specify references to cell locations and cell ranges.
OnQueryFormulaFunctionSet Returns a reference to the function set object used by the formula data manager for computing formulas.

See Also

CExtFormulaDataManager Overview | Hierarchy Chart