[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Expand]Spreadsheet Document API
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Collapse]API Reference
  [Expand]DevExpress.BarCodes
  [Expand]DevExpress.Compression
  [Expand]DevExpress.Docs.Text
  [Expand]DevExpress.Office
  [Expand]DevExpress.Office.Drawing
  [Expand]DevExpress.Office.Export
  [Expand]DevExpress.Office.Export.Html
  [Expand]DevExpress.Office.Import
  [Expand]DevExpress.Office.Localization
  [Expand]DevExpress.Office.Options
  [Expand]DevExpress.Office.Services
  [Expand]DevExpress.Office.Utils
  [Expand]DevExpress.Pdf
  [Expand]DevExpress.Pdf.Localization
  [Expand]DevExpress.Snap
  [Collapse]DevExpress.Spreadsheet
   [Expand]ActiveSheetChangedEventArgs Class
    ActiveSheetChangedEventHandler Delegate
   [Expand]ActiveSheetChangeEventArgsBase Class
   [Expand]ActiveSheetChangingEventArgs Class
    ActiveSheetChangingEventHandler Delegate
   [Expand]Alignment Interface
   [Expand]AreasCollection Interface
   [Expand]ArrayFormula Interface
   [Expand]ArrayFormulaCollection Interface
    ArrowheadSize Enumeration
    ArrowheadType Enumeration
   [Expand]ArrowSettings Interface
   [Expand]AutoFilterBase Interface
   [Expand]AutoFilterColumn Interface
   [Expand]AutoFilterColumnCollection Interface
   [Expand]AverageConditionalFormatting Interface
    BeforeExportEventHandler Delegate
    BeforeImportEventHandler Delegate
   [Expand]BeforePrintSheetEventArgs Class
    BeforePrintSheetEventHandler Delegate
   [Expand]Border Interface
    BorderLineStyle Enumeration
   [Expand]Borders Interface
    BuiltInStyleId Enumeration
    BuiltInTableStyleId Enumeration
    CalculationEngineType Enumeration
    CalculationMode Enumeration
   [Expand]CalculationOptions Interface
   [Expand]Cell Interface
   [Expand]CellCollection Interface
   [Expand]CellKey Structure
   [Expand]CellValue Class
    CellValueType Enumeration
   [Expand]ChartSheet Interface
   [Expand]ChartSheetCollection Interface
   [Expand]ChartSheetPrintOptions Interface
    ChartSheetProtection Enumeration
   [Expand]ChartSheetView Interface
   [Expand]ClipboardDataObtainedEventArgs Class
    ClipboardDataObtainedEventHandler Delegate
   [Expand]ClipboardDataPastedEventArgs Class
    ClipboardDataPastedEventHandler Delegate
    ClipboardDataPastingEventHandler Delegate
   [Expand]ColorScale2ConditionalFormatting Interface
   [Expand]ColorScale3ConditionalFormatting Interface
   [Expand]Column Interface
   [Expand]ColumnCollection Interface
   [Expand]ColumnsChangedEventArgs Class
   [Expand]ColumnsChangingEventArgs Class
    ColumnsInsertedEventHandler Delegate
    ColumnsRemovedEventHandler Delegate
   [Expand]Comment Interface
   [Expand]CommentChangedEventArgs Class
    CommentChangedEventHandler Delegate
   [Expand]CommentCollection Interface
   [Expand]CommentInsertingEventArgs Class
    CommentInsertingEventHandler Delegate
   [Expand]CommentRemovingEventArgs Class
    CommentRemovingEventHandler Delegate
   [Expand]CommentRun Interface
   [Expand]CommentRunCollection Interface
    CommentsPrintMode Enumeration
   [Expand]ConditionalFormatting Interface
    ConditionalFormattingAverageCondition Enumeration
   [Expand]ConditionalFormattingCollection Interface
   [Expand]ConditionalFormattingCustomIcon Structure
    ConditionalFormattingDataBarAxisPosition Enumeration
    ConditionalFormattingDataBarDirection Enumeration
    ConditionalFormattingExpressionCondition Enumeration
   [Expand]ConditionalFormattingExtremumValue Interface
   [Expand]ConditionalFormattingIconSetInsideValue Interface
   [Expand]ConditionalFormattingIconSetValue Interface
   [Expand]ConditionalFormattingInsideValue Interface
    ConditionalFormattingRangeCondition Enumeration
    ConditionalFormattingRankCondition Enumeration
    ConditionalFormattingSpecialCondition Enumeration
    ConditionalFormattingTextCondition Enumeration
    ConditionalFormattingTimePeriod Enumeration
   [Expand]ConditionalFormattingValue Interface
    ConditionalFormattingValueOperator Enumeration
    ConditionalFormattingValueType Enumeration
   [Expand]ConnectorFormat Interface
    ConnectorType Enumeration
   [Expand]CopiedRangePastedEventArgs Class
    CopiedRangePastedEventHandler Delegate
   [Expand]CopiedRangePastingEventArgs Class
    CopiedRangePastingEventHandler Delegate
   [Expand]CustomCellInplaceEditor Interface
   [Expand]CustomCellInplaceEditorCollection Interface
    CustomCellInplaceEditorType Enumeration
   [Expand]CustomFilter Interface
   [Expand]CustomXmlPartCollection Interface
   [Expand]DataBarConditionalFormatting Interface
    DataBindingDirection Enumeration
   [Expand]DataBindingErrorEventArgs Class
    DataBindingErrorEventHandler Delegate
    DataBindingErrorType Enumeration
   [Expand]DataImportOptions Class
    DataSourceEditingOptions Enumeration
   [Expand]DataSourceImportOptions Class
   [Expand]DataSourceOptionsBase Class
   [Expand]DataValidation Interface
   [Expand]DataValidationCollection Interface
    DataValidationErrorStyle Enumeration
    DataValidationImeMode Enumeration
    DataValidationOperator Enumeration
    DataValidationType Enumeration
   [Expand]DateGrouping Class
    DateTimeGroupingType Enumeration
   [Expand]DefinedName Interface
   [Expand]DefinedNameCollection Interface
   [Expand]DefinedNameConflictResolvingEventArgs Class
    DefinedNameConflictResolvingEventHandler Delegate
    DefinedNameScope Enumeration
    DeleteMode Enumeration
    DiagonalBorderType Enumeration
   [Expand]DocumentCustomProperties Interface
   [Expand]DocumentFormat Structure
   [Expand]DocumentOptions Class
   [Expand]DocumentProperties Interface
    DocumentSecurity Enumeration
   [Expand]DocumentSettings Interface
    DynamicFilterType Enumeration
   [Expand]EditRangePermission Class
   [Expand]EncryptedFileIntegrityCheckFailedEventArgs Class
    EncryptedFileIntegrityCheckFailedEventHandler Delegate
   [Expand]EncryptedFilePasswordRequestEventArgs Class
    EncryptedFilePasswordRequestEventHandler Delegate
   [Expand]EncryptionOptions Interface
    EncryptionType Enumeration
    ErrorsPrintMode Enumeration
    ErrorType Enumeration
   [Expand]ErrorValueInfo Interface
   [Expand]ExpressionConditionalFormatting Interface
   [Expand]ExternalDataSourceOptions Class
   [Expand]ExternalDefinedName Interface
   [Expand]ExternalWorkbook Interface
   [Expand]ExternalWorkbookCollection Interface
   [Expand]ExternalWorksheet Interface
   [Expand]Fill Interface
    FillType Enumeration
    FilterComparisonOperator Enumeration
   [Expand]FilterCriteria Interface
    FilterType Enumeration
   [Expand]FilterValue Class
   [Expand]FloatingObject Interface
    FontSchemeStyles Enumeration
   [Expand]Formatting Interface
   [Expand]FormulaExpressionConditionalFormatting Interface
   [Expand]GradientFill Interface
    GradientFillType Enumeration
   [Expand]GradientStop Interface
   [Expand]GradientStopCollection Interface
   [Expand]HeaderFooterCode Class
   [Expand]HeaderFooterPicture Interface
    HeaderFooterSection Enumeration
   [Expand]Hyperlink Interface
   [Expand]HyperlinkBase Interface
   [Expand]HyperlinkCollection Interface
   [Expand]IBindingRangeValueConverter Interface
   [Expand]ICellValueConverter Interface
   [Expand]IClipboardManager Interface
   [Expand]IconSetConditionalFormatting Interface
    IconSetType Enumeration
   [Expand]ICustomXmlPart Interface
   [Expand]IDataSourceColumnTypeDetector Interface
   [Expand]IDataValueConverter Interface
   [Expand]IgnoredError Interface
   [Expand]IgnoredErrorCollection Interface
    IgnoredErrorType Enumeration
    InsertCellsMode Enumeration
    InvalidFormatExceptionEventHandler Delegate
   [Expand]IRangeProvider Interface
   [Expand]ISpreadsheetComponent Interface
   [Expand]ISupportsFormatting Interface
   [Expand]IUsedNameSet Interface
   [Expand]IWorkbook Interface
   [Expand]IWorkbookMergeResult Interface
   [Expand]Margins Interface
    MergeCellsMode Enumeration
   [Expand]PageBreaksCollection Interface
    PageOrder Enumeration
    PageOrientation Enumeration
   [Expand]PanesFrozenEventArgs Class
    PanesFrozenEventHandler Delegate
   [Expand]PanesUnfrozenEventArgs Class
    PanesUnfrozenEventHandler Delegate
   [Expand]Parameter Interface
   [Expand]ParametersCollection Interface
    PasteSpecial Enumeration
    PatternType Enumeration
   [Expand]Picture Interface
   [Expand]PictureCollection Interface
    PivotAxisType Enumeration
    PivotBaseItemType Enumeration
   [Expand]PivotBehaviorOptions Interface
   [Expand]PivotCache Interface
   [Expand]PivotCacheCollection Interface
    PivotCacheType Enumeration
   [Expand]PivotCalculatedFieldCollection Interface
   [Expand]PivotCalculatedItemCollection Interface
    PivotDataConsolidationFunction Enumeration
   [Expand]PivotDataField Interface
   [Expand]PivotDataFieldCollection Interface
   [Expand]PivotField Interface
   [Expand]PivotFieldBehaviorOptions Interface
   [Expand]PivotFieldCollection Interface
    PivotFieldGroupByType Enumeration
   [Expand]PivotFieldGroupingInfo Interface
   [Expand]PivotFieldLayout Interface
   [Expand]PivotFieldReference Interface
   [Expand]PivotFieldReferenceBase Interface
   [Expand]PivotFieldReferenceCollection Interface
   [Expand]PivotFieldSortOptions Interface
    PivotFieldSortType Enumeration
   [Expand]PivotFilter Interface
   [Expand]PivotFilterCollection Interface
    PivotFilterTop10Type Enumeration
    PivotFilterType Enumeration
   [Expand]PivotGroupingValue Class
   [Expand]PivotItem Interface
   [Expand]PivotItemCollection Interface
   [Expand]PivotItemReference Class
   [Expand]PivotLayout Interface
   [Expand]PivotLocation Interface
   [Expand]PivotPageField Interface
   [Expand]PivotPageFieldCollection Interface
    PivotPageOrder Enumeration
    PivotReportLayout Enumeration
    PivotShowValuesAsType Enumeration
    PivotSubtotalFunctions Enumeration
    PivotSubtotalType Enumeration
   [Expand]PivotTable Interface
   [Expand]PivotTableCollection Interface
   [Expand]PivotViewOptions Interface
    Placement Enumeration
   [Expand]ProtectedRange Interface
   [Expand]ProtectedRangeCollection Interface
   [Expand]Protection Interface
   [Expand]Range Interface
   [Expand]RangeConditionalFormatting Interface
   [Expand]RangeCopiedEventArgs Class
    RangeCopiedEventHandler Delegate
   [Expand]RangeCopyingEventArgs Class
    RangeCopyingEventHandler Delegate
   [Expand]RangeDataSourceOptions Class
   [Expand]RangeExtensions Class
   [Expand]RankConditionalFormatting Interface
   [Expand]RealTimeData Interface
    ReferenceElement Enumeration
    ReferenceStyle Enumeration
   [Expand]RichTextRange Interface
   [Expand]RichTextRun Interface
   [Expand]RichTextRunFont Class
   [Expand]RichTextString Class
   [Expand]Row Interface
   [Expand]RowCollection Interface
    RowFormatMode Enumeration
   [Expand]RowsChangedEventArgs Class
   [Expand]RowsChangingEventArgs Class
   [Expand]RowsColumnsChangingEventArgsBase Class
    RowsInsertedEventHandler Delegate
    RowsRemovedEventHandler Delegate
    ScriptType Enumeration
   [Expand]ScrollPositionChangedEventArgs Class
    SearchBy Enumeration
    SearchIn Enumeration
   [Expand]SearchOptions Class
   [Expand]Shape Interface
   [Expand]ShapeChangedEventArgs Class
   [Expand]ShapeChangingEventArgs Class
   [Expand]ShapeCollection Interface
   [Expand]ShapeFormatBase Interface
   [Expand]ShapeGeometry Interface
    ShapeGeometryPreset Enumeration
   [Expand]ShapeHyperlink Interface
   [Expand]ShapesCopyingEventArgs Class
    ShapesCopyingEventHandler Delegate
   [Expand]ShapeText Interface
    ShapeTextAutoSizeType Enumeration
    ShapeTextHorizontalAnchorType Enumeration
    ShapeTextHorizontalOverflowType Enumeration
    ShapeTextOrientationType Enumeration
    ShapeTextParagraphAlignment Enumeration
   [Expand]ShapeTextParagraphFormat Interface
   [Expand]ShapeTextRange Interface
    ShapeTextReadingOrderType Enumeration
    ShapeTextVerticalAnchorType Enumeration
    ShapeTextVerticalOverflowType Enumeration
    ShapeTextWarpFormat Enumeration
    ShapeType Enumeration
   [Expand]Sheet Interface
   [Expand]SheetAutoFilter Interface
   [Expand]SheetCollection Interface
   [Expand]SheetInsertedEventArgs Class
    SheetInsertedEventHandler Delegate
   [Expand]SheetRemovedEventArgs Class
    SheetRemovedEventHandler Delegate
   [Expand]SheetRemovingEventArgs Class
    SheetRemovingEventHandler Delegate
   [Expand]SheetRenamedEventArgs Class
    SheetRenamedEventHandler Delegate
   [Expand]SheetRenamingEventArgs Class
    SheetRenamingEventHandler Delegate
    SheetType Enumeration
   [Expand]SortCondition Class
   [Expand]SortField Class
   [Expand]SortState Interface
   [Expand]Sparkline Interface
    SparklineAxisScaling Enumeration
   [Expand]SparklineCollection Interface
   [Expand]SparklineColor Interface
   [Expand]SparklineGroup Interface
   [Expand]SparklineGroupCollection Interface
    SparklineGroupType Enumeration
   [Expand]SparklineHorizontalAxis Interface
   [Expand]SparklinePoints Interface
   [Expand]SparklineVerticalAxis Interface
   [Expand]SpecialConditionalFormatting Interface
   [Expand]SpreadsheetBeforeExportEventArgs Class
   [Expand]SpreadsheetBeforeImportEventArgs Class
   [Expand]SpreadsheetCustomAssemblyLoadingEventArgs Class
    SpreadsheetCustomAssemblyLoadingEventHandler Delegate
   [Expand]SpreadsheetFont Interface
   [Expand]SpreadsheetFontProperties Interface
    SpreadsheetFontStyle Enumeration
   [Expand]SpreadsheetHistory Interface
    SpreadsheetHorizontalAlignment Enumeration
   [Expand]SpreadsheetImageSource Class
   [Expand]SpreadsheetInvalidFormatExceptionEventArgs Class
   [Expand]SpreadsheetMailMergeOptions Interface
   [Expand]SpreadsheetValidateCustomSqlQueryEventArgs Class
    SpreadsheetValidateCustomSqlQueryEventHandler Delegate
    SpreadsheetVerticalAlignment Enumeration
   [Expand]Style Interface
   [Expand]StyleCollection Interface
   [Expand]StyleFlags Interface
   [Expand]Table Interface
   [Expand]TableAutoFilter Interface
   [Expand]TableCollection Interface
   [Expand]TableColumn Interface
   [Expand]TableColumnCollection Interface
   [Expand]TableStyle Interface
   [Expand]TableStyleCollection Interface
   [Expand]TableStyleElement Interface
   [Expand]TableStyleElements Interface
    TableStyleElementType Enumeration
   [Expand]TextConditionalFormatting Interface
   [Expand]TimePeriodConditionalFormatting Interface
    Top10Type Enumeration
    TotalRowFunction Enumeration
    UnderlineType Enumeration
   [Expand]ValueObject Class
   [Expand]Workbook Class
   [Expand]WorkbookExtensions Class
   [Expand]WorkbookMergeOptions Class
   [Expand]Worksheet Interface
   [Expand]WorksheetCollection Interface
   [Expand]WorksheetDataBinding Interface
   [Expand]WorksheetDataBindingCollection Interface
   [Expand]WorksheetExtensions Class
   [Expand]WorksheetHeaderFooter Interface
   [Expand]WorksheetHeaderFooterOptions Interface
   [Expand]WorksheetOutlineOptions Interface
   [Expand]WorksheetPageNumbering Interface
    WorksheetPageNumberingStartType Enumeration
   [Expand]WorksheetPrintOptions Interface
   [Expand]WorksheetPrintTitleOptions Interface
    WorksheetProtectionPermissions Enumeration
   [Expand]WorksheetTableDataBinding Interface
   [Expand]WorksheetView Interface
    WorksheetViewType Enumeration
    WorksheetVisibilityType Enumeration
    WorksheetZoomMode Enumeration
  [Expand]DevExpress.Spreadsheet.Charts
  [Expand]DevExpress.Spreadsheet.Drawings
  [Expand]DevExpress.Spreadsheet.Export
  [Expand]DevExpress.Spreadsheet.Formulas
  [Expand]DevExpress.Spreadsheet.Functions
  [Expand]DevExpress.UnitConversion
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.API.Layout
  [Expand]DevExpress.XtraRichEdit.API.Native
  [Expand]DevExpress.XtraRichEdit.API.Native.Implementation
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Export.Html
  [Expand]DevExpress.XtraRichEdit.Export.Rtf
  [Expand]DevExpress.XtraRichEdit.Forms
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Services
  [Expand]DevExpress.XtraRichEdit.Utils
  [Expand]DevExpress.XtraSpreadsheet
  [Expand]DevExpress.XtraSpreadsheet.Export
  [Expand]DevExpress.XtraSpreadsheet.Export.Html
  [Expand]DevExpress.XtraSpreadsheet.Import
  [Expand]DevExpress.XtraSpreadsheet.Localization
  [Expand]DevExpress.XtraSpreadsheet.Services
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

