SpreadsheetFormulaBar Class
Displays the active cell’s address and content and is used to view, enter and edit formulas and cell data in the SpreadsheetControl.
Namespace: DevExpress.XtraSpreadsheet
Assembly: DevExpress.XtraSpreadsheet.v24.1.dll
NuGet Package: DevExpress.Win.Spreadsheet
Declaration
[ComVisible(false)]
public class SpreadsheetFormulaBar :
XtraUserControl,
IToolTipControlClient,
IFormulaBarControllerOwner,
IFormulaBarControlRemarks
The SpreadsheetFormulaBar class specifies a visual control that displays the address and content of the active cell. It allows end-users to view, enter and edit data values and formulas contained in worksheet cells as well as a cell’s in-place editor.
Use the following properties to control the visibility of the Formula Bar‘s elements:
SpreadsheetFormulaBar.ShowNameBox - shows or hides the Name Box;
SpreadsheetFormulaBar.ShowButtons - shows or hides the Cancel, Enter and Insert function buttons;
SpreadsheetFormulaBar.ShowEditor - shows or hides the formula editor.
The SpreadsheetFormulaBar.SpreadsheetControl property should be set to the SpreadsheetControl instance to bind the SpreadsheetFormulaBar to the spreadsheet.