Create Separate Ribbon Pages for the Spreadsheet
- 2 minutes to read
This topic describes how to add an Excel-inspired ribbon UI to the WPF Spreadsheet.
The ribbon generation mechanism described in this topic is outdated and retained for backward compatibility. The WPF Spreadsheet ships with an integrated ribbon in v17.1 and higher. This makes the XAML markup compact and more readable. See the following help topics for more information on the integrated ribbon:
Create a Spreadsheet Application
Create a new WPF Application project and open the MainWindow.xaml file in the Visual Studio designer.
Add the SpreadsheetControl object to your project. Drag the SpreadsheetControl item from the DX.21.2: Spreadsheet Toolbox tab onto the canvas.
Reset the Spreadsheet control’s layout to fill the entire window. Right-click the control and select Layout | Reset All in the context menu.
Create Ribbon Pages
Invoke the SpreadsheetControl’s Quick Actions menu to create individual ribbon pages. Under Create Separate Command Bars, select the ribbon page you wish to add to your application and click Create Ribbon Items. Select All to create all available spreadsheet ribbon pages.
You can also display the integrated Formula Bar and Status Bar. In the invoked SpreadsheetControl’s Quick Actions menu, under Integrated Ribbon and Formula Bar, enable the ShowFormulaBar and ShowStatusBar checkboxes.
When you execute ribbon commands, these commands can throw unhandled exceptions (for example, when you attempt to save a document to a read-only or locked file). To prevent application failure, handle the SpreadsheetControl.UnhandledException event and set the SpreadsheetUnhandledExceptionEventArgs.Handled property to true.