DevExpress.Xpf.Spreadsheet Namespace

Contains classes required for WPF spreadsheet applications using the Spreadsheet suite. To use these classes in XAML code, add the xmlns:dxsps=”http://schemas.devexpress.com/winfx/2008/xaml/spreadsheet“ namespace reference.

Assembly: DevExpress.Xpf.Spreadsheet.v20.1.dll

NuGet Packages: DevExpress.WindowsDesktop.Wpf.Spreadsheet, DevExpress.Wpf.Spreadsheet

Classes

Name	Description
CellData	Contains information about a worksheet cell.
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.
SpreadsheetCapabilitiesOptions	Allows you to manage the capability of the document loaded in the SpreadsheetControl to support certain elements.
SpreadsheetCellOptions	Contains various options which can be specified for worksheet cells.
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.
SpreadsheetControl	Emulates the Microsoft® Excel® look and feel and allows you to create, load, edit, save and print spreadsheet documents.
SpreadsheetControlOptions	Contains various options which can be specified for the SpreadsheetControl.
SpreadsheetCopyOptions	A set of options used to control copy operations.
SpreadsheetCsvExportOptions	Contains options used for saving (exporting) a document in CSV format.
SpreadsheetCsvImportOptions	Contains options used for loading (importing) a document in CSV format.
SpreadsheetCustomCellEditEventArgs	Provides data for the SpreadsheetControl.CustomCellEdit event.
SpreadsheetDataValidationBehaviorOptions	Contains options used to specify whether users can manage data validation rules in a document loaded into the SpreadsheetControl.
SpreadsheetDocumentSource	Allows binding a document from the stream to the SpreadsheetControl using MVVM pattern.
SpreadsheetDrawingBehaviorOptions	Provides options to restrict an end-user’s ability to modify drawing objects embedded into the document.
SpreadsheetExportOptions	Contains options used for saving (exporting) documents.
SpreadsheetFormulaAutoCompleteOptions	Contains options affecting the Formula AutoComplete functionality.
SpreadsheetFormulaBarControl	A control that displays the cell address and the contents of the current cell. Use it to enter or edit formulas and cell data.
SpreadsheetGroupBehaviorOptions	Provides options to restrict an end-user’s ability to group data.
SpreadsheetImportOptions	Contains options used for loading (importing) documents .
SpreadsheetOpenXmlImportOptions	Contains options used for loading (importing) the document in Open XML format (aka MS Word 2007 default format, .docx).
SpreadsheetPivotTableFieldListOptions	Contains options that specify the size and starting position of the PivotTable Field List pane at runtime.
SpreadsheetPrintOptions	Contains print options for the Spreadsheet control.
SpreadsheetProtectionBehaviorOptions	Provides options to restrict an end-user’s capability to protect or unprotect a document in the SpreadsheetControl.
SpreadsheetRealTimeDataOptions	Contains options for real-time data (RTD) function calculation.
SpreadsheetRowBehaviorOptions	Provides options to restrict an end-user’s ability to manage rows in a worksheet of the workbook loaded into the SpreadsheetControl.
SpreadsheetSaveOptions	Provides access to options which define the file name and file format that are used when saving and loading the workbook.
SpreadsheetSelectionBehaviorOptions	Contains options affecting cell selection in the SpreadsheetControl.
SpreadsheetTxtExportOptions	Contains options used for saving (exporting) a document in text format.
SpreadsheetTxtImportOptions	Contains options used for loading (importing) a document in text format.
SpreadsheetViewOptions	Contains the SpreadsheetControl’s display settings.
SpreadsheetWorksheetBehaviorOptions	Provides options to restrict an end-user’s ability to manage a document within the SpreadsheetControl.
SpreadsheetXlsImportOptions	Contains options used for loading (importing) a document in XLS format (MS Excel 97-2003 binary file format).
SpreadsheetXlsmImportOptions	Contains options used for loading (importing) a document in OpenXML format with macro support (.xlsm).
WorksheetDisplayArea	An object that enables you to specify the visible worksheet area.

Delegates

Name	Description
SpreadsheetCustomCellEditEventHandler	Represents a method that will handle the SpreadsheetControl.CustomCellEdit event.

Enums

Name	Description
CommandBarStyle	Lists values used to specify the type of the SpreadhseetControl’s command bar.
NameBoxItemDisplayMode	Lists values used to specify what items should be displayed in the Name Box‘s drop-down list.
ShowCellToolTipMode	Lists modes which determine whether a tooltip is displayed for the cell.
SpreadsheetElementVisibility	Lists values used to specify the visibility of a certain element of the SpreadsheetControl.
SpreadsheetFormulaAutoCompleteSearchMode	Lists values used to specify what items should appear in the Formula AutoComplete drop-down list.
SpreadsheetMenuType	Lists menu types respective to visual elements for which a popup menu is invoked.
SpreadsheetPivotTableFieldListStartPosition	Lists values used to specify the starting position of the PivotTable Field List pane.