Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Spreadsheet Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Printing
    Events
   [Expand]Mail Merge Overview
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Getting Started

This tutorial describes how to create a simple spreadsheet application with a Ribbon interface.

  1. Start Visual Studio and create a new Windows Forms Application project by selecting FILE | New | Project… in the main menu. In the invoked New Project window, select Windows Forms Application, specify the name of the project, and click OK.

  2. Drop the SpreadsheetControl item from the DX.17.2: Spreadsheet toolbox tab onto the form.

  3. Click the SpreadsheetControl's smart tag and select Dock in Parent Container in the invoked SpreadsheetControl Tasks menu.

  4. Select Create FormulaBar in the SpreadsheetControl Tasks menu. This will automatically add the SpreadsheetNameBoxControl and SpreadsheetFormulaBarControl controls onto the form, bind them to the SpreadsheetControl, and position them above the spreadsheet work area.

  5. Select Create Ribbon in the SpreadsheetControl Tasks menu. This will add a RibbonControl onto the form and automatically position it above the spreadsheet name box and formula bar.

  6. Select Create All Bars in the SpreadsheetControl Tasks menu to add all available spreadsheet Ribbon pages at once.

  7. The spreadsheet application is ready now. Run it to view the result. For example, enter data in a cell, try creating a formula and formatting cells, and explore various Ribbon items.

Note

Commands executed via the Bar (Ribbon) user interface can throw unhandled exceptions if a problem occurs. Consider the situation when a document is being saved to a locked or read-only file. To prevent application failure, subscribe to the SpreadsheetControl.UnhandledException event and set the SpreadsheetUnhandledExceptionEventArgs.Handled property to true.

For more examples on how to work with the SpreadsheetControl, refer to the Examples section.

How would you rate this topic?​​​​​​​