Skip to main content
BuyLog In
VCL
Search in…
Docs > VCL Controls > ExpressSpreadSheet Suite > API Reference > dxSpreadSheetCore > TdxSpreadSheetFormulaController > Members
All docs
V24.1
VCL Controls
Express Cross Platform Library
ExpressQuantumGrid Suite
ExpressEditors Library
ExpressBars Suite
ExpressCharts Suite
ExpressRichEditControl Suite
ExpressSkins Library
ExpressScheduler Suite
ExpressSpreadSheet Suite
Concepts
How to...
Shared Libraries
API Reference
cxDataControllerConditionalFormatting
cxDataControllerConditionalFormattingRulesManagerDialog
cxDataControllerSpreadSheetDataProvider
dxExpressionEditor
dxExpressionRichEdit
dxSpreadSheet
dxSpreadSheetActions
dxSpreadSheetCellStyleEditDialog
dxSpreadSheetCellStyleEditDialogController
dxSpreadSheetCellsModificationDialog
dxSpreadSheetClasses
dxSpreadSheetConditionalFormatting
dxSpreadSheetConditionalFormattingDataBarRuleStyleEditDialog
dxSpreadSheetConditionalFormattingIconSet
dxSpreadSheetConditionalFormattingRuleEditDialog
dxSpreadSheetConditionalFormattingRules
dxSpreadSheetConditionalFormattingRulesActions
dxSpreadSheetConditionalFormattingRulesManagerDialog
dxSpreadSheetConditionalFormattingRulesManagerDialogHelpers
dxSpreadSheetContainerCustomizationDialog
dxSpreadSheetContainerCustomizationDialogHelpers
dxSpreadSheetContainers
dxSpreadSheetCore
EdxSpreadSheetCannotChangePartOfArrayError
EdxSpreadSheetDefinedNameError
EdxSpreadSheetFormatError
EdxSpreadSheetInvalidPasswordError
EdxSpreadSheetProtectionError
EdxSpreadSheetReaderError
IdxSpreadSheet
IdxSpreadSheetEditControllerListener
IdxSpreadSheetKeyboardListener
IdxSpreadSheetListener
IdxSpreadSheetListener2
IdxSpreadSheetOptionsPrintListener
IdxSpreadSheetSelectionListener
IdxSpreadSheetTableView
IdxSpreadSheetTableViewSelectionModeListener
TdxCustomSpreadSheet
TdxSpreadSheetCell
TdxSpreadSheetCellCommentHideEvent
TdxSpreadSheetCellCommentShowEvent
TdxSpreadSheetCellStyle
TdxSpreadSheetCellViewInfo
TdxSpreadSheetCellViewInfoList
TdxSpreadSheetChange
TdxSpreadSheetChanges
TdxSpreadSheetConditionalFormatting
TdxSpreadSheetContainer
TdxSpreadSheetContainerAnchorPoint
TdxSpreadSheetContainerAnchorType
TdxSpreadSheetContainerClass
TdxSpreadSheetContainerEnumProc
TdxSpreadSheetContainerRestriction
TdxSpreadSheetContainerRestrictions
TdxSpreadSheetContainerTransform
TdxSpreadSheetContainers
TdxSpreadSheetCustomCellViewInfo
TdxSpreadSheetCustomConditionalFormattingRule
TdxSpreadSheetCustomDrawTableViewCellEvent
TdxSpreadSheetCustomDrawTableViewCommonCellEvent
TdxSpreadSheetCustomDrawTableViewHeaderCellEvent
TdxSpreadSheetCustomDrawingObject
TdxSpreadSheetCustomFiler
TdxSpreadSheetCustomFormat
TdxSpreadSheetCustomFormatClass
TdxSpreadSheetCustomHitTest
TdxSpreadSheetCustomReader
TdxSpreadSheetCustomReaderClass
TdxSpreadSheetCustomReferenceHighlighter
TdxSpreadSheetCustomView
TdxSpreadSheetCustomViewClass
TdxSpreadSheetCustomViewOptions
TdxSpreadSheetCustomViewPainter
TdxSpreadSheetCustomViewViewInfo
TdxSpreadSheetCustomWriter
TdxSpreadSheetCustomWriterClass
TdxSpreadSheetDefaultCellStyle
TdxSpreadSheetDefinedName
TdxSpreadSheetDefinedNames
TdxSpreadSheetExternalLink
TdxSpreadSheetExternalLinks
TdxSpreadSheetFormatsRepository
TdxSpreadSheetFormula
TdxSpreadSheetFormulaController
Members
Constructors
Properties
Methods
TdxSpreadSheetHistory
TdxSpreadSheetHistoryAction
TdxSpreadSheetHistoryActionClass
TdxSpreadSheetHistoryAddGroupAction
TdxSpreadSheetHistoryChangeConditionalFormattingAction
TdxSpreadSheetHistoryCustomCommand
TdxSpreadSheetHyperlinkExecuteEvent
TdxSpreadSheetLockedStateImageOptions
TdxSpreadSheetMergedCell
TdxSpreadSheetMergedCellList
TdxSpreadSheetMergedCellListEnumCellsProc
TdxSpreadSheetMergedCellListEnumRowsProc
TdxSpreadSheetMergedCellsRow
TdxSpreadSheetObjectList
TdxSpreadSheetObjectListItem
TdxSpreadSheetOptionsBehavior
TdxSpreadSheetOptionsMetadata
TdxSpreadSheetOptionsView
TdxSpreadSheetPageControl
TdxSpreadSheetPageControlButton
TdxSpreadSheetPageControlButtons
TdxSpreadSheetPageControlContextPopupEvent
TdxSpreadSheetPageControlHitTest
TdxSpreadSheetPageControlNewTabButtonClickEvent
TdxSpreadSheetPageControlTabDragAndDropEvent
TdxSpreadSheetPageControlTabEndDragEvent
TdxSpreadSheetPageControlTabStartDragEvent
TdxSpreadSheetPersistentObject
TdxSpreadSheetPrepareLockedStateImageEvent
TdxSpreadSheetProgressEvent
TdxSpreadSheetRTFService
TdxSpreadSheetScrollEvent
TdxSpreadSheetShrinkToFitCalculator
TdxSpreadSheetState
TdxSpreadSheetStates
TdxSpreadSheetStyles
TdxSpreadSheetTableColumn
TdxSpreadSheetTableColumns
TdxSpreadSheetTableItem
TdxSpreadSheetTableItemEnumProc
TdxSpreadSheetTableItemGroup
TdxSpreadSheetTableItemGroupExpandButtonPosition
TdxSpreadSheetTableItemGroups
TdxSpreadSheetTableItems
TdxSpreadSheetTableRow
TdxSpreadSheetTableRows
TdxSpreadSheetTableView
TdxSpreadSheetTableViewAbstractCellViewInfo
TdxSpreadSheetTableViewActiveCellChangingEvent
TdxSpreadSheetTableViewCellViewInfo
TdxSpreadSheetTableViewCellViewInfoList
TdxSpreadSheetTableViewClearCellsOption
TdxSpreadSheetTableViewClearCellsOptions
TdxSpreadSheetTableViewContextPopupEvent
TdxSpreadSheetTableViewCustomCellViewInfo
TdxSpreadSheetTableViewCustomDataCellViewInfo
TdxSpreadSheetTableViewCustomGroupingAreaViewInfo
TdxSpreadSheetTableViewForEachCellProc
TdxSpreadSheetTableViewHeaderCellViewInfo
TdxSpreadSheetTableViewHitTest
TdxSpreadSheetTableViewInfo
TdxSpreadSheetTableViewMergedCellViewInfo
TdxSpreadSheetTableViewMergedCellViewInfoList
TdxSpreadSheetTableViewMergedCellsConflictResolution
TdxSpreadSheetTableViewOptions
TdxSpreadSheetTableViewOptionsPrint
TdxSpreadSheetTableViewPainter
TdxSpreadSheetTableViewSelection
TdxSpreadSheetTableViewSelectionMode
TdxSpreadSheetTableViewSelectionViewInfo
TdxSpreadSheetTextService
TdxSpreadSheetTextServiceClass
TdxSpreadSheetViewAbstractCellViewInfo
TdxSpreadSheetViewCompareValuesEvent
TdxSpreadSheetViewInitInplaceEditEvent
TdxSpreadSheetViewInitInplaceEditValueEvent
TdxSpreadSheetViewInplaceEditingEvent
TdxSpreadSheetViewNotifyEvent
TdxSpreadSheetViewPersistentObject
dxSpreadSheetBestFitWidthCorrectionPercentage
dxSpreadSheetContainerRotateMarkerColor1
dxSpreadSheetContainerRotateMarkerColor2
dxSpreadSheetContainerRotateMarkerSize
dxSpreadSheetContainerSelectionFrameColor
dxSpreadSheetContainerSizingMarkerColor1
dxSpreadSheetContainerSizingMarkerColor2
dxSpreadSheetContainerSizingMarkerSize
dxSpreadSheetFormatsRepository
dxSpreadSheetMovingClonedContainerAlpha
dxSpreadSheetMovingContainerAlpha
dxSpreadSheetResizingContainerAlpha
dxSpreadSheetRotationContainerAlpha
dxSpreadSheetTextService
hcBackground
hcButton
hcCell
hcColumnHeader
hcContainer
hcContainerSelection
hcExpandButton
hcFrozenPaneSeparator
hcGroup
hcGroupingArea
hcHyperlink
hcPageTab
hcResizeArea
hcRowHeader
hcSelectionFrame
hcSplitter
ssvsBackground
ssvsContent
ssvsHeader
ssvsPageControl
ssvsSelection
dxSpreadSheetCoreFormulas
dxSpreadSheetCoreFormulasParser
dxSpreadSheetCoreReferences
dxSpreadSheetCoreStyles
dxSpreadSheetDefinedNameEditDialog
dxSpreadSheetDefinedNameManagerDialog
dxSpreadSheetDefinedNamesCreateFromSelectionDialog
dxSpreadSheetEditHyperlinkDialog
dxSpreadSheetFindAndReplaceDialog
dxSpreadSheetFormatCSV
dxSpreadSheetFormatCellsDialog
dxSpreadSheetFormatODSHelpers
dxSpreadSheetFormatTXT
dxSpreadSheetFormattedTextUtils
dxSpreadSheetFormulaBar
dxSpreadSheetFormulas
dxSpreadSheetFunctions
dxSpreadSheetGraphics
dxSpreadSheetHyperlinks
dxSpreadSheetInplaceEdit
dxSpreadSheetInsertFunctionDialog
dxSpreadSheetNumberFormat
dxSpreadSheetPageSetupDialog
dxSpreadSheetPageSetupHeaderFooterDialog
dxSpreadSheetPasswordDialog
dxSpreadSheetPasteSpecialDialog
dxSpreadSheetPopupMenu
dxSpreadSheetPrinting
dxSpreadSheetProtectSheetDialog
dxSpreadSheetProtectWorkbookDialog
dxSpreadSheetProtection
dxSpreadSheetReferenceEditDialog
dxSpreadSheetReportDesigner
dxSpreadSheetReportDesignerActions
dxSpreadSheetStyles
dxSpreadSheetTypes
dxSpreadSheetUnhideSheetDialog
dxSpreadSheetUtils
ExpressQuantumTreeList Suite
ExpressPDFViewer Suite
ExpressPrinting System
ExpressLayoutControl Suite
ExpressNavBar Suite
ExpressPivotGrid Suite
ExpressVerticalGrid Suite
ExpressDocking Library
ExpressMemData
ExpressDataController
ExpressSpellChecker Suite
ExpressMapControl Suite
ExpressGanttControl Suite
ExpressGaugeControl Suite
ExpressTileControl Suite
ExpressFlowChart Suite
ExpressFlowChart Editor
ExpressOrgChart Suite
ExpressPageControl Suite
ExpressWizardControl Suite