DevExpress.Spreadsheet Namespace

Contains classes and interfaces that implement basic spreadsheet functionality.

Expanded Classes

  Class Description
Public class ActiveSheetChangedEventArgs Provides data for the SpreadsheetControl.ActiveSheetChanged event.
Public class ActiveSheetChangeEventArgsBase Base class for classes that provides data for the ActiveSheetChanging and ActiveSheetChanged events of the SpreadsheetControl.
Public class ActiveSheetChangingEventArgs Provides data for the SpreadsheetControl.ActiveSheetChanging event.
Public class BeforePrintSheetEventArgs Provides data for the SpreadsheetControl.BeforePrintSheet event.
Public class CellValue A data value contained in a cell.
Public class ClipboardDataObtainedEventArgs Provides data for the SpreadsheetControl.ClipboardDataObtained event.
Public class ClipboardDataPastedEventArgs Provides data for the SpreadsheetControl.ClipboardDataPasted event.
Public class ColumnsChangedEventArgs Provides data for the SpreadsheetControl.ColumnsInserted and the SpreadsheetControl.ColumnsRemoved events.
Public class ColumnsChangingEventArgs Provides data for the SpreadsheetControl.ColumnsInserting and SpreadsheetControl.ColumnsRemoving events.
Public class CommentChangedEventArgs Provides data for the SpreadsheetControl.CommentInserted and SpreadsheetControl.CommentRemoved events.
Public class CommentInsertingEventArgs Provides data for the SpreadsheetControl.CommentInserting event.
Public class CommentRemovingEventArgs Provides data for the SpreadsheetControl.CommentRemoving event.
Public class CopiedRangePastedEventArgs Provides data for the SpreadsheetControl.CopiedRangePasted event.
Public class CopiedRangePastingEventArgs Provides data for the SpreadsheetControl.CopiedRangePasting event.
Public class DataBindingErrorEventArgs Provides data for the Error event.
Public class DataImportOptions Contains properties which allow you to specify whether the imported data are treated as formulas, the cell reference style in use, the culture-specific decimal and list separators and a custom value converter.
Public class DataSourceImportOptions Allows specifying data source fields to import.
Public class DataSourceOptionsBase Serves as the base for the ExternalDataSourceOptions and RangeDataSourceOptions classes.
Public class DateGrouping A criterion for date values.
Public class DefinedNameConflictResolvingEventArgs Provides data for the DefinedNameConflictResolving event.
Public class DocumentOptions Provides access to workbook options.
Public class EditRangePermission Contains security information required for applying user-level security to a ProtectedRange.
Public class EncryptedFileIntegrityCheckFailedEventArgs Provides data for the EncryptedFileIntegrityCheckFailed event.
Public class EncryptedFilePasswordRequestEventArgs Provides data for the EncryptedFilePasswordRequest event.
Public class ExternalDataSourceOptions Contains options for data retrieval from an external data source when establishing a data binding.
Public class FilterValue A value or values used in a filter criterion.
Public class HeaderFooterCode Contains codes which can be used in a header or a footer and interpreted when printing a worksheet.
Public class PanesFrozenEventArgs Provides data for the SpreadsheetControl.PanesFrozen event.
Public class PanesUnfrozenEventArgs Provides data for the SpreadsheetControl.PanesUnfrozen event.
Public class PivotGroupingValue Contains data used to specify starting and ending values for the range grouping.
Public class PivotItemReference Represents a reference to a specific item in a pivot table.
Public class RangeCopiedEventArgs Provides data for the SpreadsheetControl.RangeCopied event.
Public class RangeCopyingEventArgs Provides data for the SpreadsheetControl.RangeCopying event.
Public class RangeDataSourceOptions Contains various options for a data source created from a cell range.
Public class RangeExtensions Defines extension methods for the Range interface.
Public class RichTextRunFont Contains font attributes for a rich text run.
Public class RichTextString Rich formatted text in a cell.
Public class RowsChangedEventArgs Provides data for the SpreadsheetControl.RowsInserted and the SpreadsheetControl.RowsRemoved events.
Public class RowsChangingEventArgs Provides data for the SpreadsheetControl.RowsInserting and SpreadsheetControl.RowsRemoving events.
Public class RowsColumnsChangingEventArgsBase Serves as the base for classes which provide data for the events which occur on inserting or removing rows and columns via the DevExpress.XtraSpreadsheet.SpreadsheetControl's UI.
Public class ScrollPositionChangedEventArgs Provides data for the SpreadsheetControl.ScrollPositionChanged event.
Public class SearchOptions Contains options affecting search in a document.
Public class ShapeChangedEventArgs Provides data for the SpreadsheetControl.ShapeInserted and SpreadsheetControl.ShapeRemoved events.
Public class ShapeChangingEventArgs Provides data for the SpreadsheetControl.ShapeRemoving event.
Public class ShapesCopyingEventArgs Provides data for the SpreadsheetControl.ShapesCopying event.
Public class SheetInsertedEventArgs Provides data for the SpreadsheetControl.SheetInserted event.
Public class SheetRemovedEventArgs Provides data for the SpreadsheetControl.SheetRemoved event.
Public class SheetRemovingEventArgs Provides data for the SpreadsheetControl.SheetRemoving event.
Public class SheetRenamedEventArgs Provides data for the SpreadsheetControl.SheetRenamed event.
Public class SheetRenamingEventArgs Provides data for the SpreadsheetControl.SheetRenaming event.
Public class SortCondition Combines the column index and the specification of the direction in which column values should be sorted.
Public class SortField Specifies the field by which to sort, and the comparer used for sorting.
Public class SpreadsheetBeforeExportEventArgs Provides data for the BeforeExport event.
Public class SpreadsheetBeforeImportEventArgs Provides data for the BeforeImport event.
Public class SpreadsheetCustomAssemblyLoadingEventArgs Provides data for the SpreadsheetControl.CustomAssemblyLoading event.
Public class SpreadsheetImageSource An object that provides an image for the spreadsheet.
Public class SpreadsheetInvalidFormatExceptionEventArgs Provides data for the InvalidFormatException event.
Public class SpreadsheetValidateCustomSqlQueryEventArgs Provides data for the SpreadsheetControl.ValidateCustomSqlQuery event.
Public class ValueObject An object that can be used to specify a value associated with a custom cell in-place editor or to create a criterion for Data Validation.
Public class Workbook A non-visual component providing complete spreadsheet functionality.
Public class WorkbookExtensions Defines extension methods for objects exposing the IWorkbook interface.
Public class WorkbookMergeOptions Provides options used to specify how to merge multiple workbooks into a single document.
Public class WorksheetExtensions Defines extension methods for the DevExpress.Spreadsheet.Worksheet class.

