Skip to main content

DevExpress.XtraSpreadsheet Namespace

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

Assembly: DevExpress.Spreadsheet.v24.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.
DefinedNameEditedEventArgs Contains DefinedNameEdited event data.
DefinedNameEditingEventArgs Provides data for the SpreadsheetControl.DefinedNameEditing event.
DefinedNameEventArgs Contains DefinedNameAdded and DefinedNameDeleted event data.
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.
DefinedNameAddedEventHandler A method that handles the DefinedNameAdded event of the SpreadsheetControl.
DefinedNameDeletedEventHandler A method that handles the DefinedNameDeleted event of the SpreadsheetControl.
DefinedNameDeletingEventHandler A method that will handle the DefinedNameDeleting event of the SpreadsheetControl.
DefinedNameEditedEventHandler A method that handles the DefinedNameEdited 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.