TdxSpreadSheetFormulaController Members

A formula expression manager employed by the Spreadsheet and Report Designer controls.

Constructors

Name Description
Create(TdxCustomSpreadSheet) Initializes a new instance of the TdxSpreadSheetFormulaController class with specified settings.
Create(Boolean) Creates a TcxObjectList class instance. Inherited from TcxObjectList.

Properties

Name Description
ArrayFormulas protected Provides access to the list of parsed formula expressions that return array results. Inherited from TdxSpreadSheetCustomFormulaController.
CalculationInProcess Identifies if the formula controller is currently performing a calculation. Inherited from TdxSpreadSheetCustomFormulaController.
Capacity Inherited from TList.
CircularReferencePaths Provides access to the circular reference paths stored by a spreadsheet control’s formula controller. Inherited from TdxSpreadSheetCustomFormulaController.
CircularReferencePathsAsString Returns the list of all circular reference paths in a spreadsheet. Inherited from TdxSpreadSheetCustomFormulaController.
Count Inherited from TList.
FormatSettings Provides access to the format settings used to parse formula expressions. Inherited from TdxSpreadSheetCustomFormulaController.
Items Provides indexed access to all parsed formula expressions managed by this controller.
List Inherited from TList.
OwnObjects Indicates whether the list manages instances of its stored items. Inherited from TcxObjectList.
SpreadSheet Returns the Spreadsheet or Report Designer control instance to which the formula controller belongs.

