Skip to main content

TdxSpreadSheetFormulaBar Class

A Formula Bar control.

Declaration

TdxSpreadSheetFormulaBar = class(
    TdxSpreadSheetCustomFormulaBar
)

Remarks

This component complements a Spreadsheet control and allows users to view, enter, and edit cell values and formula expressions in a way similar to popular spreadsheet applications.

VCL Spreadsheet: A Formula Bar Example

Like in-place cell editors in the active worksheet, the Formula Bar has Formula AutoComplete functionality designed to suggest registered functions and available defined names that match the entered portion of a recognized name:

VCL Spreadsheet: Formula AutoComplete Functionality

The Name Box can create defined names, as well as search and rename floating containers in the opened document.

VCL Spreadsheet: Formula Bar — Name Box

To get started with the Formula Bar control, place it on an application form that already contains a spreadsheet control. If you use multiple spreadsheet controls simultaneously, assign the target control to the SpreadSheet property.

See Also