TdxSpreadSheetFormulaUpdateReferencesMode Enum

Enumerates cell management operations that update references within parsed formula expressions.

Declaration

TdxSpreadSheetFormulaUpdateReferencesMode = (
    urmInsert,
    urmDelete,
    urmMove
);

Members

Name
urmInsert
urmDelete
urmMove

Remarks

Options include:

Value	Description
urmInsert	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.
urmDelete	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.
urmMove	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.