Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[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
 [Expand]Controls and Libraries
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.DashboardXpf
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Expand]DevExpress.Xpf.DataAccess.DataSourceWizard
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Expand]DevExpress.Xpf.Grid
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Expand]DevExpress.Xpf.PivotGrid
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.SpellChecker
  [Collapse]DevExpress.Xpf.Spreadsheet
   [Expand]CellData Class
    CommandBarStyle Enumeration
    ShowCellToolTipMode Enumeration
   [Expand]SpreadsheetAxisLabelOverlappingOptions Class
   [Expand]SpreadsheetBehaviorOptions Class
   [Expand]SpreadsheetCapabilitiesOptions Class
   [Expand]SpreadsheetCellOptions Class
   [Expand]SpreadsheetColumnBehaviorOptions Class
   [Expand]SpreadsheetCommentBehaviorOptions Class
   [Expand]SpreadsheetControl Class
   [Expand]SpreadsheetControlOptions Class
   [Expand]SpreadsheetCsvExportOptions Class
   [Expand]SpreadsheetCsvImportOptions Class
   [Expand]SpreadsheetCustomCellEditEventArgs Class
    SpreadsheetCustomCellEditEventHandler Delegate
   [Expand]SpreadsheetDocumentSource Class
   [Expand]SpreadsheetDrawingBehaviorOptions Class
    SpreadsheetElementVisibility Enumeration
   [Expand]SpreadsheetExportOptions Class
   [Expand]SpreadsheetFormulaBarControl Class
   [Expand]SpreadsheetGroupBehaviorOptions Class
   [Expand]SpreadsheetImportOptions Class
    SpreadsheetMenuType Enumeration
   [Expand]SpreadsheetOpenXmlImportOptions Class
   [Expand]SpreadsheetPivotTableFieldListOptions Class
    SpreadsheetPivotTableFieldListStartPosition Enumeration
   [Expand]SpreadsheetProtectionBehaviorOptions Class
   [Expand]SpreadsheetRealTimeDataOptions Class
   [Expand]SpreadsheetRowBehaviorOptions Class
   [Expand]SpreadsheetSaveOptions Class
   [Expand]SpreadsheetSelectionBehaviorOptions Class
   [Expand]SpreadsheetTxtExportOptions Class
   [Expand]SpreadsheetTxtImportOptions Class
   [Expand]SpreadsheetViewOptions Class
   [Expand]SpreadsheetWorksheetBehaviorOptions Class
   [Expand]SpreadsheetXlsImportOptions Class
   [Expand]SpreadsheetXlsmImportOptions Class
   [Expand]WorksheetDisplayArea Class
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
[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

DevExpress.Xpf.Spreadsheet Namespace

Contains classes required for WPF spreadsheet applications using the Spreadsheet suite.

Expanded Classes

  Class Description
Public class CellData Contains information about a worksheet cell.
Public class SpreadsheetAxisLabelOverlappingOptions Contains options that define how to resolve overlapping axis labels for the SpreadsheetControl's charts.
Public class SpreadsheetBehaviorOptions Provides options to restrict an end-user's ability to manage a document within the SpreadsheetControl.
Public class SpreadsheetCapabilitiesOptions Allows you to manage the capability of the document loaded in the SpreadsheetControl to support certain elements.
Public class SpreadsheetCellOptions Contains various options which can be specified for worksheet cells.
Public class SpreadsheetColumnBehaviorOptions Provides options to restrict an end-user's ability to manage columns in a worksheet of the workbook loaded into SpreadsheetControl.
Public class SpreadsheetCommentBehaviorOptions Provides options to restrict an end-user's ability to modify comments embedded into the SpreadsheetControl's document.
Public class SpreadsheetControl A spreadsheet control.
Public class SpreadsheetControlOptions Contains various options which can be specified for the SpreadsheetControl.
Public class SpreadsheetCsvExportOptions Contains options used for saving (exporting) a document in CSV format.
Public class SpreadsheetCsvImportOptions Contains options used for loading (importing) a document in CSV format.
Public class SpreadsheetCustomCellEditEventArgs Provides data for the CustomCellEdit event.
Public class SpreadsheetDocumentSource Allows binding a document from the stream to the SpreadsheetControl using MVVM pattern.
Public class SpreadsheetDrawingBehaviorOptions Provides options to restrict an end-user's ability to modify drawing objects embedded into the document.
Public class SpreadsheetExportOptions Contains options used for saving (exporting) documents.
Public class 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.
Public class SpreadsheetGroupBehaviorOptions Provides options to restrict an end-user's ability to group data.
Public class SpreadsheetImportOptions Contains options used for loading (importing) documents .
Public class SpreadsheetOpenXmlImportOptions Contains options used for loading (importing) the document in Open XML format (aka MS Word 2007 default format, .docx).
Public class SpreadsheetPivotTableFieldListOptions Contains options that specify the size and starting position of the PivotTable Field List pane at runtime.
Public class SpreadsheetProtectionBehaviorOptions Provides options to restrict an end-user's capability to protect or unprotect a document in the SpreadsheetControl.
Public class SpreadsheetRealTimeDataOptions Contains options for real-time data (RTD) function calculation.
Public class SpreadsheetRowBehaviorOptions Provides options to restrict an end-user's ability to manage rows in a worksheet of the workbook loaded into the SpreadsheetControl.
Public class SpreadsheetSaveOptions Provides access to options which define the file name and file format that are used when saving and loading the workbook.
Public class SpreadsheetSelectionBehaviorOptions Contains options affecting cell selection in the SpreadsheetControl.
Public class SpreadsheetTxtExportOptions Contains options used for saving (exporting) a document in text format.
Public class SpreadsheetTxtImportOptions Contains options used for loading (importing) a document in text format.
Public class SpreadsheetViewOptions Contains display settings of the SpreadsheetControl.
Public class SpreadsheetWorksheetBehaviorOptions Provides options to restrict an end-user's ability to manage a document within the SpreadsheetControl.
Public class SpreadsheetXlsImportOptions Contains options used for loading (importing) a document in XLS format (MS Excel 97-2003 binary file format).
Public class SpreadsheetXlsmImportOptions Contains options used for loading (importing) a document in OpenXML format with macro support (.xlsm).
Public class WorksheetDisplayArea An object that enables you to specify the visible worksheet area.

Expanded Delegates

  Delegate Description
Public delegate SpreadsheetCustomCellEditEventHandler Represents a method that will handle the CustomCellEdit event.

Expanded Enumerations

  Enumeration Description
Public enum CommandBarStyle Lists values used to specify the type of the SpreadhseetControl's command bar.
Public enum ShowCellToolTipMode Lists modes which determine whether a tooltip is displayed for the cell.
Public enum SpreadsheetElementVisibility Lists values used to specify the visibility of a certain element of the SpreadsheetControl.
Public enum SpreadsheetMenuType Lists menu types respective to visual elements for which a popup menu is invoked.
Public enum SpreadsheetPivotTableFieldListStartPosition Lists values used to specify the starting position of the PivotTable Field List pane.
How would you rate this topic?​​​​​​​