[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Collapse]Spreadsheet
    Product Structure
   [Expand]Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Shapes
    Printing
    Protection
    Find and Replace
   [Expand]Mail Merge
   [Expand]Visual Elements
    Services
    Themes and Templates
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Product Structure

Use the following links to access reference information about the most important classes and interfaces of the WPF Spreadsheet.

Class Description
SpreadsheetControl A visual control that allows you to create, load, edit, save and print spreadsheet documents.
SpreadsheetFormulaBarControl A control that displays the cell address and the contents of the current cell. Use it to enter or edit formulas and cell data.
SpreadsheetControlOptions Stores settings specific for the SpreadsheetControl.
SpreadsheetBehaviorOptions Contains options used to restrict an end-user's ability to manage a document within the SpreadsheetControl.
IWorkbook A document in the SpreadsheetControl.
Worksheet An individual Worksheet in a workbook.
Row An individual row in a worksheet.
Column An individual column in a worksheet.
Cell A box at the intersection of a column and a row in a worksheet that can contain worksheet data, a formula and formatting.
Range The base interface that provides the functionality required to work with a worksheet cell and a range of cells.
CellValue A data value contained in a cell.
Formatting An interface containing options to change cell format settings: fill, font, alignment, borders, and number format.
RichTextString Rich formatted text in a cell.
ConditionalFormatting The base interface for conditional formatting rules.
DefinedName A name that refers to a cell, cell range, formula, or constant value.
WorkbookFunctions An interface that provides access to the built-in worksheet Functions divided into categories by their functionality and allows you to override a specific function.
ICustomFunction An interface that provides basic properties and methods required to implement a custom worksheet function.
FormulaEngine Provides the capability to calculate and parse worksheet formulas. See Formula Engine.
Hyperlink A hyperlink associated with a cell or cell range.
Comment A comment attached to a worksheet cell.
Picture An embedded image in a worksheet.
Chart An embedded chart in a worksheet.
Table A table in a worksheet.
PivotTable A PivotTable report in a worksheet.
WorksheetDataBinding An interface containing information about a cell range bound to an external data source or used to create a data source. See Data Binding.
CustomCellInplaceEditor A custom cell in-place editor assigned to a cell or cell range in a worksheet.

Expanded See Also

Is this topic helpful?​​​​​​​