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 a menu by adding new menu items or removing existing ones. 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 Gets or sets whether the status bar should display the average value of the selected cells.
StatusBarShowCount Gets or sets whether the status bar should display the number of selected cells that contain data.
StatusBarShowMax Gets or sets whether the status bar should display the maximum value of the selected cells.
StatusBarShowMin Gets or sets whether the status bar should display the minimum value of the selected cells.
StatusBarShowNumericalCount Gets or sets whether the status bar should display the number of selected cells that contain numerical data.
StatusBarShowPopupMenu Gets or sets whether the status bar should display the context menu that allows users to show or hide status bar entries.
StatusBarShowSum Gets or sets whether the status bar should display the sum of numerical values in the selected cells.
StatusBarShowZoom Gets or sets whether the status bar should display the current zoom percentage.
StatusBarShowZoomSlider Gets or sets whether the status bar should display the zoom slider that allows users to zoom the worksheet.
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.
See Also