TdxSpreadSheetOptionsBehavior Class
Stores the global behavior and functionality settings of a spreadsheet control.
Declaration
TdxSpreadSheetOptionsBehavior = class(
TdxSpreadSheetPersistentObject
)Remarks
This class has the following members that allow you to:
Switch between automatic and on-demand formula expression calculation modes (AutomaticCalculation).
Enable formula expressions with circular references and set the maximum number of iterations (IterativeCalculation and IterativeCalculationMaxCount).
Disable or enable the Formula AutoComplete functionality and/or suggestion hints (FormulaAutoComplete and FormulaAutoCompleteShowHint).
Disable or enable different document edit options (Deleting, Editing, Formatting, and Inserting).
Disable or enable cell operations via drag-and-drop (DragFilling and DragMoving).
Protect the spreadsheet document structure (Protected).
Enable the action history functionality and limit the undo action list (History and HistoryMaxActionCount).
Determine how an end-user navigates between locked cells within a protected worksheet (EnterKeyNavigation).
Access the control to which this property set belongs (SpreadSheet).
Direct TdxSpreadSheetOptionsBehavior Class Reference
A spreadsheet control’s OptionsBehavior property references a TdxSpreadSheetOptionsBehavior object.