.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
A newer version of this page is available. Switch to the current version.

DevExpress.XtraSpreadsheet Namespace

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

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Classes

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

Delegates

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

Enums

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