The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

DevExpress.XtraSpreadsheet Namespace

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

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.

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 of the printed document in the SpreadsheetControl.