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

Properties

m_hCursorFormulaRangeCopy Cursor displayed when the Ctrl key is hold down and a selected cell range is modified by clicking and dragging the rectangular marker in the right-bottom corner of the selection outline.
m_hCursorFormulaRangeMove Cursor displayed when the Ctrl key is released and a selected cell range is modified by clicking and dragging the rectangular marker in the right-bottom corner of the selection outline.
m_hCursorFormulaRangeNESW Northeast and southwest cursor (a double-pointed arrow pointing northeast and southwest) displayed when resizing highlighted cell references and cell range references when editing a formula.
m_hCursorFormulaRangeNWSE Northwest and southeast cursor (a double-pointed arrow pointing northeast and southwest) displayed when resizing highlighted cell references and cell range references when editing a formula.
m_hCursorFormulaRectTool Cross cursor displayed over the rectangular marker in the right-bottom corner of a selection outline.
m_hCursorFormulaRectToolPlus Cross cursor with a small plus sign over the rectangular marker in the right-bottom corner of a selection outline when the Ctrl key is hold down.

Classes

~CExtFormulaGridWnd Destructor.
CExtFormulaGridWnd Constructor.
DefaultInit Initializes a typical spreadsheet with the specified number of rows and columns and returns true if succeeded or false otherwise.
FgGetStyle Returns the current style specified by a combination of the basic __FGS_* constants.
FgGetStyleEx Returns the current style specified by a combination of the extended __FGS_EX_* constants.
FgModifyStyle Modifies the current style specified by a combination of the basic __FGS_* constants.
FgModifyStyleEx Modifies the current style specified by a combination of the basic __FGS_EX_* constants.
FormulaCompute Computes the formula of the specified grid cell, all formulas that affect this grid cell. The method returns true if succeeded or false otherwise. The second overload computes all formulas in the specified range of cells and all formulas affecting the formulas in this range and returns only the number of formulas computed in the specified range.
FormulaComputeDependentCells Computes all formulas affected by the specified grid cell and returns true if succeeded or false otherwise. The second overload computes all formulas which affected by the specified range of cells.
FormulaDuplicateRectArea Copies the values and formulas from a continuous range of cells when the user holds down and drags the rectangular marker in the right-bottom corner of the selection outline and then releases the mouse. The method returns true if succeeded or false otherwise.
FormulaErase The first override erases the formula and empties the cell empty at the specified location and, optionally, recomputes all formulas affected by the grid cell. It returns true if succeeded or false otherwise. The second override erases all formulas and, optionally, data in the specified range and, also optionally, recomputes all formulas affected by the grid cells in the specified range. The second override returns the number of erased grid cells in the specified range.
FormulaSet Assigns or erases the formula at the specified location and returns true if succeeded or false otherwise.
FormulaShift Shifts cell references for the specified grid cell and returns true if succeeded or false otherwise.

Overridables

OnFormulaGridRemoveEmptyFormulaCell Called to check if a cell is empty and, if it is the case returns true so that this empty can be removed. The method returns false if the cell is not empty.
OnFormulaGridToolRectCreationFilterMessageLoop Invoked to filter out messages in the message loop which is running during drag-n-dropping of the small box area at the right bottom side of the single rectangle selection area. Returns flag which indicates whether the message is handled.
OnFormulaGridToolRectDndFilterMessageLoop Invoked to filter out a message in the message loop which runs when the user holds down and drags the rectangular marker in the right-bottom corner of the selection outline and then releases the mouse. The method returns true if the message was handled or false otherwise.
OnFormulaGridToolRectDndTrack Invoked to move or copy a single rectangle selection by drag-and-dropping it.
OnFormulaGridToolRectExpand Invoked to expand or collapse a single rectangle selection.
OnFormulaGridToolRectHighlight Invoked to highlight or restore the selection outline when the user expands or contracts a single rectangle selection.
OnFormulaGridToolRectTrack Invoked to perform drag-and-drop tracking when the user expands or contracts a single rectangle selection.
OnGridQueryFormulaDataManager Returns a reference to the formula data manager used by the formula grid control.
OnQueryFormulaToolMetrics Returns the sizes of rectangular UI elements displayed when the user edits a formula.

See Also

CExtFormulaGridWnd Overview | Hierarchy Chart