[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
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Expand]DevExpress ORM Tool
 [Expand]DevExpress Data Library
 [Expand]Miscellaneous
 [Collapse]API Reference
  [Expand]DevExpress.Data
  [Expand]DevExpress.Data.Browsing
  [Expand]DevExpress.Data.Browsing.Design
  [Expand]DevExpress.Data.Camera
  [Expand]DevExpress.Data.Controls
  [Expand]DevExpress.Data.Controls.ExpressionEditor
  [Expand]DevExpress.Data.Entity
  [Expand]DevExpress.Data.Filtering
  [Expand]DevExpress.Data.Filtering.Exceptions
  [Expand]DevExpress.Data.Filtering.Helpers
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Data.ODataLinq
  [Expand]DevExpress.Data.PivotGrid
  [Expand]DevExpress.Data.PLinq
  [Expand]DevExpress.Data.TreeList
  [Expand]DevExpress.Data.Utils
  [Expand]DevExpress.Data.Utils.ServiceModel
  [Expand]DevExpress.Data.WcfLinq
  [Expand]DevExpress.Data.WizardFramework
  [Expand]DevExpress.Data.XtraReports.DataProviders
  [Expand]DevExpress.Data.XtraReports.Labels
  [Expand]DevExpress.Data.XtraReports.ServiceModel
  [Expand]DevExpress.Data.XtraReports.ServiceModel.DataContracts
  [Expand]DevExpress.Data.XtraReports.Wizard
  [Expand]DevExpress.Data.XtraReports.Wizard.Presenters
  [Expand]DevExpress.Data.XtraReports.Wizard.Views
  [Expand]DevExpress.DataAccess
  [Expand]DevExpress.DataAccess.ConnectionParameters
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Expand]DevExpress.DataAccess.Sql
  [Expand]DevExpress.DataAccess.Sql.DataApi
  [Expand]DevExpress.DataAccess.UI
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DataAccess.Web
  [Expand]DevExpress.DataAccess.Wizard
  [Expand]DevExpress.DataAccess.Wizard.Model
  [Expand]DevExpress.DataAccess.Wizard.Presenters
  [Expand]DevExpress.DataAccess.Wizard.Services
  [Expand]DevExpress.DataAccess.Wizard.Views
  [Expand]DevExpress.Diagram.Core
  [Expand]DevExpress.Diagram.Core.Layout
  [Expand]DevExpress.Diagram.Core.Localization
  [Expand]DevExpress.Diagram.Core.Shapes
  [Expand]DevExpress.Diagram.Core.Themes
  [Expand]DevExpress.DocumentServices.ServiceModel
  [Expand]DevExpress.DocumentServices.ServiceModel.Client
  [Expand]DevExpress.DocumentServices.ServiceModel.DataContracts
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.Entity.Model
  [Expand]DevExpress.Entity.ProjectModel
  [Expand]DevExpress.Export
  [Expand]DevExpress.Export.Xl
  [Expand]DevExpress.Map
  [Expand]DevExpress.Mvvm
  [Expand]DevExpress.Mvvm.DataAnnotations
  [Expand]DevExpress.Mvvm.DataModel
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office
  [Expand]DevExpress.Office.Crypto
  [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.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.ReportServer.Printing
  [Expand]DevExpress.ReportServer.Printing.Services
  [Expand]DevExpress.ReportServer.ServiceModel.Client
  [Expand]DevExpress.ReportServer.ServiceModel.ConnectionProviders
  [Expand]DevExpress.ReportServer.ServiceModel.DataContracts
  [Expand]DevExpress.Schedule
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [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
   [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
    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]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
    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
   [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]Row Interface
   [Expand]RowCollection Interface
   [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]ShapeHyperlink Interface
   [Expand]ShapesCopyingEventArgs Class
    ShapesCopyingEventHandler Delegate
    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
    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]WorkbookMergeOptions Class
   [Collapse]Worksheet Interface
     Worksheet Members
    [Collapse]Worksheet Properties
      ActiveView Property
      ArrayFormulas Property
      AutoFilter Property
      Cells Property
      Charts Property
      CodeName Property
      Columns Property
      Comments Property
      Comparers Property
      ConditionalFormattings Property
      CustomCellInplaceEditors Property
      DataBindings Property
      DataValidations Property
      DefaultColumnWidth Property
      DefaultColumnWidthInCharacters Property
      DefaultColumnWidthInPixels Property
      DefaultRowHeight Property
     [Expand]DefinedNames Property
      HeaderFooterOptions Property
      HorizontalPageBreaks Property
      Hyperlinks Property
      IgnoredErrors Property
      Index Property
      IsProtected Property
     [Expand]Item Property
      Name Property
      OutlineOptions Property
      Pictures Property
      PivotTables Property
      PrintOptions Property
      ProtectedRanges Property
      Range Property
      Rows Property
      SelectedCell Property
      SelectedChart Property
      SelectedComment Property
      SelectedPicture Property
      SelectedShape Property
      Selection Property
      Shapes Property
      SparklineGroups Property
      SplitLeftPosition Property
      SplitTopPosition Property
      Tables Property
      Tag Property
      VerticalPageBreaks Property
      VisibilityType Property
      Visible Property
      Workbook Property
    [Expand]Worksheet Methods
   [Expand]WorksheetCollection Interface
   [Expand]WorksheetDataBinding Interface
   [Expand]WorksheetDataBindingCollection Interface
   [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
  [Expand]DevExpress.Spreadsheet.Charts
  [Expand]DevExpress.Spreadsheet.Drawings
  [Expand]DevExpress.Spreadsheet.Export
  [Expand]DevExpress.Spreadsheet.Formulas
  [Expand]DevExpress.Spreadsheet.Functions
  [Expand]DevExpress.TreeMap
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Commands
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Filtering.Internal
  [Expand]DevExpress.Utils.IoC
  [Expand]DevExpress.Utils.Localization
  [Expand]DevExpress.Utils.Serializing.Helpers
  [Expand]DevExpress.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Expand]DevExpress.Xpo.DB
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.Helpers
  [Expand]DevExpress.Xpo.Exceptions
  [Expand]DevExpress.Xpo.Helpers
  [Expand]DevExpress.Xpo.Metadata
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Printing
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraExport.Csv
  [Expand]DevExpress.XtraGauges.Base
  [Expand]DevExpress.XtraGauges.Core
  [Expand]DevExpress.XtraGauges.Core.Base
  [Expand]DevExpress.XtraGauges.Core.Drawing
  [Expand]DevExpress.XtraGauges.Core.Localization
  [Expand]DevExpress.XtraGauges.Core.Model
  [Expand]DevExpress.XtraGauges.Core.Primitive
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraPivotGrid
  [Expand]DevExpress.XtraPivotGrid.Customization
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPivotGrid.Localization
  [Expand]DevExpress.XtraPivotGrid.Selection
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.BarCode
  [Expand]DevExpress.XtraPrinting.Caching
  [Expand]DevExpress.XtraPrinting.DataNodes
  [Expand]DevExpress.XtraPrinting.Drawing
  [Expand]DevExpress.XtraPrinting.Export
  [Expand]DevExpress.XtraPrinting.Export.Web
  [Expand]DevExpress.XtraPrinting.Localization
  [Expand]DevExpress.XtraPrinting.Native
  [Expand]DevExpress.XtraPrinting.Shape
  [Expand]DevExpress.XtraPrinting.Shape.Native
  [Expand]DevExpress.XtraPrinting.WebClientUIControl.DataContracts
  [Expand]DevExpress.XtraPrinting.XamlExport
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports
  [Expand]DevExpress.XtraReports.Design
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [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.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Compatibility
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Exchange
  [Expand]DevExpress.XtraScheduler.iCalendar
  [Expand]DevExpress.XtraScheduler.iCalendar.Components
  [Expand]DevExpress.XtraScheduler.Localization
  [Expand]DevExpress.XtraScheduler.Native
  [Expand]DevExpress.XtraScheduler.Outlook
  [Expand]DevExpress.XtraScheduler.Outlook.Interop
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.Tools
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraScheduler.Xml
  [Expand]DevExpress.XtraSpellChecker
  [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]Tools and Utilities
 End-User Documentation

Worksheet.Selection Property

Gets or sets a cell range selected in the worksheet.

Namespace:DevExpress.Spreadsheet
Assembly:DevExpress.Spreadsheet.v18.1.Core.dll

Expanded Syntax

Property value

Type: Range
A Range object specifying the cell selection in the worksheet. If you assign a cell range located in a worksheet other than the current worksheet, an exception is raised.

Expanded Remarks

The Selection property specifies the range of cells selected in the worksheet (B3:F9, in the image below). The SelectedCell property specifies a single cell where data is inserted when an end-user types (E7, in the image below). In other words, this is the active cell. The Selection can be a single cell, a contiguous or noncontiguous (union) range of cells, while the SelectedCell is always a single cell inside the current selection. If you set SelectedCell to a range that contains more than one cell, only this range's top left cell is considered.

The following code sets the selection and active cell as shown in the image above.

If a cell you assign to SelectedCell belongs to the currently selected range, the selection will not be changed and the specified cell will become active within this selection. For example, executing the following code results in the selection and active cell shown in the image below.

If a cell you activate is outside the currently selected range, the selection will be changed - it will coincide with the specified active cell. See the example below.

Note

Another way to select the cell range in the worksheet is to use the range's RangeExtensions.Select extension method, defined by the RangeExtensions class. This extension method is accessible as a method of the Range object and called by using the instance method syntax.

You can also select multiple non-adjacent cells or cell ranges in the worksheet simultaneously. If there is more than one selected range in the worksheet (A2:C4, C6:C9, E3:F7, in the image below), the Selection property returns a complex (union) range that includes all the selected areas. You can access an individual range in the selection by its index in the Range.Areas collection.

You can also use the SetSelectedRanges and GetSelectedRanges methods to set or obtain a collection of selected ranges in the worksheet.

Note

The Selection, SelectedCell, ActiveCell, SetSelectedRanges and GetSelectedRanges members of the DevExpress.XtraSpreadsheet.SpreadsheetControl or DevExpress.Xpf.Spreadsheet.SpreadsheetControl object allow you to manage cell selection in the worksheet that is currently active in the control.

Expanded See Also

Is this topic helpful?​​​​​​​