TdxSpreadSheetFormulaUpdateReferencesMode Enum
In This Article
Enumerates cell management operations that update references within parsed formula expressions.
#Declaration
Delphi
TdxSpreadSheetFormulaUpdateReferencesMode = (
urmInsert,
urmDelete,
urmMove
);
#Members
Name |
---|
urm
|
urm
|
urm
|
#Remarks
Options include:
Value | Description |
---|---|
urm |
A formula controller that updates references to cells/cell ranges that are moved right and/or down as a result of inserting a cell, row, or column in a Table View worksheet. |
urm |
A formula controller that updates references to cells/cell ranges that are moved left and/or up as a result of deleting a cell, row, or column in a worksheet. |
urm |
A formula controller that updates references to cells/cell ranges that are moved to a different position within a worksheet. |
The AMode parameter of the Spreadsheet/Report Designer‘s FormulaController.UpdateReferences procedure references the TdxSpreadSheetFormulaUpdateReferencesMode type. Note that the formula controller that manages data controllers‘ conditional formatting rule expressions does not implement the corresponding procedure.
See Also