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.v25.2.dll

NuGet Package : DevExpress.Win.Spreadsheet

Declaration

C#
VB.NET

csharp

[ComVisible(false)]
[DXLicenseWinForms]
public class SpreadsheetFormulaBar :
    XtraUserControl,
    IToolTipControlClient,
    IFormulaBarControllerOwner,
    IFormulaBarControl

<ComVisible(False)>
<DXLicenseWinForms>
Public Class SpreadsheetFormulaBar
    Inherits XtraUserControl
    Implements IToolTipControlClient,
               IFormulaBarControllerOwner,
               IFormulaBarControl

Remarks

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.

Implements

IXtraResizableControl

Inheritance

Object MarshalByRefObject Component Control ScrollableControl ContainerControl UserControl XtraUserControl SpreadsheetFormulaBar