[Expand]General Information
[Expand]WinForms Controls
[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
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Expand]Spreadsheet Document API
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Collapse]API Reference
  [Expand]DevExpress.BarCodes
  [Expand]DevExpress.Compression
  [Expand]DevExpress.Docs.Text
  [Expand]DevExpress.Office
  [Expand]DevExpress.Office.Drawing
  [Expand]DevExpress.Office.Export
  [Expand]DevExpress.Office.Export.Html
  [Expand]DevExpress.Office.Import
  [Expand]DevExpress.Office.Localization
  [Expand]DevExpress.Office.Options
  [Expand]DevExpress.Office.Services
  [Expand]DevExpress.Office.Utils
  [Expand]DevExpress.Pdf
  [Expand]DevExpress.Pdf.Localization
  [Expand]DevExpress.Snap
  [Expand]DevExpress.Spreadsheet
  [Expand]DevExpress.Spreadsheet.Charts
  [Expand]DevExpress.Spreadsheet.Drawings
  [Expand]DevExpress.Spreadsheet.Export
  [Expand]DevExpress.Spreadsheet.Formulas
  [Expand]DevExpress.Spreadsheet.Functions
  [Expand]DevExpress.UnitConversion
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.API.Layout
  [Expand]DevExpress.XtraRichEdit.API.Native
  [Expand]DevExpress.XtraRichEdit.API.Native.Implementation
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Export.Html
  [Expand]DevExpress.XtraRichEdit.Export.PlainText
  [Expand]DevExpress.XtraRichEdit.Export.Rtf
  [Expand]DevExpress.XtraRichEdit.Forms
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Services
  [Expand]DevExpress.XtraRichEdit.Utils
  [Collapse]DevExpress.XtraSpreadsheet
   [Expand]AfterDropRangeEventArgs Class
    AfterDropRangeEventHandler Delegate
   [Expand]AfterFillRangeEventArgs Class
    AfterFillRangeEventHandler Delegate
   [Expand]BeforeDragRangeEventArgs Class
    BeforeDragRangeEventHandler Delegate
   [Expand]BeforeDropRangeEventArgs Class
    BeforeDropRangeEventHandler Delegate
   [Expand]BeforeFillRangeEventArgs Class
    BeforeFillRangeEventHandler Delegate
    CellBeginEditEventHandler Delegate
    CellCancelEditEventHandler Delegate
    CellEditorCommitMode Enumeration
    CellEditorEnterValueMode Enumeration
    CellEditorMode Enumeration
    CellEndEditEventHandler Delegate
    CellValueChangedAction Enumeration
    CellValueChangedEventHandler Delegate
   [Expand]DataBindingWarningEventArgs Class
    DataBindingWarningEventHandler Delegate
    DataBindingWarningType Enumeration
    DataTransferMode Enumeration
   [Expand]DefinedNameDeletingEventArgs Class
    DefinedNameDeletingEventHandler Delegate
   [Expand]DefinedNameEditingEventArgs Class
    DefinedNameEditingEventHandler Delegate
   [Expand]DefinedNameEventArgsBase Class
    DocumentCapability Enumeration
   [Expand]DocumentPropertiesChangedEventArgs Class
    DocumentPropertiesChangedEventHandler Delegate
    DragDropOperationType Enumeration
    FillOperationType Enumeration
    FormulaAutoCompleteSearchMode Enumeration
    FunctionNameCulture Enumeration
   [Expand]HyperlinkClickEventArgs Class
    HyperlinkClickEventHandler Delegate
    MoveActiveCellModeOnEnterPress Enumeration
   [Expand]RealTimeDataOptions Class
    RealTimeDataRefreshMode Enumeration
    ShowSelectionMode Enumeration
   [Expand]SpreadsheetAxisLabelOverlappingOptions Class
   [Expand]SpreadsheetBehaviorOptions Class
   [Expand]SpreadsheetCellCancelEditEventArgs Class
   [Expand]SpreadsheetCellCancelEventArgs Class
   [Expand]SpreadsheetCellEditorBehaviorOptions Class
   [Expand]SpreadsheetCellEventArgs Class
   [Expand]SpreadsheetCellEventArgsBase Class
   [Expand]SpreadsheetCellOptions Class
   [Expand]SpreadsheetCellValidatingEventArgs Class
   [Expand]SpreadsheetChartsViewOptions Class
   [Expand]SpreadsheetClipboardOptions Class
   [Expand]SpreadsheetColumnBehaviorOptions Class
   [Expand]SpreadsheetCommentBehaviorOptions Class
   [Expand]SpreadsheetCompatibilityOptions Class
   [Expand]SpreadsheetCopyOptions Class
    SpreadsheetCustomAssemblyBehavior Enumeration
   [Expand]SpreadsheetDataSourceLoadingOptions Class
   [Expand]SpreadsheetDataValidationBehaviorOptions Class
    SpreadsheetDecryptionError Enumeration
   [Expand]SpreadsheetDecryptionException Class
   [Expand]SpreadsheetDrawingBehaviorOptions Class
   [Expand]SpreadsheetFillHandleBehaviorOptions Class
   [Expand]SpreadsheetFormulaAutoCompleteOptions Class
   [Expand]SpreadsheetGroupBehaviorOptions Class
   [Expand]SpreadsheetPivotTableFieldListOptions Class
    SpreadsheetPivotTableFieldListStartPosition Enumeration
   [Expand]SpreadsheetPrintOptions Class
    SpreadsheetPrintRenderMode Enumeration
   [Expand]SpreadsheetProtectionBehaviorOptions Class
   [Expand]SpreadsheetProtectionOptions Class
   [Expand]SpreadsheetRowBehaviorOptions Class
   [Expand]SpreadsheetSelectionOptions Class
   [Expand]SpreadsheetUnhandledExceptionEventArgs Class
   [Expand]SpreadsheetViewOptions Class
   [Expand]SpreadsheetWorksheetBehaviorOptions Class
    UnhandledExceptionEventHandler Delegate
   [Expand]WorkbookCapabilitiesOptions Class
   [Expand]WorkbookEventOptions Class
   [Expand]WorkbookSaveOptions Class
  [Expand]DevExpress.XtraSpreadsheet.Export
  [Expand]DevExpress.XtraSpreadsheet.Export.Html
  [Expand]DevExpress.XtraSpreadsheet.Import
  [Expand]DevExpress.XtraSpreadsheet.Localization
  [Expand]DevExpress.XtraSpreadsheet.Services
