SpreadsheetControl Properties

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

Name	Description
AcceptsEscape	Gets or sets a value indicating whether pressing the ESC key is processed by the SpreadsheetControl. This is a dependency property.
AcceptsReturn	Gets or sets a value indicating whether pressing the RETURN key is processed by the SpreadsheetControl. This is a dependency 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.
ActiveCell	Gets an active cell in the active worksheet.
ActiveChartSheet	Gets the chart sheet that is currently displayed in the SpreadsheetControl.
ActiveSheet	Gets the sheet that is currently displayed in the SpreadsheetControl.
ActiveSheetIndex	Gets or sets the index of an active worksheet. This is a dependency property.
ActiveSheetName	Gets or sets the name of an active worksheet. This is a dependency property.
ActiveView	Provides access to a View object that contains layout information.
ActiveViewZoom	Gets or sets the zoom level for the sheet currently displayed in the SpreadsheetControl. This is a dependency property.
ActiveWorksheet	Gets the worksheet that is currently displayed in the SpreadsheetControl.
ActualHeight	Gets the rendered height of this element. Inherited from FrameworkElement.
ActualWidth	Gets the rendered width of this element. Inherited from FrameworkElement.
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 UIElement.
AreAnyTouchesCaptured	Gets a value that indicates whether at least one touch is captured to this element. Inherited from UIElement.
AreAnyTouchesCapturedWithin	Gets a value that indicates whether at least one touch is captured to this element or to any child elements in its visual tree. Inherited from UIElement.
AreAnyTouchesDirectlyOver	Gets a value that indicates whether at least one touch is pressed over this element. Inherited from UIElement.
AreAnyTouchesOver	Gets a value that indicates whether at least one touch is pressed over this element or any child elements in its visual tree. Inherited from UIElement.
Background	Gets or sets a brush that describes the background of a control. Inherited from Control.
BarManager	Gets or sets the main component that provides Bars functionality. This is a dependency property.
BindingGroup	Gets or sets the BindingGroup that is used for the element. Inherited from FrameworkElement.
BitmapEffect	Gets or sets a bitmap effect that applies directly to the rendered content for this element. This is a dependency property. Inherited from UIElement.
BitmapEffectInput	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 UIElement.
BorderBrush	Gets or sets a brush that describes the border background of a control. Inherited from Control.
BorderThickness	Gets or sets the border thickness of a control. Inherited from Control.
CacheMode	Gets or sets a cached representation of the UIElement. Inherited from UIElement.
CellTemplate	Gets or sets the template used to visualize worksheet cells. This is a dependency property.
CellTemplateSelector	Gets or sets an object that selects a cell template based on custom logic. This is a dependency property.
CellToolTip	Gets or sets the cell tooltip. This is a dependency property.
ChartLayoutGalleryGroups	Gets or sets Chart Gallery Ribbon groups in the Ribbon UI. For internal use. This is a dependency property.
ChartStyleGalleryGroups	Gets or sets the Chart Styles gallery groups in the Ribbon UI. For internal use. This is a dependency property.
ChartStylePopupGalleryGroups	Gets or sets the Chart Styles dropdown gallery groups in the Ribbon UI. For internal use. This is a dependency 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 UIElement.
Clipboard	Provides access to the object used for working with the system clipboard.
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 UIElement.
CommandBarStyle	Gets or sets the command bar for the SpreadsheetControl. This is a dependency property.
CommandBindings	Gets a collection of CommandBinding objects associated with this element. A 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 UIElement.
CommandProvider	Gets or sets the SpreadsheetControl’s command provider. This is a dependency 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. Inherited from FrameworkElement.
Cursor	Gets or sets the cursor that displays when the mouse pointer is over this element. Inherited from FrameworkElement.
DataContext	Gets or sets the data context for an element when it participates in data binding. Inherited from FrameworkElement.
DefaultStyleKey protected	Gets or sets the key to use to reference the style for this control, when theme styles are used or defined. Inherited from FrameworkElement.
DependencyObjectType	Gets the DependencyObjectType that wraps the CLR type of this instance. Inherited from DependencyObject.
DesiredSize	Gets the size that this element computed during the measure pass of the layout process. Inherited from UIElement.
Dispatcher	Gets the Dispatcher this DispatcherObject is associated with. Inherited from DispatcherObject.
Document	Provides access to a workbook loaded in the control.
DocumentSource	Gets or sets a document supplier for a SpreadsheetControl. This is a dependency property.
DpiX	Gets the current dpi value for the X-coordinate.
DpiY	Gets the current dpi value for the Y-coordinate.
Effect	Gets or sets the bitmap effect to apply to the UIElement. This is a dependency property. Inherited from UIElement.
FlowDirection	Gets or sets the direction that text and other user interface (UI) elements flow within any parent element that controls their layout. Inherited from FrameworkElement.
Focusable	Gets or sets a value that indicates whether the element can receive focus. This is a dependency property. Inherited from UIElement.
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. Inherited from FrameworkElement.
FontFamily	Gets or sets the font family of the control. Inherited from Control.
FontSize	Gets or sets the font size. Inherited from Control.
FontStretch	Gets or sets the degree to which a font is condensed or expanded on the screen. Inherited from Control.
FontStyle	Gets or sets the font style. Inherited from Control.
FontWeight	Gets or sets the weight or thickness of the specified font. Inherited from Control.
ForceCursor	Gets or sets a value that indicates whether this FrameworkElement should force the user interface (UI) to render the cursor as declared by the Cursor property. Inherited from FrameworkElement.
Foreground	Gets or sets a brush that describes the foreground color. Inherited from Control.
FormulaBarExpanded	Gets or sets a value indicating whether the integrated formula bar is expanded or collapsed. This is a dependency 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.
FormulaBarShowButtons	Gets or sets whether the Cancel, Enter and Insert function buttons are displayed in the integrated formula bar. This is a dependency property.
FormulaBarShowEditor	Gets or sets whether the formula editor is displayed in the integrated formula bar. This is a dependency property.
FormulaBarShowNameBox	Gets or sets whether the Name Box is displayed in the integrated formula bar. This is a dependency property.
GridLinesColor	Gets or sets the color of the grid lines in the control.This is a dependency property.
HandlesScrolling protected	Gets a value that indicates whether a control supports scrolling. Inherited from Control.
HasAnimatedProperties	Gets a value indicating whether this element has any animated properties. Inherited from UIElement.
HasEffectiveKeyboardFocus protected	Gets a value that indicates whether the UIElement has focus. Inherited from UIElement.
Height	Gets or sets the suggested height of the element. Inherited from FrameworkElement.
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. Inherited from FrameworkElement.
HorizontalContentAlignment	Gets or sets the horizontal alignment of the control’s content. Inherited from Control.
HorizontalScrollBar	Provides access to a horizontal scroll bar of the SpreadsheetControl.
HorizontalScrollbarVisibility	Gets or sets a value that indicates whether the SpreadsheetControl’s scrollbar should be displayed or hidden. This is a dependency property.
InheritanceBehavior protected	Gets or sets the scope limits for property value inheritance, resource key lookup, and RelativeSource FindAncestor lookup. Inherited from FrameworkElement.
InputBindings	Gets the collection of input bindings associated with this element. Inherited from UIElement.
InputScope	Gets or sets the context for input used by this FrameworkElement. Inherited from FrameworkElement.
IsArrangeValid	Gets a value indicating whether the computed size and position of child elements in this element’s layout are valid. Inherited from UIElement.
IsCellEditorActive	Gets whether the cell editor is currently active.
IsEnabled	Gets or sets a value indicating whether this element is enabled in the user interface (UI). This is a dependency property. Inherited from UIElement.
IsEnabledCore protected	Gets a value that becomes the return value of IsEnabled in derived classes. Inherited from UIElement.
IsFocused	Gets a value that determines whether this element has logical focus. This is a dependency property. Inherited from UIElement.
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 UIElement.
IsInitialized	Gets a value that indicates whether this element has been initialized, either during processing by a XAML processor, or by explicitly having its EndInit() method called. Inherited from FrameworkElement.
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 UIElement.
IsKeyboardFocused	Gets a value indicating whether this element has keyboard focus. This is a dependency property. Inherited from UIElement.
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 UIElement.
IsLoaded	Gets a value that indicates whether this element has been loaded for presentation. Inherited from FrameworkElement.
IsManipulationEnabled	Gets or sets a value that indicates whether manipulation events are enabled on this UIElement. Inherited from UIElement.
IsMeasureValid	Gets a value indicating whether the current size returned by layout measure is valid. Inherited from UIElement.
IsMouseCaptured	Gets a value indicating whether the mouse is captured to this element. This is a dependency property. Inherited from UIElement.
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 UIElement.
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 UIElement.
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 UIElement.
IsPrintingAvailable	Indicates whether the SpreadsheetControl can be printed or exported.
IsPrintPreviewAvailable	Gets a value indicating whether a preview of the SpreadsheetControl’s document is allowed.
IsSealed	Gets a value that indicates whether this instance is currently sealed (read-only). Inherited from DependencyObject.
IsStylusCaptured	Gets a value indicating whether the stylus is captured by this element. This is a dependency property. Inherited from UIElement.
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 UIElement.
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 UIElement.
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 UIElement.
IsTabStop	Gets or sets a value that indicates whether a control is included in tab navigation. Inherited from Control.
IsUpdateLocked	Returns a value indicating whether the SpreadsheetControl is locked for update.
IsVisible	Gets a value indicating whether this element is visible in the user interface (UI). This is a dependency property. Inherited from UIElement.
Language	Gets or sets localization/globalization language information that applies to an element. Inherited from FrameworkElement.
LayoutTransform	Gets or sets a graphics transformation that should apply to this element when layout is performed. Inherited from FrameworkElement.
LayoutUnit	Gets or sets a unit of measure used for a document layout. This is a dependency property.
LayoutViewBounds	Gets the bounds of the control’s viewport in Layout view (for resolutions specified by the SpreadsheetControl.DpiX and SpreadsheetControl.DpiY properties).
Margin	Gets or sets the outer margin of an element. Inherited from FrameworkElement.
MaxHeight	Gets or sets the maximum height constraint of the element. Inherited from FrameworkElement.
MaxWidth	Gets or sets the maximum width constraint of the element. Inherited from FrameworkElement.
MenuCustomizations	Allows you to customize the Spreadsheet control’s context menus. This is a dependency property.
MinHeight	Gets or sets the minimum height constraint of the element. Inherited from FrameworkElement.
MinWidth	Gets or sets the minimum width constraint of the element. Inherited from FrameworkElement.
Modified	Gets or sets a value that indicates that the SpreadsheetControl content was modified since it was last saved. This is a dependency 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. Inherited from FrameworkElement.
Opacity	Gets or sets the opacity factor applied to the entire UIElement when it is rendered in the user interface (UI). This is a dependency property. Inherited from UIElement.
OpacityMask	Gets or sets an opacity mask, as a Brush implementation that is applied to any alpha-channel masking for the rendered content of this element. This is a dependency property. Inherited from UIElement.
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.
OverridesDefaultStyle	Gets or sets a value that indicates whether this element incorporates style properties from theme styles. Inherited from FrameworkElement.
Padding	Gets or sets the padding inside a control. Inherited from Control.
Parent	Gets the logical parent element of this element. Inherited from FrameworkElement.
PersistId	Gets a value that uniquely identifies this element. Inherited from UIElement.
PivotTableStyleGalleryGroups	Gets or sets the PivotTable Styles gallery groups in the Ribbon UI. For internal use. This is a dependency property.
PivotTableStylePopupGalleryGroups	Gets or sets the PivotTable Styles dropdown gallery groups in the Ribbon UI. For internal use. This is a dependency property.
ReadOnly	Gets or sets whether document modifications are prohibited. This is a dependency property.
RenderSize	Gets (or sets) the final render size of this element. Inherited from UIElement.
RenderTransform	Gets or sets transform information that affects the rendering position of this element. This is a dependency property. Inherited from UIElement.
RenderTransformOrigin	Gets or sets the center point of any possible render transform declared by RenderTransform, relative to the bounds of the element. This is a dependency property. Inherited from UIElement.
Resources	Gets or sets the locally-defined resource dictionary. Inherited from FrameworkElement.
Ribbon	Gets or sets the RibbonControl associated with the current SpreadsheetControl instance. This is a dependency property.
RibbonActions	Provides access to the collection of actions used to customize the SpreadhseetControl’s integrated ribbon UI.
SelectedCell	Gets or sets an active cell in the active worksheet. This is a dependency property.
SelectedComment	Gets or sets a comment selected in the active worksheet. This is a dependency property.
SelectedPicture	Gets or sets a picture selected in the active worksheet. This is a dependency property.
SelectedShape	Gets or sets a shape selected in the active worksheet. This is a dependency property.
Selection	Gets or sets a cell range selected in the active worksheet. This is a dependency property.
SheetCount	Gets the number of worksheets in the current workbook. This is a dependency property.
ShowCellToolTipMode	Gets or sets a condition for displaying a cell tooltip. This is a dependency property.
ShowFormulaBar	Gets or sets a value indicating whether the integrated formula bar should be displayed for the SpreadsheetControl. This is a dependency property.
ShowStatusBar	Gets or sets whether the Spreadsheet control displays the status bar. This is a dependency property.
ShowTabSelector	Gets or sets whether the Sheet Tab Selector of the SpreadsheetControl should be displayed or hidden. This is a dependency 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 UIElement.
StatusBarActions	Provides access to the collection of actions used to customize the Spreadsheet control’s status bar
StatusBarShowAverage	Specifies whether the status bar displays the average value of the selected cells. This is a dependency property.
StatusBarShowCount	Specifies whether the status bar displays the number of selected cells that contain data. This is a dependency property.
StatusBarShowEndMode	Specifies whether the status bar displays the End Mode label used to indicate that End Mode is activated. This is a dependency property.
StatusBarShowMax	Specifies whether the status bar displays the maximum value of the selected cells. This is a dependency property.
StatusBarShowMin	Specifies whether the status bar displays the minimum value of the selected cells. This is a dependency property.
StatusBarShowNumericalCount	Specifies whether the status bar displays the number of selected cells that contain numerical data. This is a dependency property.
StatusBarShowPopupMenu	Specifies whether the status bar displays the context menu that allows users to show or hide status bar entries. This is a dependency property.
StatusBarShowProgress	Specifies whether the status bar displays the progress bar that indicates the progress of lengthy operations (file load/save operations and export to PDF/HTML). This is a dependency property.
StatusBarShowSum	Specifies whether the status bar displays the sum of numerical values in the selected cells. This is a dependency property.
StatusBarShowZoom	Specifies whether the status bar displays the current zoom percentage. This is a dependency property.
StatusBarShowZoomSlider	Specifies whether the status bar displays the zoom slider that allows users to zoom the worksheet. This is a dependency property.
Style	Gets or sets the style used by this element when it is rendered. Inherited from FrameworkElement.
StylusPlugIns protected	Gets a collection of all stylus plug-in (customization) objects associated with this element. Inherited from UIElement.
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. Inherited from Control.
TableStyleGalleryGroups	Gets or sets the Table Styles gallery groups in the Ribbon UI. For internal use. This is a dependency property.
TableStylePopupGalleryGroups	Gets or sets the Table Styles dropdown gallery groups in the Ribbon UI. For internal use. This is a dependency property.
Tag	Gets or sets an arbitrary object value that can be used to store custom information about this element. Inherited from FrameworkElement.
Template	Gets or sets a control template. Inherited from Control.
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 FrameworkElement.
ToolTip	Gets or sets the tool-tip object that is displayed for this element in the user interface (UI). Inherited from FrameworkElement.
TouchesCaptured	Gets all touch devices that are captured to this element. Inherited from UIElement.
TouchesCapturedWithin	Gets all touch devices that are captured to this element or any child elements in its visual tree. Inherited from UIElement.
TouchesDirectlyOver	Gets all touch devices that are over this element. Inherited from UIElement.
TouchesOver	Gets all touch devices that are over this element or any child elements in its visual tree. Inherited from UIElement.
Triggers	Gets the collection of triggers established directly on this element, or in child elements. Inherited from FrameworkElement.
Uid	Gets or sets the unique identifier (for localization) for this element. This is a dependency property. Inherited from UIElement.
Unit	Gets or sets a unit of measure used within the control. This is a dependency property.
UseLayoutRounding	Gets or sets a value that indicates whether layout rounding should be applied to this element’s size and position during layout. Inherited from FrameworkElement.
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. Inherited from FrameworkElement.
VerticalContentAlignment	Gets or sets the vertical alignment of the control’s content. Inherited from Control.
VerticalScrollBar	Provides access to a vertical scroll bar of the SpreadsheetControl. This is a dependency property.
VerticalScrollbarVisibility	Gets or sets a value that indicates whether the SpreadsheetControl’s scrollbar should be displayed or hidden.This is a dependency property.
ViewBounds	Gets the bounds of the control’s viewport.
Visibility	Gets or sets the user interface (UI) visibility of this element. This is a dependency property. Inherited from UIElement.
VisibleRange	Gets the cell range that is currently visible in the Spreadsheet control.
VisibleSheetNames	Gets the names of the visible (not hidden) worksheets in the workbook. This is a dependency property.
VisibleUnfrozenRange	Gets the visible cell range of the scrollable area when there are frozen rows and columns in the worksheet.
VisualBitmapEffect protected	Gets or sets the BitmapEffect value for the Visual. Inherited from Visual.
VisualBitmapEffectInput protected	Gets or sets the BitmapEffectInput value for the Visual. Inherited from Visual.
VisualBitmapScalingMode protected	Gets or sets the BitmapScalingMode for the Visual. Inherited from Visual.
VisualCacheMode protected	Gets or sets a cached representation of the Visual. Inherited from Visual.
VisualChildrenCount protected	Gets the number of visual child elements within this element. Inherited from FrameworkElement.
VisualClearTypeHint protected	Gets or sets the ClearTypeHint that determines how ClearType is rendered in the Visual. Inherited from Visual.
VisualClip protected	Gets or sets the clip region of the Visual as a Geometry value. Inherited from Visual.
VisualEdgeMode protected	Gets or sets the edge mode of the Visual as an EdgeMode value. Inherited from Visual.
VisualEffect protected	Gets or sets the bitmap effect to apply to the Visual. Inherited from Visual.
VisualOffset protected	Gets or sets the offset value of the visual object. Inherited from Visual.
VisualOpacity protected	Gets or sets the opacity of the Visual. Inherited from Visual.
VisualOpacityMask protected	Gets or sets the Brush value that represents the opacity mask of the Visual. Inherited from Visual.
VisualParent protected	Gets the visual tree parent of the visual object. Inherited from Visual.
VisualScrollableAreaClip protected	Gets or sets a clipped scrollable area for the Visual. Inherited from Visual.
VisualTextHintingMode protected	Gets or sets the TextHintingMode of the Visual. Inherited from Visual.
VisualTextRenderingMode protected	Gets or sets the TextRenderingMode of the Visual. Inherited from Visual.
VisualTransform protected	Gets or sets the Transform value for the Visual. Inherited from Visual.
VisualXSnappingGuidelines protected	Gets or sets the x-coordinate (vertical) guideline collection. Inherited from Visual.
VisualYSnappingGuidelines protected	Gets or sets the y-coordinate (horizontal) guideline collection. Inherited from Visual.
Width	Gets or sets the width of the element. Inherited from FrameworkElement.
WorksheetDisplayArea	Provides access to an object that allows setting the maximum number of rows and columns that can be displayed in the SpreadsheetControl.