[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Expand]Controls and Libraries
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.Data
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Expand]DevExpress.Xpf.Core.FilteringUI
  [Expand]DevExpress.Xpf.Core.Native
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Expand]DevExpress.Xpf.DataAccess.DataSourceWizard
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Dialogs
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DataPager
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Native
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gantt
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Expand]DevExpress.Xpf.Grid
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Expand]DevExpress.Xpf.PivotGrid
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Common
  [Expand]DevExpress.Xpf.Scheduling.Editors
  [Expand]DevExpress.Xpf.Scheduling.iCalendar
  [Expand]DevExpress.Xpf.Scheduling.Reporting
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.Scheduling.VisualData
  [Expand]DevExpress.Xpf.SpellChecker
  [Collapse]DevExpress.Xpf.Spreadsheet
   [Expand]CellData Class
    CommandBarStyle Enumeration
    NameBoxItemDisplayMode Enumeration
    ShowCellToolTipMode Enumeration
   [Expand]SpreadsheetAxisLabelOverlappingOptions Class
   [Expand]SpreadsheetBehaviorOptions Class
   [Expand]SpreadsheetCapabilitiesOptions Class
   [Expand]SpreadsheetCellOptions Class
   [Expand]SpreadsheetClipboardOptions Class
   [Expand]SpreadsheetColumnBehaviorOptions Class
   [Expand]SpreadsheetCommentBehaviorOptions Class
   [Collapse]SpreadsheetControl Class
     SpreadsheetControl Members
     SpreadsheetControl Constructor
    [Collapse]SpreadsheetControl Properties
      AcceptsEscape Property
      AcceptsReturn Property
      AcceptsTab Property
      ActiveCell Property
      ActiveChartSheet Property
      ActiveSheet Property
      ActiveSheetIndex Property
      ActiveSheetName Property
      ActiveView Property
      ActiveViewZoom Property
      ActiveWorksheet Property
      BarManager Property
      CellTemplate Property
      CellTemplateSelector Property
      CellToolTip Property
      ChartLayoutGalleryGroups Property
      ChartStyleGalleryGroups Property
      ChartStylePopupGalleryGroups Property
      Clipboard Property
      CommandBarStyle Property
      CommandProvider Property
      Document Property
      DocumentSource Property
      DpiX Property
      DpiY Property
      FormulaBarExpanded Property
      FormulaBarNameBoxItemDisplayMode Property
      FormulaBarShowButtons Property
      FormulaBarShowEditor Property
      FormulaBarShowNameBox Property
      GridLinesColor Property
      HorizontalScrollBar Property
      HorizontalScrollbarVisibility Property
      IsCellEditorActive Property
      IsPrintingAvailable Property
      IsPrintPreviewAvailable Property
      IsUpdateLocked Property
      LayoutUnit Property
      LayoutViewBounds Property
      MenuCustomizations Property
      Modified Property
      Options Property
      PivotTableStyleGalleryGroups Property
      PivotTableStylePopupGalleryGroups Property
      ReadOnly Property
      Ribbon Property
      RibbonActions Property
      SelectedCell Property
      SelectedComment Property
      SelectedPicture Property
      SelectedShape Property
      Selection Property
      SheetCount Property
      ShowCellToolTipMode Property
      ShowFormulaBar Property
      ShowStatusBar Property
      ShowTabSelector Property
      Spreadsheet Attached Property
      StatusBarActions Property
      StatusBarShowAverage Property
      StatusBarShowCount Property
      StatusBarShowMax Property
      StatusBarShowMin Property
      StatusBarShowNumericalCount Property
      StatusBarShowPopupMenu Property
      StatusBarShowSum Property
      StatusBarShowZoom Property
      StatusBarShowZoomSlider Property
      TableStyleGalleryGroups Property
      TableStylePopupGalleryGroups Property
      Unit Property
      UseDefaultSvgImages Attached Property
      VerticalScrollBar Property
      VerticalScrollbarVisibility Property
      ViewBounds Property
      VisibleRange Property
      VisibleSheetNames Property
      VisibleUnfrozenRange Property
      WorksheetDisplayArea Property
    [Expand]SpreadsheetControl Events
    [Expand]SpreadsheetControl Methods
   [Expand]SpreadsheetControlOptions Class
   [Expand]SpreadsheetCopyOptions Class
   [Expand]SpreadsheetCsvExportOptions Class
   [Expand]SpreadsheetCsvImportOptions Class
   [Expand]SpreadsheetCustomCellEditEventArgs Class
    SpreadsheetCustomCellEditEventHandler Delegate
   [Expand]SpreadsheetDataValidationBehaviorOptions Class
   [Expand]SpreadsheetDocumentSource Class
   [Expand]SpreadsheetDrawingBehaviorOptions Class
    SpreadsheetElementVisibility Enumeration
   [Expand]SpreadsheetExportOptions Class
   [Expand]SpreadsheetFormulaAutoCompleteOptions Class
    SpreadsheetFormulaAutoCompleteSearchMode Enumeration
   [Expand]SpreadsheetFormulaBarControl Class
   [Expand]SpreadsheetGroupBehaviorOptions Class
   [Expand]SpreadsheetImportOptions Class
    SpreadsheetMenuType Enumeration
   [Expand]SpreadsheetOpenXmlImportOptions Class
   [Expand]SpreadsheetPivotTableFieldListOptions Class
    SpreadsheetPivotTableFieldListStartPosition Enumeration
   [Expand]SpreadsheetProtectionBehaviorOptions Class
   [Expand]SpreadsheetRealTimeDataOptions Class
   [Expand]SpreadsheetRowBehaviorOptions Class
   [Expand]SpreadsheetSaveOptions Class
   [Expand]SpreadsheetSelectionBehaviorOptions Class
   [Expand]SpreadsheetTxtExportOptions Class
   [Expand]SpreadsheetTxtImportOptions Class
   [Expand]SpreadsheetViewOptions Class
   [Expand]SpreadsheetWorksheetBehaviorOptions Class
   [Expand]SpreadsheetXlsImportOptions Class
   [Expand]SpreadsheetXlsmImportOptions Class
   [Expand]WorksheetDisplayArea Class
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Printing
[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]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)

