Skip to main content

TdxSpreadSheetOptionsBehavior Properties

Stores the global behavior and functionality settings of a spreadsheet control.
Name Description
AutomaticCalculation Specifies if formula expression results are calculated automatically.
Deleting Specifies if it is possible to delete cell objects.
DragFilling Specifies if the AutoFill functionality is available to an end-user.
DragMoving Specifies if the cell drag-and-drop data moving and copying functionality is available to an end-user.
Editing Specifies if worksheet cells are editable.
EnterKeyNavigation Specifies the keystroke navigation mode.
Formatting Specifies if it is possible to customize cell styles.
FormulaAutoComplete Specifies if the Formula AutoComplete functionality is enabled.
FormulaAutoCompleteShowHint Specifies if the Formula AutoComplete dropdown window displays hints for listed functions.
History Specifies if the history functionality is enabled.
HistoryMaxActionCount Specifies the maximum number of actions recorded in undo and redo lists.
Inserting Specifies if a user can insert cells into the opened spreadsheet document.
IterativeCalculation Specifies if the spreadsheet formula engine resolves formula expressions with circular references.
IterativeCalculationMaxCount Specifies the maximum number of iterative calculations in formula expressions with circular references.
Protected Specifies if the spreadsheet document structure is protected.
SpreadSheet Provides access to the Spreadsheet or Report Designer control to which the persistent object belongs. Inherited from TdxSpreadSheetPersistentObject.
See Also