SpreadsheetControl.CreateBars(SpreadsheetToolbarType) Method

Adds a BarManager with the specified bars to the SpreadsheetControl.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v18.2.dll

Declaration

C#

public BarManager CreateBars(
    SpreadsheetToolbarType toolbarType
)

VB.NET

Public Function CreateBars(
    toolbarType As SpreadsheetToolbarType
) As BarManager

Parameters

Name	Type	Description
toolbarType	SpreadsheetToolbarType	The SpreadsheetToolbarType enumeration members that specify toolbars to add to the control.

Returns

Type	Description
BarManager	A component that manages the created toolbars.

Remarks

Use the CreateBars method overloads to create a toolbar menu that allows end users to perform basic operations in the SpreadsheetControl.

C#

using DevExpress.XtraBars.Ribbon;
using DevExpress.XtraSpreadsheet;
// ...

public Form1()
{
    InitializeComponent();

    // Create all available spreadsheet toolbars.
    BarManager bars = spreadsheetControl1.CreateBars(SpreadsheetToolbarType.All | SpreadsheetToolbarType.MailMerge);
    bars.Form = this;
}

VB.NET

Imports DevExpress.XtraBars.Ribbon
Imports DevExpress.XtraSpreadsheet
' ...

Public Class Form1
    Public Sub New()
        InitializeComponent()

        ' Create all available spreadsheet toolbars.
        Dim bars As BarManager = spreadsheetControl1.CreateBars(SpreadsheetToolbarType.All Or SpreadsheetToolbarType.MailMerge)
        bars.Form = Me
    End Sub
End Class

To create a toolbar menu at design time, select the Create BarManager item in the SpreadsheetControl’s smart tag menu.

You can also use the CreateRibbon method to provide the modern ribbon interface for the SpreadsheetControl.