[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)

DevExpress.XtraSpreadsheet Namespace

Contains the SpreadsheetControl class that provides the main functionality of the XtraSpreadsheet Suite.

Expanded Classes

  Class Description
Public class AfterDropRangeEventArgs Provides data for the SpreadsheetControl.AfterDropRange event.
Public class AfterFillRangeEventArgs Provides data for the SpreadsheetControl.AfterFillRange event.
Public class BeforeDragRangeEventArgs Provides data for the SpreadsheetControl.BeforeDragRange event.
Public class BeforeDropRangeEventArgs Provides data for the SpreadsheetControl.BeforeDropRange event.
Public class BeforeFillRangeEventArgs Provides data for the SpreadsheetControl.BeforeFillRange event.
Public class DataBindingWarningEventArgs Provides data for the DataBindingWarning event.
Public class DefinedNameDeletingEventArgs Provides data for the SpreadsheetControl.DefinedNameDeleting event.
Public class DefinedNameEditingEventArgs Provides data for the SpreadsheetControl.DefinedNameEditing event.
Public class DefinedNameEventArgsBase Base class for classes that provides data for the DefinedNameDeleting and DefinedNameEditing events of the SpreadsheetControl.
Public class DocumentPropertiesChangedEventArgs Provides data for the SpreadsheetControl.DocumentPropertiesChanged event.
Public class HyperlinkClickEventArgs Provides data for the HyperlinkClick event.
Public class RealTimeDataOptions Contains options for real-time data (RTD) function calculation.
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 SpreadsheetCellCancelEditEventArgs Provides data for the CellCancelEdit event.
Public class SpreadsheetCellCancelEventArgs Provides data for the CellBeginEdit event and serves as the base class for SpreadsheetCellValidatingEventArgs.
Public class SpreadsheetCellEditorBehaviorOptions Contains options for the cell editor.
Public class SpreadsheetCellEventArgs Provides data for the CellValueChanged event.
Public class SpreadsheetCellEventArgsBase Serves as the base for classes which provide data for the events which occur on changing cell values via the SpreadsheetControl UI.
Public class SpreadsheetCellOptions Contains various options which can be specified for worksheet cells.
Public class SpreadsheetCellValidatingEventArgs Provides data for the CellEndEdit event.
Public class SpreadsheetChartsViewOptions Provides access to the chart-specific properties of the SpreadsheetControl.
Public class SpreadsheetClipboardOptions Provides clipboard options for the SpreadsheetControl.
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 SpreadsheetCompatibilityOptions Contains options used to ensure compatibility with previous Spreadsheet versions.
Public class SpreadsheetCopyOptions A set of options used to control copy operations.
Public class SpreadsheetDataSourceLoadingOptions Contains options which affect how the mail merge data source is created and its data is loaded.
Public class SpreadsheetDataValidationBehaviorOptions Provides options to restrict an end-user's capability to manage data validation rules in a document loaded into SpreadsheetControl.
Public class SpreadsheetDecryptionException Fires under certain conditions when an attempt to load a password-protected .xls file fails.
Public class SpreadsheetDrawingBehaviorOptions Provides options to restrict an end-user's ability to modify drawing objects embedded into the SpreadsheetControl's document.
Public class SpreadsheetFillHandleBehaviorOptions Contains an option which turns the Fill Handle feature on or off.
Public class SpreadsheetFormulaAutoCompleteOptions Contains options affecting the Formula AutoComplete functionality.
Public class SpreadsheetGroupBehaviorOptions Provides options to restrict an end-user's ability to group data.
Public class SpreadsheetPivotTableFieldListOptions Contains options that specify the size and starting position of the PivotTable Field List pane at runtime.
Public class SpreadsheetPrintOptions Provides access to options that control how the printed document is generated and previewed.
Public class SpreadsheetProtectionBehaviorOptions Provides options to restrict an end-user's capability to protect or unprotect a document in the SpreadsheetControl.
Public class SpreadsheetProtectionOptions Provides access to options specifying the encryption parameters.
Public class SpreadsheetRowBehaviorOptions Provides options to restrict an end-user's ability to manage rows in a worksheet of the workbook loaded into SpreadsheetControl.
Public class SpreadsheetSelectionOptions Contains options affecting cell selection in the SpreadsheetControl.
Public class SpreadsheetUnhandledExceptionEventArgs Provides data for the UnhandledException event.
Public class SpreadsheetViewOptions Provides access to a set of display settings of the SpreadsheetControl.
Public class SpreadsheetWorksheetBehaviorOptions Provides options to restrict an end-user's ability to manage worksheets of the workbook loaded into SpreadsheetControl.
Public class WorkbookCapabilitiesOptions Provides various options which can be specified for the document loaded in the SpreadsheetControl.
Public class WorkbookEventOptions Provides options to specify how certain events are raised for the workbook.
Public class WorkbookSaveOptions Provides access to options which define the file name and file format that are used when saving and loading the workbook.

