Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetFormulaUpdateReferencesMode Enum

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

#Declaration

Delphi
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.

See Also