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 | Deprecated. This property exists for backward compatibility only. Use the OptionsProtection.Protected property instead. |
| SpreadSheet | Provides access to the Spreadsheet or Report Designer control to which the persistent object belongs. Inherited from TdxSpreadSheetPersistentObject. |
See Also