Expanded Delegates

  Delegate Description
Public delegate AfterDropRangeEventHandler A method that handles the SpreadsheetControl's AfterDropRange event.
Public delegate AfterFillRangeEventHandler A method that handles the SpreadsheetControl's AfterFillRange event.
Public delegate BeforeDragRangeEventHandler A method that handles the SpreadsheetControl's BeforeDragRange event.
Public delegate BeforeDropRangeEventHandler A method that handles the SpreadsheetControl's BeforeDropRange event.
Public delegate BeforeFillRangeEventHandler A method that handles the SpreadsheetControl's BeforeFillRange event.
Public delegate CellBeginEditEventHandler A method that will handle the CellBeginEdit event of the SpreadsheetControl.
Public delegate CellCancelEditEventHandler A method that will handle the CellCancelEdit event of the SpreadsheetControl.
Public delegate CellEndEditEventHandler A method that will handle the CellEndEdit event of the SpreadsheetControl.
Public delegate CellValueChangedEventHandler A method that will handle the CellValueChanged event of the SpreadsheetControl.
Public delegate DataBindingWarningEventHandler A method that will handle the DataBindingWarning event of the SpreadsheetControl.
Public delegate DefinedNameDeletingEventHandler A method that will handle the DefinedNameDeleting event of the SpreadsheetControl.
Public delegate DefinedNameEditingEventHandler A method that will handle the DefinedNameEditing event of the SpreadsheetControl.
Public delegate DocumentPropertiesChangedEventHandler A method that will handle the DocumentPropertiesChanged event of the SpreadsheetControl.
Public delegate HyperlinkClickEventHandler A method that will handle the HyperlinkClick event of the SpreadsheetControl.
Public delegate UnhandledExceptionEventHandler Represents a method that will handle the UnhandledException event.

Expanded Enumerations

  Enumeration Description
Public enum CellEditorCommitMode Lists values used to specify when the CellValueChanged event should be raised after a cell value has been edited via the cell editor and committed.
Public enum CellEditorEnterValueMode Lists values that specify how to commit a cell value when closing the cell editor.
Public enum CellEditorMode Lists modes that specify the cell editor and cursor behavior.
Public enum CellValueChangedAction Lists actions which changed the cell value.
Public enum DataBindingWarningType Lists values used to specify the type of data binding warning messages.
Public enum DataTransferMode Lists values used to determine the operation a user performs on the selected cell range.
Public enum DocumentCapability Lists values used to specify the availability of a certain functionality in the SpreadsheetControl.
Public enum DragDropOperationType Lists values used to specify the drag-and-drop operation type.
Public enum FillOperationType Lists values used to specify how the target cell range is filled with data.
Public enum FormulaAutoCompleteSearchMode Lists values used to specify what items should appear in the Formula AutoComplete drop-down list.
Public enum FunctionNameCulture Lists values that are used to specify the culture settings for function names in a worksheet.
Public enum MoveActiveCellModeOnEnterPress Lists values that specify how to move an active cell on an ENTER key press.
Public enum RealTimeDataRefreshMode Lists how a data update is initiated.
Public enum ShowSelectionMode Lists values used to specify whether the cell selection should be highlighted when the SpreadsheetControl is not focused.
Public enum SpreadsheetCustomAssemblyBehavior Lists actions which can be performed in response to a request for loading a custom assembly for the Entity Framework Data Source.
Public enum SpreadsheetDecryptionError Lists possible errors which occur while attempting to load a password protected encrypted workbook.
Public enum SpreadsheetPivotTableFieldListStartPosition Lists values used to specify the starting position of the PivotTable Field List.
Public enum SpreadsheetPrintRenderMode Lists values used to specify the render mode of the printed document in the SpreadsheetControl.
Is this topic helpful?​​​​​​​