Back to Devexpress

SpreadsheetControl.CreateBars() Method

windowsforms-devexpress-dot-xtraspreadsheet-dot-spreadsheetcontrol-84c6ae54.md

latest2.9 KB
Original Source

SpreadsheetControl.CreateBars() Method

Creates a BarManager that contains all SpreadsheetControl-specific bars.

Namespace : DevExpress.XtraSpreadsheet

Assembly : DevExpress.XtraSpreadsheet.v25.2.dll

NuGet Package : DevExpress.Win.Spreadsheet

Declaration

csharp
public BarManager CreateBars()
vb
Public Function CreateBars As BarManager

Returns

TypeDescription
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:

csharp
using DevExpress.XtraBars;
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
Imports DevExpress.XtraBars
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.

See Also

SpreadsheetControl Class

SpreadsheetControl Members

DevExpress.XtraSpreadsheet Namespace