DevExpress.XtraSpreadsheet Namespace

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

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Classes

Name	Description
AfterDropRangeEventArgs	Provides data for the SpreadsheetControl.AfterDropRange event.
AfterFillRangeEventArgs	Provides data for the SpreadsheetControl.AfterFillRange event.
AfterGroupProcessingEventArgs	Contains data for the SpreadsheetControl.AfterGroupProcessing event.
AfterOutlineButtonClickEventArgs	Contains data for the SpreadsheetControl.AfterOutlineButtonClick 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.
BeforeGroupProcessingEventArgs	Contains data for the SpreadsheetControl.BeforeGroupProcessing event.
BeforeOutlineButtonClickEventArgs	Contains data for the SpreadsheetControl.BeforeOutlineButtonClick 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.
GroupStateChangedEventArgs	Contains data for the SpreadsheetControl.GroupStateChanged event.
GroupStateChangingEventArgs	Contains data for the SpreadsheetControl.GroupStateChanging 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	Contains clipboard options for the Spreadsheet control.
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.
VisibleRangeChangedEventArgs	Provides data for the SpreadsheetControl.VisibleRangeChanged event.
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.
WorkbookLayoutOptions	Contains document layout options.
WorkbookLocalizationOptions	Contains localization options for a 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.

Structs

Name	Description
SpreadsheetGroupInfo	Contains information about a row or column group that is collapsed or expanded by a user.

Delegates

Name	Description
AfterDropRangeEventHandler	A method that handles the SpreadsheetControl’s AfterDropRange event.
AfterFillRangeEventHandler	A method that handles the SpreadsheetControl’s AfterFillRange event.
AfterGroupProcessingEventHandler	A method that handles the SpreadsheetControl.AfterGroupProcessing event.
AfterOutlineButtonClickEventHandler	A method that handles the SpreadsheetControl.AfterOutlineButtonClick 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.
BeforeGroupProcessingEventHandler	A method that handles the SpreadsheetControl.BeforeGroupProcessing event.
BeforeOutlineButtonClickEventHandler	A method that handles the SpreadsheetControl.BeforeOutlineButtonClick 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.
GroupStateChangedEventHandler	A method that handles the SpreadsheetControl.GroupStateChanged event.
GroupStateChangingEventHandler	A method that handles the SpreadsheetControl.GroupStateChanging event.
HyperlinkClickEventHandler	A method that will handle the SpreadsheetControl.HyperlinkClick event of the SpreadsheetControl.
UnhandledExceptionEventHandler	Represents a method that will handle the SpreadsheetControl.UnhandledException event.
VisibleRangeChangedEventHandler	A method that handles the SpreadsheetControl.VisibleRangeChanged 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.
ClipboardPasteFormat	Lists clipboard formats the Spreadsheet control supports.
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 specify 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.
SpreadsheetPrintContent	Lists values that specify spreadsheet content to print.
SpreadsheetPrintRenderMode	Lists values used to specify the render mode for the printed document.