SpreadsheetControl Properties

Emulates the Microsoft® Excel® look and feel and allows you to create, load, edit, save and print spreadsheet documents.

Expanded Public Properties

Show: Inherited
  Name Description
Public property AcceptsEscape Gets or sets a value indicating whether pressing the ESC key is processed by the SpreadsheetControl. This is a dependency property.
Public property AcceptsReturn Gets or sets a value indicating whether pressing the RETURN key is processed by the SpreadsheetControl. This is a dependency property.
Public property AcceptsTab Gets or sets a value indicating whether pressing the TAB key is processed by the SpreadsheetControl instead of moving the focus to the next control in the tab order. This is a dependency property.
Public property ActiveCell Gets an active cell in the active worksheet.
Public property ActiveChartSheet Gets the chart sheet that is currently displayed in the SpreadsheetControl.
Public property ActiveSheet Gets the sheet that is currently displayed in the SpreadsheetControl.
Public property ActiveSheetIndex Gets or sets the index of an active worksheet. This is a dependency property.
Public property ActiveSheetName Gets or sets the name of an active worksheet. This is a dependency property.
Public property ActiveView Provides access to a View object that contains layout information.
Public property ActiveViewZoom Gets or sets the zoom level for the sheet currently displayed in the SpreadsheetControl. This is a dependency property.
Public property ActiveWorksheet Gets the worksheet that is currently displayed in the SpreadsheetControl.
Public property ActualHeight Gets the rendered height of this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property ActualWidth Gets the rendered width of this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property AllowDrop Gets or sets a value indicating whether this element can be used as the target of a drag-and-drop operation. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property AreAnyTouchesCaptured (Inherited from System.Windows.UIElement)
Public property AreAnyTouchesCapturedWithin (Inherited from System.Windows.UIElement)
Public property AreAnyTouchesDirectlyOver (Inherited from System.Windows.UIElement)
Public property AreAnyTouchesOver (Inherited from System.Windows.UIElement)
Public property Background Gets or sets a brush that describes the background of a control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property BarManager Gets or sets the main component that provides Bars functionality. This is a dependency property.
Public property BindingGroup Gets or sets the System.Windows.Data.BindingGroup that is used for the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property BitmapEffect Obsolete. Gets or sets a bitmap effect that applies directly to the rendered content for this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property BitmapEffectInput Obsolete. Gets or sets an input source for the bitmap effect that applies directly to the rendered content for this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property BorderBrush Gets or sets a brush that describes the border background of a control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property BorderThickness Gets or sets the border thickness of a control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property CacheMode (Inherited from System.Windows.UIElement)
Public property CellTemplate Gets or sets the template used to visualize worksheet cells. This is a dependency property.
Public property CellTemplateSelector Gets or sets an object that selects a cell template based on custom logic. This is a dependency property.
Public property CellToolTip Gets or sets the cell tooltip. This is a dependency property.
Public property ChartLayoutGalleryGroups Gets or sets Chart Gallery Ribbon groups in the Ribbon UI. For internal use. This is a dependency property.
Public property ChartStyleGalleryGroups Gets or sets the Chart Styles gallery groups in the Ribbon UI. For internal use. This is a dependency property.
Public property ChartStylePopupGalleryGroups Gets or sets the Chart Styles dropdown gallery groups in the Ribbon UI. For internal use. This is a dependency property.
Public property Clip Gets or sets the geometry used to define the outline of the contents of an element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property Clipboard Provides access to the object used for working with the system clipboard.
Public property ClipToBounds Gets or sets a value indicating whether to clip the content of this element (or content coming from the child elements of this element) to fit into the size of the containing element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property CommandBarStyle Gets or sets the command bar for the SpreadsheetControl. This is a dependency property.
Public property CommandBindings Gets a collection of System.Windows.Input.CommandBinding objects associated with this element. A System.Windows.Input.CommandBinding enables command handling for this element, and declares the linkage between a command, its events, and the handlers attached by this element. (Inherited from System.Windows.UIElement)
Public property CommandProvider Gets or sets the SpreadsheetControl's command provider. This is a dependency property.
Public property ContextMenu Gets or sets the context menu element that should appear whenever the context menu is requested through user interface (UI) from within this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Cursor Gets or sets the cursor that displays when the mouse pointer is over this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property DataContext Gets or sets the data context for an element when it participates in data binding. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property DependencyObjectType Gets the System.Windows.DependencyObjectType that wraps the CLR type of this instance. (Inherited from System.Windows.DependencyObject)
Public property DesiredSize Gets the size that this element computed during the measure pass of the layout process. (Inherited from System.Windows.UIElement)
Public property Dispatcher Gets the System.Windows.Threading.Dispatcher this System.Windows.Threading.DispatcherObject is associated with. (Inherited from System.Windows.Threading.DispatcherObject)
Public property Document Provides access to a workbook loaded in the control.
Public property DocumentSource Gets or sets a document supplier for a SpreadsheetControl. This is a dependency property.
Public property DpiX Gets the current dpi value for the X-coordinate.
Public property DpiY Gets the current dpi value for the Y-coordinate.
Public property Effect Gets or sets the bitmap effect to apply to the System.Windows.UIElement. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property FlowDirection Gets or sets the direction that text and other user interface (UI) elements flow within any parent element that controls their layout. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Focusable Gets or sets a value that indicates whether the element can receive focus. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property FocusVisualStyle Gets or sets a property that enables customization of appearance, effects, or other style characteristics that will apply to this element when it captures keyboard focus. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property FontFamily Gets or sets the font family of the control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FontSize Gets or sets the font size. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FontStretch Gets or sets the degree to which a font is condensed or expanded on the screen. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FontStyle Gets or sets the font style. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FontWeight Gets or sets the weight or thickness of the specified font. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property ForceCursor Gets or sets a value that indicates whether this System.Windows.FrameworkElement should force the user interface (UI) to render the cursor as declared by the System.Windows.FrameworkElement.Cursor property. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Foreground Gets or sets a brush that describes the foreground color. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FormulaBarExpanded Gets or sets a value indicating whether the integrated formula bar is expanded or collapsed. This is a dependency property.
Public property FormulaBarNameBoxItemDisplayMode Gets or sets a value indicating what items should appear in the Name Box list of the integrated formula bar. This is a dependency property.
Public property FormulaBarShowButtons Gets or sets whether the Cancel, Enter and Insert function buttons are displayed in the integrated formula bar. This is a dependency property.
Public property FormulaBarShowEditor Gets or sets whether the formula editor is displayed in the integrated formula bar. This is a dependency property.
Public property FormulaBarShowNameBox Gets or sets whether the Name Box is displayed in the integrated formula bar. This is a dependency property.
Public property GridLinesColor Gets or sets the color of the grid lines in the control.This is a dependency property.
Public property HasAnimatedProperties Gets a value indicating whether this element has any animated properties. (Inherited from System.Windows.UIElement)
Public property Height Gets or sets the suggested height of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property HorizontalAlignment Gets or sets the horizontal alignment characteristics applied to this element when it is composed within a parent element, such as a panel or items control. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property HorizontalContentAlignment Gets or sets the horizontal alignment of the control's content. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property HorizontalScrollBar Provides access to a horizontal scroll bar of the SpreadsheetControl.
Public property HorizontalScrollbarVisibility Gets or sets a value that indicates whether the SpreadsheetControl's scrollbar should be displayed or hidden. This is a dependency property.
Public property InputBindings Gets the collection of input bindings associated with this element. (Inherited from System.Windows.UIElement)
Public property InputScope Gets or sets the context for input used by this System.Windows.FrameworkElement. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property IsArrangeValid Gets a value indicating whether the computed size and position of child elements in this element's layout are valid. (Inherited from System.Windows.UIElement)
Public property IsCellEditorActive Gets whether the cell editor is currently active.
Public property IsEnabled Gets or sets a value indicating whether this element is enabled in the user interface (UI). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsFocused Gets a value that determines whether this element has logical focus. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsHitTestVisible Gets or sets a value that declares whether this element can possibly be returned as a hit test result from some portion of its rendered content. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsInitialized Gets a value that indicates whether this element has been initialized, either during processing by a XAML processor, or by explicitly having its System.Windows.FrameworkElement.EndInit method called. (Inherited from System.Windows.FrameworkElement)
Public property IsInputMethodEnabled Gets a value indicating whether an input method system, such as an Input Method Editor (IME), is enabled for processing the input to this element. (Inherited from System.Windows.UIElement)
Public property IsKeyboardFocused Gets a value indicating whether this element has keyboard focus. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsKeyboardFocusWithin Gets a value indicating whether keyboard focus is anywhere within the element or its visual tree child elements. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsLoaded Gets a value that indicates whether this element has been loaded for presentation. (Inherited from System.Windows.FrameworkElement)
Public property IsManipulationEnabled (Inherited from System.Windows.UIElement)
Public property IsMeasureValid Gets a value indicating whether the current size returned by layout measure is valid. (Inherited from System.Windows.UIElement)
Public property IsMouseCaptured Gets a value indicating whether the mouse is captured to this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsMouseCaptureWithin Gets a value that determines whether mouse capture is held by this element or by child elements in its visual tree. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsMouseDirectlyOver Gets a value that indicates whether the position of the mouse pointer corresponds to hit test results, which take element compositing into account. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsMouseOver Gets a value indicating whether the mouse pointer is located over this element (including child elements in the visual tree). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsPrintingAvailable Indicates whether the SpreadsheetControl can be printed or exported.
Public property IsPrintPreviewAvailable Gets a value indicating whether a preview of the SpreadsheetControl's document is allowed.
Public property IsSealed Gets a value that declares whether this instance is currently read-only. (Inherited from System.Windows.DependencyObject)
Public property IsStylusCaptured Gets a value indicating whether the stylus is captured by this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsStylusCaptureWithin Gets a value that determines whether stylus capture is held by this element, or an element within the element bounds and its visual tree. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsStylusDirectlyOver Gets a value that indicates whether the stylus position corresponds to hit test results, which take element compositing into account. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsStylusOver Gets a value indicating whether the stylus cursor is located over this element (including visual child elements). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsTabStop Gets or sets a value that indicates whether a control is included in tab navigation. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property IsUpdateLocked Returns a value indicating whether the SpreadsheetControl is locked for update.
Public property IsVisible Gets a value indicating whether this element is visible in the user interface (UI). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property Language Gets or sets localization/globalization language information that applies to an element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property LayoutTransform Gets or sets a graphics transformation that should apply to this element when layout is performed. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property LayoutUnit Gets or sets a unit of measure used for a document layout. This is a dependency property.
Public property LayoutViewBounds Gets the bounds of the control's viewport in Layout view (for resolutions specified by the DpiX and DpiY properties).
Public property Margin Gets or sets the outer margin of an element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property MaxHeight Gets or sets the maximum height constraint of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property MaxWidth Gets or sets the maximum width constraint of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property MenuCustomizations Allows you to customize a menu by adding new menu items or removing existing ones. This is a dependency property.
Public property MinHeight Gets or sets the minimum height constraint of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property MinWidth Gets or sets the minimum width constraint of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Modified Gets or sets a value that indicates that the SpreadsheetControl content was modified since it was last saved. This is a dependency property.
Public property Name Gets or sets the identifying name of the element. The name provides a reference so that code-behind, such as event handler code, can refer to a markup element after it is constructed during processing by a XAML processor. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Opacity Gets or sets the opacity factor applied to the entire System.Windows.UIElement when it is rendered in the user interface (UI). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property OpacityMask Gets or sets an opacity mask, as a System.Windows.Media.Brush implementation that is applied to any alpha-channel masking for the rendered content of this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property Options Provides access to different options which can be specified for the document loaded into the SpreadsheetControl and for the control itself. This is a dependency property.
Public property OverridesDefaultStyle Gets or sets a value that indicates whether this element incorporates style properties from theme styles. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Padding Gets or sets the padding inside a control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property Parent Gets the logical parent element of this element. (Inherited from System.Windows.FrameworkElement)
Public property PersistId Obsolete. Gets a value that uniquely identifies this element. (Inherited from System.Windows.UIElement)
Public property PivotTableStyleGalleryGroups Gets or sets the PivotTable Styles gallery groups in the Ribbon UI. For internal use. This is a dependency property.
Public property PivotTableStylePopupGalleryGroups Gets or sets the PivotTable Styles dropdown gallery groups in the Ribbon UI. For internal use. This is a dependency property.
Public property ReadOnly Gets or sets whether document modifications are prohibited. This is a dependency property.
Public property RenderSize Gets (or sets, but see Remarks) the final render size of this element. (Inherited from System.Windows.UIElement)
Public property RenderTransform Gets or sets transform information that affects the rendering position of this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property RenderTransformOrigin Gets or sets the center point of any possible render transform declared by System.Windows.UIElement.RenderTransform, relative to the bounds of the element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property Resources Gets or sets the locally-defined resource dictionary. (Inherited from System.Windows.FrameworkElement)
Public property Ribbon Gets or sets the RibbonControl associated with the current SpreadsheetControl instance. This is a dependency property.
Public property RibbonActions Provides access to the collection of actions used to customize the SpreadhseetControl's integrated ribbon UI.
Public property SelectedCell Gets or sets an active cell in the active worksheet. This is a dependency property.
Public property SelectedComment Gets or sets a comment selected in the active worksheet. This is a dependency property.
Public property SelectedPicture Gets or sets a picture selected in the active worksheet. This is a dependency property.
Public property SelectedShape Gets or sets a shape selected in the active worksheet. This is a dependency property.
Public property Selection Gets or sets a cell range selected in the active worksheet. This is a dependency property.
Public property SheetCount Gets the number of worksheets in the current workbook. This is a dependency property.
Public property ShowCellToolTipMode Gets or sets a condition for displaying a cell tooltip. This is a dependency property.
Public property ShowFormulaBar Gets or sets a value indicating whether the integrated formula bar should be displayed for the SpreadsheetControl. This is a dependency property.
Public property ShowStatusBar Gets or sets whether the Spreadsheet control displays the status bar. This is a dependency property.
Public property ShowTabSelector Gets or sets whether the Sheet Tab Selector of the SpreadsheetControl should be displayed or hidden. This is a dependency property.
Public property SnapsToDevicePixels Gets or sets a value that determines whether rendering for this element should use device-specific pixel settings during rendering. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property Spreadsheet Gets or sets the SpreadsheetControl object to which a child element belongs. This is an attached property.
Public property StatusBarActions Provides access to the collection of actions used to customize the Spreadsheet control's status bar
Public property StatusBarShowAverage Gets or sets whether the status bar should display the average value of the selected cells.
Public property StatusBarShowCount Gets or sets whether the status bar should display the number of selected cells that contain data.
Public property StatusBarShowMax Gets or sets whether the status bar should display the maximum value of the selected cells.
Public property StatusBarShowMin Gets or sets whether the status bar should display the minimum value of the selected cells.
Public property StatusBarShowNumericalCount Gets or sets whether the status bar should display the number of selected cells that contain numerical data.
Public property StatusBarShowPopupMenu Gets or sets whether the status bar should display the context menu that allows users to show or hide status bar entries.
Public property StatusBarShowSum Gets or sets whether the status bar should display the sum of numerical values in the selected cells.
Public property StatusBarShowZoom Gets or sets whether the status bar should display the current zoom percentage.
Public property StatusBarShowZoomSlider Gets or sets whether the status bar should display the zoom slider that allows users to zoom the worksheet.
Public property Style Gets or sets the style used by this element when it is rendered. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property TabIndex Gets or sets a value that determines the order in which elements receive focus when the user navigates through controls by using the TAB key. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property TableStyleGalleryGroups Gets or sets the Table Styles gallery groups in the Ribbon UI. For internal use. This is a dependency property.
Public property TableStylePopupGalleryGroups Gets or sets the Table Styles dropdown gallery groups in the Ribbon UI. For internal use. This is a dependency property.
Public property Tag Gets or sets an arbitrary object value that can be used to store custom information about this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Template Gets or sets a control template. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property TemplatedParent Gets a reference to the template parent of this element. This property is not relevant if the element was not created through a template. (Inherited from System.Windows.FrameworkElement)
Public property ToolTip Gets or sets the tool-tip object that is displayed for this element in the user interface (UI). This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property TouchesCaptured (Inherited from System.Windows.UIElement)
Public property TouchesCapturedWithin (Inherited from System.Windows.UIElement)
Public property TouchesDirectlyOver (Inherited from System.Windows.UIElement)
Public property TouchesOver (Inherited from System.Windows.UIElement)
Public property Triggers Gets the collection of triggers established directly on this element, or in child elements. (Inherited from System.Windows.FrameworkElement)
Public property Uid Gets or sets the Uid for this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property Unit Gets or sets a unit of measure used within the control. This is a dependency property.
Public property UseDefaultSvgImages Gets or sets whether to use bitmap or vector icons for the SpreadsheetControl UI. This is a dependency property.
Public property UseLayoutRounding (Inherited from System.Windows.FrameworkElement)
Public property VerticalAlignment Gets or sets the vertical alignment characteristics applied to this element when it is composed within a parent element such as a panel or items control. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property VerticalContentAlignment Gets or sets the vertical alignment of the control's content. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property VerticalScrollBar Provides access to a vertical scroll bar of the SpreadsheetControl. This is a dependency property.
Public property VerticalScrollbarVisibility Gets or sets a value that indicates whether the SpreadsheetControl's scrollbar should be displayed or hidden.This is a dependency property.
Public property ViewBounds Gets the bounds of the control's viewport.
Public property Visibility Gets or sets the user interface (UI) visibility of this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property VisibleRange Gets the cell range that is currently visible in the Spreadsheet control.
Public property VisibleSheetNames Gets the names of the visible (not hidden) worksheets in the workbook. This is a dependency property.
Public property VisibleUnfrozenRange Gets the visible cell range of the scrollable area when there are frozen rows and columns in the worksheet.
Public property Width Gets or sets the width of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property WorksheetDisplayArea Provides access to an object that allows setting the maximum number of rows and columns that can be displayed in the SpreadsheetControl.
Top

Expanded See Also

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