Skip to main content

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.v24.1.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Classes

Name Description
CellData Contains information about a worksheet cell.
CellEditorOpenedEventArgs Provides data for the SpreadsheetControl.CellEditorOpened event.
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.
SpreadsheetCompatibilityOptions Contains options used to ensure compatibility with previous Spreadsheet control versions.
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
CellEditorOpenedEventHandler A method that handles the SpreadsheetControl.CellEditorOpened event.
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.