SpreadsheetControl.CreateBars() Method

Creates a BarManager that contains all SpreadsheetControl-specific bars.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v19.1.dll

Declaration

C#

public BarManager CreateBars()

VB.NET

Public Function CreateBars As BarManager

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. The current method creates all available bars, except for the Mail Merge toolbar. You can use the AddToolbarToMenuManager method to add this toolbar to the control, as shown below:

C#

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

public Form1()
{
    InitializeComponent();

    // Create the Spreadsheet's toolbar menu.
    BarManager bars = spreadsheetControl1.CreateBars();
    // Add the Mail Merge bars to the control.
    spreadsheetControl1.AddToolbarToMenuManager(SpreadsheetToolbarType.MailMerge);
    bars.Form = this;
}

VB.NET

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

Public Class Form1
    Public Sub New()
        InitializeComponent()

        ' Create the Spreadsheet's toolbar menu.
        Dim bars As BarManager = spreadsheetControl1.CreateBars()
        ' Add the Mail Merge bars to the control.
        spreadsheetControl1.AddToolbarToMenuManager(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.