Methods

Name Description
Add(Pointer) Inherited from TList.
AddArrayFormula(TdxSpreadSheetCustomFormula) Inherited from TdxSpreadSheetCustomFormulaController.
Assign(TList,TListAssignOp,TList) Inherited from TList.
Calculate Calculates all formula expressions in the opened spreadsheet document.
Clear Clears the list. Inherited from TcxObjectList.
Delete(Integer) Inherited from TList.
EnumArrayFormulas(TObject,TdxSpreadSheetEnumFormulasFunc) Inherited from TdxSpreadSheetCustomFormulaController.
Equals(TObject) Inherited from TObject.
Error(PResStringRec,NativeInt) Inherited from TList.
Error(String,NativeInt) Inherited from TList.
Exchange(Integer,Integer) Inherited from TList.
Expand Inherited from TList.
Extract(Pointer) Inherited from TList.
ExtractItem(Pointer,TDirection) Inherited from TList.
First Inherited from TList.
FreeAndDelete(Integer) Destroys a stored item by its index in the list. Inherited from TcxObjectList.
FreeAndRemove(TObject) Removes the specified item from the list and destroys it. Inherited from TcxObjectList.
GetHashCode Inherited from TObject.
IndexOf(Pointer) Inherited from TList.
IndexOfItem(Pointer,TDirection) Inherited from TList.
Insert(Integer,Pointer) Inherited from TList.
Last Inherited from TList.
Move(Integer,Integer) Inherited from TList.
Pack Inherited from TList.
Remove(TdxSpreadSheetCustomFormula) Inherited from TdxSpreadSheetCustomFormulaController.
Remove(Pointer) Inherited from TList.
RemoveItem(Pointer,TDirection) Inherited from TList.
Sort(TListSortCompare) Inherited from TList.
SortList(TListSortCompareFunc) Inherited from TList.
ToString Inherited from TObject.
UpdateAnchorsAndBounds Inherited from TdxSpreadSheetCustomFormulaController.
UpdateReferences(TdxSpreadSheetTableView,TRect,TPoint,TdxSpreadSheetFormulaUpdateReferencesMode) Updates cell references for one or more parsed formula expressions.
UpdateReferences(TdxSpreadSheetCustomFormula,TdxSpreadSheetTableView,TRect,TPoint,TdxSpreadSheetFormulaUpdateReferencesMode)
See Also