Expanded Interfaces

  Interface Description
Public interface Alignment Provides access to the cell content alignment settings.
Public interface AreasCollection A collection of worksheet Range objects from which a union range is composed.
Public interface ArrayFormula Contains an array formula and the range to which the formula is applied.
Public interface ArrayFormulaCollection A collection of ArrayFormula objects.
Public interface ArrowSettings Contains arrowhead settings for a connector.
Public interface AutoFilterBase Base interface for objects which implement filtering functionality in a worksheet and tables.
Public interface AutoFilterColumn Provides filtering functionality for a column.
Public interface AutoFilterColumnCollection A collection of AutoFilterColumn objects.
Public interface AverageConditionalFormatting Represents the "above or below average" conditional formatting rule.
Public interface Border Provides access to the line characteristics of a cell border.
Public interface Borders Provides access to cell borders.
Public interface CalculationOptions Contains options used for calculation of formulas contained in the worksheet cells.
Public interface Cell A single cell in a worksheet.
Public interface CellCollection A collection of all cells in a worksheet.
Public interface ChartSheet A separate sheet in a Workbook that contains only a chart.
Public interface ChartSheetCollection A collection of ChartSheet objects contained in a Workbook.
Public interface ChartSheetPrintOptions Contains options used for printing a chart sheet.
Public interface ChartSheetView Provides access to a set of display and print settings for a chart sheet.
Public interface ColorScale2ConditionalFormatting Represents a two-color scale conditional formatting rule.
Public interface ColorScale3ConditionalFormatting Represents a three-color scale conditional formatting rule.
Public interface Column A single column in a worksheet.
Public interface ColumnCollection A collection of all columns in a worksheet.
Public interface Comment A comment added to a cell.
Public interface CommentCollection A collection of Comments contained in a worksheet.
Public interface CommentRun A comment text region with its own set of font characteristics.
Public interface CommentRunCollection A collection of comment text regions, each formatted with its own font.
Public interface ConditionalFormatting A conditional format applied to a range of cells.
Public interface ConditionalFormattingCollection A collection of all conditional formatting rules on a worksheet.
Public interface ConditionalFormattingExtremumValue Represents a minimum or maximum threshold for a conditional formatting rule.
Public interface ConditionalFormattingIconSetInsideValue Represents a threshold value for an icon set conditional formatting rule.
Public interface ConditionalFormattingIconSetValue Represents a threshold value for an icon set conditional formatting rule.
Public interface ConditionalFormattingInsideValue Represents a threshold value for a conditional formatting rule.
Public interface ConditionalFormattingValue Represents a minimum or maximum threshold for a conditional formatting rule.
Public interface ConnectorFormat Contains connector settings.
Public interface CustomCellInplaceEditor Represents a custom cell in-place editor assigned to a cell or cell range in a worksheet.
Public interface CustomCellInplaceEditorCollection Represents a collection of the custom cell in-place editors assigned to worksheet cells.
Public interface CustomFilter Contains the settings of a custom filter.
Public interface CustomXmlPartCollection A collection of arbitrary XML data (custom XML parts) embedded in the workbook.
Public interface DataBarConditionalFormatting Represents a data bar conditional formatting rule.
Public interface DataValidation Provides access to a data validation rule defined for a worksheet range.
Public interface DataValidationCollection A collection of DataValidation objects.
Public interface DefinedName A defined name that refers to a cell, range of cells, formula or constant value.
Public interface DefinedNameCollection A collection of Defined Names stored in a worksheet or Workbook.
Public interface DocumentCustomProperties Contains custom document properties associated with a workbook.
Public interface DocumentProperties Contains basic document properties associated with a workbook.
Public interface DocumentSettings Contains workbook options related to formula calculation.
Public interface EncryptionOptions Contains the workbook encryption options.
Public interface ErrorValueInfo Contains information about an error that occurred in a cell.
Public interface ExpressionConditionalFormatting Represents a conditional formatting rule that uses a relational operator to determine which cells to format.
Public interface ExternalDefinedName A defined name that is contained in the external workbook or in the external worksheet.
Public interface ExternalWorkbook An external workbook.
Public interface ExternalWorkbookCollection A collection of external workbooks.
Public interface ExternalWorksheet A worksheet contained in an external workbook.
Public interface Fill Contains the cell background attributes.
Public interface FilterCriteria Provides information on multiple values and groups of dates by which to filter.
Public interface FloatingObject A base interface for floating objects in a worksheet (pictures, charts and comments).
Public interface Formatting Provides access to cell format characteristics.
Public interface FormulaExpressionConditionalFormatting Represents a conditional formatting rule that uses a formula as a formatting criteria.
Public interface GradientFill Contains characteristics required to create a gradient fill.
Public interface GradientStop A color stop that constitutes a gradient fill.
Public interface GradientStopCollection A collection of color stops which constitutes a linear gradient.
Public interface HeaderFooterPicture Represents a picture embedded to a worksheet header or footer.
Public interface Hyperlink A hyperlink contained in a cell or cell range.
Public interface HyperlinkBase Serves as the base for the Hyperlink and ShapeHyperlink interfaces that define hyperlinks for cells and shapes.
Public interface HyperlinkCollection A collection of hyperlinks contained in worksheet cells.
Public interface IBindingRangeValueConverter An interface that allows you to convert cell values to custom objects and back.
Public interface ICellValueConverter A converter that converts custom objects to cell values and vice versa.
Public interface IClipboardManager Contains methods for working with the system Clipboard.
Public interface IconSetConditionalFormatting Represents an icon set conditional formatting rule.
Public interface ICustomXmlPart Defines the custom XML part embedded in a workbook.
Public interface IDataSourceColumnTypeDetector Provides the capability to identify the name and type of each column in a data source created from a cell range.
Public interface IDataValueConverter An interface that allows you to modify data being imported before insertion in a worksheet.
Public interface IgnoredError Specifies a worksheet range and a type of the formula error which will be ignored in that range.
Public interface IgnoredErrorCollection A collection of IgnoredError objects.
Public interface IRangeProvider Provides properties and methods to get cell ranges.
Public interface ISpreadsheetComponent Exposes the basic functionality to manage workbooks.
Public interface ISupportsFormatting Contains format characteristics that are applied to cells when the condition of the conditional formatting rule is true.
Public interface IUsedNameSet A set of table and defined names existing in the destination document into which a formula or worksheet containing a conflict name is pasted.
Public interface IWorkbook Exposes the specific functionality of a workbook.
Public interface IWorkbookMergeResult Contains a result of merging multiple workbooks.
Public interface Margins Provides access to page margins used when a worksheet is printed.
Public interface PageBreaksCollection A collection of page breaks in a worksheet.
Public interface Parameter A single query parameter.
Public interface ParametersCollection A collection of parameters for queries used in Mail Merge.
Public interface Picture An image embedded in a worksheet.
Public interface PictureCollection A collection of Picture objects.
Public interface PivotBehaviorOptions Contains options that allow you to restrict specific operations in the PivotTable report.
Public interface PivotCache Represents the data cache for a PivotTable report.
Public interface PivotCacheCollection Represents the collection of data caches from the PivotTable reports in a workbook.
Public interface PivotCalculatedFieldCollection A collection of calculated fields in a PivotTable report.
Public interface PivotCalculatedItemCollection Represents a collection of calculated items in a PivotTable field.
Public interface PivotDataField Represents a reference to a PivotField object that is currently shown as a data field.
Public interface PivotDataFieldCollection Represents a collection of fields located in the data area of a PivotTable report.
Public interface PivotField Represents a field in a PivotTable report.
Public interface PivotFieldBehaviorOptions Contains options that allow you to restrict an end-user's ability to move or remove a PivotTable field.
Public interface PivotFieldCollection Represents the collection of all fields in a PivotTable report.
Public interface PivotFieldGroupingInfo Provides access to range grouping characteristics.
Public interface PivotFieldLayout Contains layout settings for a PivotTable field.
Public interface PivotFieldReference Represents a reference to a PivotField object that is currently shown as a row or column field.
Public interface PivotFieldReferenceBase Represents a base interface for the PivotFieldReference, PivotPageField and PivotDataField interfaces.
Public interface PivotFieldReferenceCollection Represents the collection of row or column fields in the PivotTable report.
Public interface PivotFieldSortOptions Contains sort options for a PivotTable field.
Public interface PivotFilter Represents a filter applied to a PivotTable field.
Public interface PivotFilterCollection A collection of filters applied to the PivotTable fields.
Public interface PivotItem Represents an item in a PivotTable field.
Public interface PivotItemCollection Represents a collection of PivotItem objects in a PivotTable field.
Public interface PivotLayout Contains various options used to adjust the layout of the PivotTable report.
Public interface PivotLocation Contains information about the location of a pivot table and its areas.
Public interface PivotPageField Represents a reference to a PivotField object that is currently shown as a page field.
Public interface PivotPageFieldCollection Represents a collection of fields located in the report filter area of a pivot table.
Public interface PivotTable Represents a PivotTable report on a worksheet.
Public interface PivotTableCollection A collection of all PivotTable objects in the worksheet.
Public interface PivotViewOptions Contains display settings for a pivot table.
Public interface ProtectedRange An association of a worksheet range and credentials required to unlock it for editing.
Public interface ProtectedRangeCollection A collection of items which associate worksheet ranges and security information required to unlock them for editing.
Public interface Protection Contains various options in effect when the worksheet is protected.
Public interface Range Defines a range of cells and serves as the base for the Cell, CellCollection, Column and Row interfaces.
Public interface RangeConditionalFormatting Represents a conditional formatting rule that formats cells which are between or not between two values.
Public interface RankConditionalFormatting Represents a "top/bottom N" conditional formatting rule.
Public interface RealTimeData Defines a real-time data object for use with the Real Time Data (RTD) function.
Public interface RichTextRange A range of characters within a cell's rich text.
Public interface RichTextRun A region of the cell text with its own set of font characteristics.
Public interface Row A single row in a worksheet.
Public interface RowCollection A collection of all rows in a worksheet.
Public interface Shape A common class for drawing objects in a worksheet.
Public interface ShapeCollection A collection of drawing objects (shapes, pictures, and charts).
Public interface ShapeFormatBase Contains properties used to format drawing objects (shapes, pictures, and charts).
Public interface ShapeGeometry Contains the shape geometry information.
Public interface ShapeHyperlink A hyperlink associated with a drawing object.
Public interface ShapeText Provides access to a shape's text format settings.
Public interface ShapeTextParagraphFormat Contains paragraph settings for a shape text range.
Public interface ShapeTextRange Represents a text range within a shape.
Public interface Sheet An individual sheet in a workbook and a base interface for Worksheet and ChartSheet.
Public interface SheetAutoFilter An object implementing the filtering functionality for the specified worksheet.
Public interface SheetCollection A collection of all sheets (worksheets and chart sheets) contained in a workbook.
Public interface SortState Contains sort conditions and allows you to perform sorting.
Public interface Sparkline Represents a single sparkline in the sparkline group.
Public interface SparklineCollection A collection that stores the Sparkline objects for the specified sparkline group.
Public interface SparklineColor Contains display options for the horizontal axis and data markers of a sparkline group.
Public interface SparklineGroup Represents a sparkline group on a worksheet.
Public interface SparklineGroupCollection A collection of the SparklineGroup objects in a worksheet.
Public interface SparklineHorizontalAxis Contains settings for the horizontal axis of a sparkline group.
Public interface SparklinePoints Contains marker options for data points on the sparklines in a sparkline group.
Public interface SparklineVerticalAxis Contains scaling options for the vertical axis of a sparkline group.
Public interface SpecialConditionalFormatting Represents a conditional formatting rule that formats cells with specific values.
Public interface SpreadsheetFont Contains the cell font attributes.
Public interface SpreadsheetFontProperties Contains font attributes for a range of characters within the cell text.
Public interface SpreadsheetHistory A history of operations performed in a workbook.
Public interface SpreadsheetMailMergeOptions Contains the mail merge options.
Public interface Style A named cell style.
Public interface StyleCollection A collection of cell styles in the workbook.
Public interface StyleFlags A style flag that controls formatting options to be applied.
Public interface Table A table in a worksheet.
Public interface TableAutoFilter An object implementing the filtering functionality for the specified table.
Public interface TableCollection A collection of tables contained in a worksheet.
Public interface TableColumn A single column in a table.
Public interface TableColumnCollection A collection of columns in a table.
Public interface TableStyle A named table or pivot table style.
Public interface TableStyleCollection A collection of table and pivot table styles contained in the workbook.
Public interface TableStyleElement A table style element.
Public interface TableStyleElements A collection of table style elements.
Public interface TextConditionalFormatting Represents a conditional formatting rule that formats cells that contain or do not contain the given text.
Public interface TimePeriodConditionalFormatting Represents a "date occurring..." conditional formatting rule.
Public interface Worksheet A worksheet in a Workbook.
Public interface WorksheetCollection A collection of Worksheets contained in a Workbook.
Public interface WorksheetDataBinding Contains information about a cell range bound to an external data source or used to create a data source.
Public interface WorksheetDataBindingCollection A collection of data bindings specified in a worksheet.
Public interface WorksheetHeaderFooter A header or footer of the worksheet.
Public interface WorksheetHeaderFooterOptions Provides access to the document's header and footer and contains options for displaying and printing them.
Public interface WorksheetOutlineOptions Contains options used to specify the summary rows and columns location.
Public interface WorksheetPageNumbering Contains options that affect page numbering when printing worksheets in a workbook.
Public interface WorksheetPrintOptions Contains options used for printing a worksheet.
Public interface WorksheetPrintTitleOptions Represents the object that specifies rows and columns to be repeated on every printed page.
Public interface WorksheetTableDataBinding Contains information about a Table bound to an external data source or used to create a data source.
Public interface WorksheetView Provides access to a set of display and print settings for a worksheet.

