Skip to main content

DevExpress.XtraSpreadsheet Namespace

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

Assembly: DevExpress.XtraSpreadsheet.v24.1.dll

NuGet Package: DevExpress.Win.Spreadsheet

Classes

Name Description
CellEditorOpenedEventArgs Provides data for the SpreadsheetControl.CellEditorOpened event.
CustomDrawCellBackgroundEventArgs Provides data for the SpreadsheetControl.CustomDrawCellBackground event.
CustomDrawCellEventArgs Provides data for the SpreadsheetControl.CustomDrawCell event.
CustomDrawCellEventArgsBase Provides data for the SpreadsheetControl.CustomDrawCell event.
CustomDrawColumnHeaderBackgroundEventArgs Provides data for the SpreadsheetControl.CustomDrawColumnHeaderBackground event.
CustomDrawColumnHeaderEventArgs Provides data for the SpreadsheetControl.CustomDrawColumnHeader event.
CustomDrawCommentIndicatorEventArgs Provides data for the SpreadsheetControl.CustomDrawCommentIndicator event.
CustomDrawFrozenPaneBorderEventArgs Provides data for the SpreadsheetControl.CustomDrawFrozenPaneBorder event.
CustomDrawHeaderEventArgsBase Represents the base class for classes that provide data for the SpreadsheetControl.CustomDrawColumnHeaderBackground, SpreadsheetControl.CustomDrawColumnHeader, SpreadsheetControl.CustomDrawRowHeaderBackground and SpreadsheetControl.CustomDrawRowHeader events of the SpreadsheetControl.
CustomDrawObjectEventsArgs Represents the base class for all classes that provide data for the custom draw events.
CustomDrawRowHeaderBackgroundEventArgs Provides data for the SpreadsheetControl.CustomDrawRowHeaderBackground event.
CustomDrawRowHeaderEventArgs Provides data for the SpreadsheetControl.CustomDrawRowHeader event.
PopupMenuShowingEventArgs Provides data for the SpreadsheetControl.PopupMenuShowing event.
SpreadsheetControl Emulates the Microsoft® Excel® appearance and allows you to create, load, edit, save and print spreadsheet documents.
SpreadsheetControlOptions Contains various options you can specify for the Spreadsheet control.
SpreadsheetCustomCellEditEventArgs Provides data for the SpreadsheetControl.CustomCellEdit event.
SpreadsheetDataSourceWizardOptions Contains options which affect the behavior of the Data Source Wizard.
SpreadsheetFormulaBar Displays the active cell’s address and content and is used to view, enter and edit formulas and cell data in the SpreadsheetControl.
SpreadsheetFormulaBarControl Displays the content of the active cell and is used to view, enter and edit formulas and cell data in the SpreadsheetControl.
SpreadsheetHorizontalScrollbarOptions Contains options for the horizontal scrollbar of the SpreadsheetControl.
SpreadsheetNameBoxControl Displays cell references and defined names specified in a worksheet.
SpreadsheetScrollbarOptions Represents the base class for scrollbar options.
SpreadsheetTabSelectorOptions Contains options which can be specified for the Sheet Tab Selector of the SpreadsheetControl.
SpreadsheetVerticalScrollbarOptions Contains options for the vertical scrollbar of the SpreadsheetControl.
WorksheetDisplayArea An object that allows you to specify a worksheet’s visible area.

Delegates

Name Description
CellEditorOpenedEventHandler A method that handles the SpreadsheetControl.CellEditorOpened event.
CustomDrawCellBackgroundEventHandler A method that will handle the CustomDrawCellBackground event of the SpreadsheetControl.
CustomDrawCellEventHandler A method that will handle the CustomDrawCell event of the SpreadsheetControl.
CustomDrawColumnHeaderBackgroundEventHandler A method that will handle the CustomDrawCellColumnHeaderBackground event of the SpreadsheetControl.
CustomDrawColumnHeaderEventHandler A method that will handle the CustomDrawColumnHeader event of the SpreadsheetControl.
CustomDrawCommentIndicatorEventHandler A method that will handle the SpreadsheetControl.CustomDrawCommentIndicator event.
CustomDrawFrozenPaneBorderEventHandler A method that will handle the CustomDrawFrozenPaneBorder event of the SpreadsheetControl.
CustomDrawRowHeaderBackgroundEventHandler A method that will handle the CustomDrawRowHeaderBackground event of the SpreadsheetControl.
CustomDrawRowHeaderEventHandler A method that will handle the CustomDrawRowHeader event of the SpreadsheetControl.
PopupMenuShowingEventHandler A method that will handle the PopupMenuShowing event of the SpreadsheetControl.
SpreadsheetCustomCellEditEventHandler A method that will handle the CustomCellEdit event of the SpreadsheetControl.

Enums

Name Description
FrozenPaneBorderType Lists values used to specify the frozen pane type.
NameBoxItemDisplayMode Lists values used to specify what items should be displayed in the Name Box‘s drop-down list.
SpreadsheetElementVisibility Lists values used to specify the visibility of a certain element of the SpreadsheetControl.
SpreadsheetMenuType Lists values used to specify the type of the SpreadsheetControl’s context menu.
SpreadsheetScrollbarVisibility Lists values used to specify the visibility of a scrollbar in the SpreadsheetControl.
SpreadsheetStatusBarItems Lists items that can be displayed on the Spreadsheet status bar.
SpreadsheetToolbarType Lists ribbon tabs/toolbars that can be added to the SpreadsheetControl at runtime.