DevExpress.XtraSpreadsheet Namespace

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

Assembly: DevExpress.XtraSpreadsheet.v20.1.dll

NuGet Package: DevExpress.Win.Spreadsheet

Classes

Name	Description
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
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.