Expanded Structures

  Structure Description
Public structure CellKey Provides a unique identifier of a cell within a workbook.
Public structure ConditionalFormattingCustomIcon Provides access to the particular icon in the icon set.
Public structure DocumentFormat A document format.

Expanded Delegates

  Delegate Description
Public delegate ActiveSheetChangedEventHandler A method that will handle the SpreadsheetControl.ActiveSheetChanged event.
Public delegate ActiveSheetChangingEventHandler A method that will handle the SpreadsheetControl.ActiveSheetChanging event.
Public delegate BeforeExportEventHandler A method that will handle the BeforeExport event.
Public delegate BeforeImportEventHandler A method that will handle the BeforeImport event.
Public delegate BeforePrintSheetEventHandler A method that will handle the BeforePrintSheet event of the SpreadsheetControl.
Public delegate ClipboardDataObtainedEventHandler A method that will handle the ClipboardDataObtained event.
Public delegate ClipboardDataPastedEventHandler A method that will handle the SpreadsheetControl.ClipboardDataPasted event of the SpreadsheetControl.
Public delegate ClipboardDataPastingEventHandler A method that will handle the ClipboardDataPasting event.
Public delegate ColumnsInsertedEventHandler A method that will handle the SpreadsheetControl.ColumnsInserted event.
Public delegate ColumnsRemovedEventHandler A method that will handle the SpreadsheetControl.ColumnsRemoved event.
Public delegate CommentChangedEventHandler A method that will handle the SpreadsheetControl.CommentInserted, SpreadsheetControl.CommentInserted, SpreadsheetControl.CommentRemoved and SpreadsheetControl.CommentRemoved events.
Public delegate CommentInsertingEventHandler A method that will handle the SpreadsheetControl.CommentInserting and SpreadsheetControl.CommentInserting events.
Public delegate CommentRemovingEventHandler A method that will handle the SpreadsheetControl.CommentRemoving and SpreadsheetControl.CommentRemoving events.
Public delegate CopiedRangePastedEventHandler A method that will handle the CopiedRangePasted event.
Public delegate CopiedRangePastingEventHandler A method that will handle the CopiedRangePasting event.
Public delegate DataBindingErrorEventHandler A method that will handle the Error event.
Public delegate DefinedNameConflictResolvingEventHandler A method that will handle the DefinedNameConflictResolving event of the SpreadsheetControl.
Public delegate EncryptedFileIntegrityCheckFailedEventHandler A method that will handle the EncryptedFileIntegrityCheckFailed event of the SpreadsheetControl.
Public delegate EncryptedFilePasswordRequestEventHandler A method that will handle the EncryptedFilePasswordRequest event of the SpreadsheetControl.
Public delegate InvalidFormatExceptionEventHandler A method that will handle the InvalidFormatException event of the SpreadsheetControl.
Public delegate PanesFrozenEventHandler A method that will handle the SpreadsheetControl.PanesFrozen event.
Public delegate PanesUnfrozenEventHandler A method that will handle the SpreadsheetControl.PanesUnfrozen event.
Public delegate RangeCopiedEventHandler A method that will handle the RangeCopied event.
Public delegate RangeCopyingEventHandler A method that will handle the RangeCopying event.
Public delegate RowsInsertedEventHandler A method that will handle the RowsInserted event of the SpreadsheetControl.
Public delegate RowsRemovedEventHandler A method that will handle the RowsRemoved event of the SpreadsheetControl.
Public delegate ShapesCopyingEventHandler A method that will handle the ShapesCopying event.
Public delegate SheetInsertedEventHandler A method that will handle the SheetInserted event of the SpreadsheetControl.
Public delegate SheetRemovedEventHandler A method that will handle the SheetRemoved event of the SpreadsheetControl.
Public delegate SheetRemovingEventHandler A method that will handle the SheetRemoving event of the SpreadsheetControl.
Public delegate SheetRenamedEventHandler A method that will handle the SheetRenamed event of the SpreadsheetControl.
Public delegate SheetRenamingEventHandler A method that will handle the SheetRenaming event of the SpreadsheetControl.
Public delegate SpreadsheetCustomAssemblyLoadingEventHandler A method that will handle the SpreadsheetControl.CustomAssemblyLoading event of the SpreadsheetControl.
Public delegate SpreadsheetValidateCustomSqlQueryEventHandler A method that will handle the SpreadsheetControl.ValidateCustomSqlQuery event.

Expanded Enumerations

  Enumeration Description
Public enum ArrowheadSize Lists values used to specify an arrowhead's width and length.
Public enum ArrowheadType Lists values used to specify the type of a connector's arrowhead.
Public enum BorderLineStyle Lists line styles used for cell borders.
Public enum BuiltInStyleId Lists built-in cell styles.
Public enum BuiltInTableStyleId Lists built-in styles similar to Excel's built-in table styles.
Public enum CalculationEngineType Lists types of computational models used for spreadsheet calculations.
Public enum CalculationMode Lists modes that specify when the Spreadsheet should calculate formulas in the workbook.
Public enum CellValueType Lists the data types of cell values.
Public enum ChartSheetProtection Lists values used to specify chart sheet elements to which protection is applied.
Public enum CommentsPrintMode Lists the values to specify how cell comments are printed.
Public enum ConditionalFormattingAverageCondition Lists values that specify the type of the conditional format operator in an "above or below average" conditional formatting rule.
Public enum ConditionalFormattingDataBarAxisPosition Lists values that specify the axis position between negative and positive bars when the data bar conditional format is applied.
Public enum ConditionalFormattingDataBarDirection Lists values that specify the direction of data bars when the data bar conditional format is applied.
Public enum ConditionalFormattingExpressionCondition Lists values that specify the type of the relational operator in a conditional formatting rule.
Public enum ConditionalFormattingRangeCondition Lists values that specify the type of the conditional format operator in a conditional formatting rule.
Public enum ConditionalFormattingRankCondition Lists values that specify the type of the conditional format operator in a "top/bottom N" conditional formatting rule.
Public enum ConditionalFormattingSpecialCondition Lists values that specify the type of the conditional format operator in a conditional formatting rule.
Public enum ConditionalFormattingTextCondition Lists values that specify the type of the conditional format operator in a conditional formatting rule.
Public enum ConditionalFormattingTimePeriod Lists applicable time periods in a "date occurring..." conditional formatting rule.
Public enum ConditionalFormattingValueOperator Lists values that specify the relational operator type for the icon set conditional format.
Public enum ConditionalFormattingValueType Lists values that specify the type of the threshold value to be used in conditional formatting rules.
Public enum ConnectorType Lists values used to specify a connector type.
Public enum CustomCellInplaceEditorType Lists types of the custom in-place editors that can be assigned to cells in a worksheet.
Public enum DataBindingDirection Indicates whose value is being updated during binding.
Public enum DataBindingErrorType Lists possible error causes relevant to cell range data binding.
Public enum DataSourceEditingOptions Lists the editing options which can be applied to the data source originated from cell range.
Public enum DataValidationErrorStyle Lists the styles of data validation error alert.
Public enum DataValidationImeMode Lists values that specify how the IME (input method editor) mode is controlled by data validation.
Public enum DataValidationOperator Lists comparison operators used in criteria for certain validation types.
Public enum DataValidationType Lists data validation types.
Public enum DateTimeGroupingType Lists grouping types used to specify filter criteria for DateTime values.
Public enum DefinedNameScope Lists values used to specify the defined name scope.
Public enum DeleteMode Specifies how to delete cells from a worksheet.
Public enum DiagonalBorderType Lists the types of cell diagonal borders.
Public enum DocumentSecurity Lists the security levels of the document.
Public enum DynamicFilterType Lists the types of dynamic filter, i.e. a filter whose results may depend on the data to which it is applied or the current date.
Public enum EncryptionType Lists the types of encryption available for the current workbook.
Public enum ErrorsPrintMode Lists the values to specify how cell errors are printed.
Public enum ErrorType Lists errors that can occur in cells.
Public enum FillType Lists fill types.
Public enum FilterComparisonOperator Lists comparison operators used in a custom filter.
Public enum FilterType Lists types of filters available for the AutoFilter functionality.
Public enum FontSchemeStyles Lists values used to specify the font scheme.
Public enum GradientFillType Lists the types of gradient fill.
Public enum HeaderFooterSection Lists document header and footer sections.
Public enum IconSetType Lists values that specify the icon set type for an icon set conditional format.
Public enum IgnoredErrorType Lists types of errors which occur in cell formulas and can be ignored using the IgnoredErrors property.
Public enum InsertCellsMode Specifies how to insert new cells into a worksheet.
Public enum MergeCellsMode Lists available modes to merge cells.
Public enum PageOrder Contains the values to specify the order in which worksheet pages are numbered and printed when the worksheet data does not fit onto one page.
Public enum PageOrientation Lists values used to specify the page orientation applied when a worksheet is being printed.
Public enum PasteSpecial Specifies the part of data copied from cells to paste into target cells.
Public enum PatternType Lists the types of patterns available for cell shading.
Public enum PivotAxisType Lists values used to specify areas in the PivotTable report to which a PivotField may belong.
Public enum PivotBaseItemType Lists types of base items that can be used by the "Show Values As" calculation options.
Public enum PivotCacheType Lists values that specify the cache type of the PivotTable report.
Public enum PivotDataConsolidationFunction Lists aggregation functions to apply to data fields in a PivotTable report.
Public enum PivotFieldGroupByType Lists values used to specify how items of a row or column field are combined into groups.
Public enum PivotFieldSortType Lists values that specify the sort order for a PivotTable field.
Public enum PivotFilterTop10Type Lists values used to specify what items should be included in the "Top 10" filtering results.
Public enum PivotFilterType Lists values that specify the type of filter to be applied to a PivotTable field.
Public enum PivotPageOrder Lists values used to specify the orientation of multiple page fields in the PivotTable report filter area.
Public enum PivotReportLayout Lists values used to specify the type of the PivotTable report layout.
Public enum PivotShowValuesAsType Lists options that specify how summary values are displayed within a data field.
Public enum PivotSubtotalFunctions Lists functions used to calculate subtotals for the PivotTable fields.
Public enum PivotSubtotalType Lists values that specify how subtotals are calculated for a PivotTable field.
Public enum Placement Lists the ways the object is attached to the cells below it.
Public enum ReferenceElement Contains values to specify the type of a cell reference to be obtained.
Public enum ReferenceStyle Specifies the cell reference style.
Public enum RowFormatMode Lists values used to specify formatting options for inserted rows.
Public enum ScriptType Contains the values used to make the text in a cell superscript or subscript.
Public enum SearchBy Lists values that specify the direction of the search.
Public enum SearchIn Lists values that specify what to examine in each cell while searching.
Public enum ShapeGeometryPreset Lists values used to specify the shape geometry type.
Public enum ShapeTextAutoSizeType Lists values used to specify the auto-size mode for shape text.
Public enum ShapeTextHorizontalAnchorType Lists values used to specify the shape text's horizontal alignment.
Public enum ShapeTextHorizontalOverflowType Lists values used to specify how to display text that overflows the shape horizontally.
Public enum ShapeTextOrientationType Lists values used to specify the type of a shape text's orientation.
Public enum ShapeTextParagraphAlignment Lists values used to specify the paragraph alignment for a shape text range.
Public enum ShapeTextReadingOrderType Lists values used to specify the reading order of a shape's text.
Public enum ShapeTextVerticalAnchorType Lists values used to specify the shape text's vertical alignment.
Public enum ShapeTextVerticalOverflowType Lists values used to specify how to display text that overflows the shape vertically.
Public enum ShapeTextWarpFormat Lists values used to specify the warp type for shape text.
Public enum ShapeType Lists types of graphical objects that can be placed within a worksheet.
Public enum SheetType Lists values used to specify the sheet type.
Public enum SparklineAxisScaling Lists values used to specify how to calculate the minimum and maximum values for the vertical axis of a sparkline group.
Public enum SparklineGroupType Lists values used to specify the types of sparkline groups.
Public enum SpreadsheetFontStyle Lists the cell font styles.
Public enum SpreadsheetHorizontalAlignment Lists the values used to specify horizontal alignment of data within a cell.
Public enum SpreadsheetVerticalAlignment Lists the values used to specify vertical alignment of data within a cell.
Public enum TableStyleElementType Lists table style elements that specify formatting for the corresponding elements of a table and pivot table.
Public enum Top10Type Lists criteria types used in the top ten filter.
Public enum TotalRowFunction Lists functions to calculate the totals of table columns.
Public enum UnderlineType Lists underline styles.
Public enum WorksheetPageNumberingStartType Lists possible options for the starting number used in pagination when printing worksheets in a workbook.
Public enum WorksheetProtectionPermissions Lists end-user actions allowed for the protected worksheet.
Public enum WorksheetViewType Lists view types that can be used to display worksheets.
Public enum WorksheetVisibilityType Contains the values that specify worksheet visibility.
Public enum WorksheetZoomMode Lists values used to specify a zoom mode for a worksheet.
Is this topic helpful?​​​​​​​