Skip to main content
A newer version of this page is available. .

SpreadsheetControl Members

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

Constructors

Name Description
SpreadsheetControl() Initializes a new instance of the SpreadsheetControl class with default settings.

Fields

Name Description
AcceptsEscapeProperty static Identifies the SpreadsheetControl.AcceptsEscape dependency property.
AcceptsReturnProperty static Identifies the SpreadsheetControl.AcceptsReturn dependency property.
AcceptsTabProperty static Identifies the SpreadsheetControl.AcceptsTab dependency property.
ActiveSheetIndexProperty static Identifies the SpreadsheetControl.ActiveSheetIndex dependency property.
ActiveSheetNameProperty static Identifies the SpreadsheetControl.ActiveSheetName dependency property.
ActiveViewZoomProperty static Identifies the SpreadsheetControl.ActiveViewZoom dependency property.
ActualHeightProperty static Identifies the ActualHeight dependency property. Inherited from FrameworkElement.
ActualWidthProperty static Identifies the ActualWidth dependency property. Inherited from FrameworkElement.
AllowDropProperty static Identifies the AllowDrop dependency property. Inherited from UIElement.
AreAnyTouchesCapturedProperty static Identifies the AreAnyTouchesCaptured dependency property. Inherited from UIElement.
AreAnyTouchesCapturedWithinProperty static Identifies the AreAnyTouchesCapturedWithin dependency property. Inherited from UIElement.
AreAnyTouchesDirectlyOverProperty static Identifies the AreAnyTouchesDirectlyOver dependency property. Inherited from UIElement.
AreAnyTouchesOverProperty static Identifies the AreAnyTouchesOver dependency property. Inherited from UIElement.
BackgroundProperty static Identifies the Background dependency property. Inherited from Control.
BarManagerProperty static Identifies the SpreadsheetControl.BarManager dependency property.
BindingGroupProperty static Identifies the BindingGroup dependency property. Inherited from FrameworkElement.
BitmapEffectInputProperty static Identifies the BitmapEffectInput dependency property. Inherited from UIElement.
BitmapEffectProperty static Identifies the BitmapEffect dependency property. Inherited from UIElement.
BorderBrushProperty static Identifies the BorderBrush dependency property. Inherited from Control.
BorderThicknessProperty static Identifies the BorderThickness dependency property. Inherited from Control.
CacheModeProperty static Identifies the CacheMode dependency property. Inherited from UIElement.
CellTemplateProperty static Identifies the SpreadsheetControl.CellTemplate dependency property.
CellTemplateSelectorProperty static Identifies the SpreadsheetControl.CellTemplateSelector dependency property.
CellToolTipProperty static Identifies the SpreadsheetControl.CellToolTip dependency property.
ChartLayoutGalleryGroupsProperty static Identifies the SpreadsheetControl.ChartLayoutGalleryGroups dependency property.
ChartStyleGalleryGroupsProperty static Identifies the SpreadsheetControl.ChartStyleGalleryGroups dependency property.
ChartStylePopupGalleryGroupsProperty static Identifies the SpreadsheetControl.ChartStylePopupGalleryGroups dependency property.
ClipProperty static Identifies the Clip dependency property. Inherited from UIElement.
ClipToBoundsProperty static Identifies the ClipToBounds dependency property. Inherited from UIElement.
CommandBarStyleProperty static Identifies the SpreadsheetControl.CommandBarStyle dependency property.
CommandProviderProperty static Identifies the SpreadsheetControl.CommandProvider dependency property.
ContextMenuClosingEvent static Identifies the ContextMenuClosing routed event. Inherited from FrameworkElement.
ContextMenuOpeningEvent static Identifies the ContextMenuOpening routed event. Inherited from FrameworkElement.
ContextMenuProperty static Identifies the ContextMenu dependency property. Inherited from FrameworkElement.
CursorProperty static Identifies the Cursor dependency property. Inherited from FrameworkElement.
DataContextProperty static Identifies the DataContext dependency property. Inherited from FrameworkElement.
DefaultStyleKeyProperty protected static Identifies the DefaultStyleKey dependency property. Inherited from FrameworkElement.
DocumentSourceProperty static Identifies the SpreadsheetControl.DocumentSource dependency property.
DragEnterEvent static Identifies the DragEnter routed event. Inherited from UIElement.
DragLeaveEvent static Identifies the DragLeave routed event. Inherited from UIElement.
DragOverEvent static Identifies the DragOver routed event. Inherited from UIElement.
DropEvent static Identifies the Drop routed event. Inherited from UIElement.
EffectProperty static Identifies the Effect dependency property. Inherited from UIElement.
FlowDirectionProperty static Identifies the FlowDirection dependency property. Inherited from FrameworkElement.
FocusableProperty static Identifies the Focusable dependency property. Inherited from UIElement.
FocusVisualStyleProperty static Identifies the FocusVisualStyle dependency property. Inherited from FrameworkElement.
FontFamilyProperty static Identifies the FontFamily dependency property. Inherited from Control.
FontSizeProperty static Identifies the FontSize dependency property. Inherited from Control.
FontStretchProperty static Identifies the FontStretch dependency property. Inherited from Control.
FontStyleProperty static Identifies the FontStyle dependency property. Inherited from Control.
FontWeightProperty static Identifies the FontWeight dependency property. Inherited from Control.
ForceCursorProperty static Identifies the ForceCursor dependency property. Inherited from FrameworkElement.
ForegroundProperty static Identifies the Foreground dependency property. Inherited from Control.
FormulaBarExpandedProperty static Identifies the SpreadsheetControl.FormulaBarExpanded dependency property.
FormulaBarNameBoxItemDisplayModeProperty static Identifies the SpreadsheetControl.FormulaBarNameBoxItemDisplayMode dependency property.
FormulaBarShowButtonsProperty static Identifies the SpreadsheetControl.FormulaBarShowButtons dependency property.
FormulaBarShowEditorProperty static Identifies the SpreadsheetControl.FormulaBarShowEditor dependency property.
FormulaBarShowNameBoxProperty static Identifies the SpreadsheetControl.FormulaBarShowNameBox dependency property.
GiveFeedbackEvent static Identifies the GiveFeedback routed event. Inherited from UIElement.
GotFocusEvent static Identifies the GotFocus routed event. Inherited from UIElement.
GotKeyboardFocusEvent static Identifies the GotKeyboardFocus routed event. Inherited from UIElement.
GotMouseCaptureEvent static Identifies the GotMouseCapture routed event. Inherited from UIElement.
GotStylusCaptureEvent static Identifies the GotStylusCapture routed event. Inherited from UIElement.
GotTouchCaptureEvent static Identifies the GotTouchCapture routed event. Inherited from UIElement.
GridLinesColorProperty static Identifies the SpreadsheetControl.GridLinesColor dependency property.
HeightProperty static Identifies the Height dependency property. Inherited from FrameworkElement.
HorizontalAlignmentProperty static Identifies the HorizontalAlignment dependency property. Inherited from FrameworkElement.
HorizontalContentAlignmentProperty static Identifies the HorizontalContentAlignment dependency property. Inherited from Control.
HorizontalScrollbarVisibilityProperty static Identifies the SpreadsheetControl.HorizontalScrollbarVisibility dependency property.
InputScopeProperty static Identifies the InputScope dependency property. Inherited from FrameworkElement.
IsEnabledProperty static Identifies the IsEnabled dependency property. Inherited from UIElement.
IsFocusedProperty static Identifies the IsFocused dependency property. Inherited from UIElement.
IsHitTestVisibleProperty static Identifies the IsHitTestVisible dependency property. Inherited from UIElement.
IsKeyboardFocusedProperty static Identifies the IsKeyboardFocused dependency property. Inherited from UIElement.
IsKeyboardFocusWithinProperty static Identifies the IsKeyboardFocusWithin dependency property. Inherited from UIElement.
IsManipulationEnabledProperty static Identifies the IsManipulationEnabled dependency property. Inherited from UIElement.
IsMouseCapturedProperty static Identifies the IsMouseCaptured dependency property. Inherited from UIElement.
IsMouseCaptureWithinProperty static Identifies the IsMouseCaptureWithin dependency property. Inherited from UIElement.
IsMouseDirectlyOverProperty static Identifies the IsMouseDirectlyOver dependency property. Inherited from UIElement.
IsMouseOverProperty static Identifies the IsMouseOver dependency property. Inherited from UIElement.
IsStylusCapturedProperty static Identifies the IsStylusCaptured dependency property. Inherited from UIElement.
IsStylusCaptureWithinProperty static Identifies the IsStylusCaptureWithin dependency property. Inherited from UIElement.
IsStylusDirectlyOverProperty static Identifies the IsStylusDirectlyOver dependency property. Inherited from UIElement.
IsStylusOverProperty static Identifies the IsStylusOver dependency property. Inherited from UIElement.
IsTabStopProperty static Identifies the IsTabStop dependency property. Inherited from Control.
IsVisibleProperty static Identifies the IsVisible dependency property. Inherited from UIElement.
KeyDownEvent static Identifies the KeyDown routed event. Inherited from UIElement.
KeyUpEvent static Identifies the KeyUp routed event. Inherited from UIElement.
LanguageProperty static Identifies the Language dependency property. Inherited from FrameworkElement.
LayoutTransformProperty static Identifies the LayoutTransform dependency property. Inherited from FrameworkElement.
LayoutUnitProperty static Identifies the SpreadsheetControl.LayoutUnit dependency property.
LoadedEvent static Identifies the Loaded routed event. Inherited from FrameworkElement.
LostFocusEvent static Identifies the LostFocus routed event. Inherited from UIElement.
LostKeyboardFocusEvent static Identifies the LostKeyboardFocus routed event. Inherited from UIElement.
LostMouseCaptureEvent static Identifies the LostMouseCapture routed event. Inherited from UIElement.
LostStylusCaptureEvent static Identifies the LostStylusCapture routed event. Inherited from UIElement.
LostTouchCaptureEvent static Identifies the LostTouchCapture routed event. Inherited from UIElement.
ManipulationBoundaryFeedbackEvent static Identifies the ManipulationBoundaryFeedback event. Inherited from UIElement.
ManipulationCompletedEvent static Identifies the ManipulationCompleted routed event. Inherited from UIElement.
ManipulationDeltaEvent static Identifies the ManipulationDelta routed event. Inherited from UIElement.
ManipulationInertiaStartingEvent static Identifies the ManipulationInertiaStarting routed event. Inherited from UIElement.
ManipulationStartedEvent static Identifies the ManipulationStarted routed event. Inherited from UIElement.
ManipulationStartingEvent static Identifies the ManipulationStarting routed event. Inherited from UIElement.
MarginProperty static Identifies the Margin dependency property. Inherited from FrameworkElement.
MaxHeightProperty static Identifies the MaxHeight dependency property. Inherited from FrameworkElement.
MaxWidthProperty static Identifies the MaxWidth dependency property. Inherited from FrameworkElement.
MenuCustomizationsProperty static Identifies the SpreadsheetControl.MenuCustomizations dependency property.
MinHeightProperty static Identifies the MinHeight dependency property. Inherited from FrameworkElement.
MinWidthProperty static Identifies the MinWidth dependency property. Inherited from FrameworkElement.
ModifiedProperty static Identifies the SpreadsheetControl.Modified dependency property.
MouseDoubleClickEvent static Identifies the MouseDoubleClick routed event. Inherited from Control.
MouseDownEvent static Identifies the MouseDown routed event. Inherited from UIElement.
MouseEnterEvent static Identifies the MouseEnter routed event. Inherited from UIElement.
MouseLeaveEvent static Identifies the MouseLeave routed event. Inherited from UIElement.
MouseLeftButtonDownEvent static Identifies the MouseLeftButtonDown routed event. Inherited from UIElement.
MouseLeftButtonUpEvent static Identifies the MouseLeftButtonUp routed event. Inherited from UIElement.
MouseMoveEvent static Identifies the MouseMove routed event. Inherited from UIElement.
MouseRightButtonDownEvent static Identifies the MouseRightButtonDown routed event. Inherited from UIElement.
MouseRightButtonUpEvent static Identifies the MouseRightButtonUp routed event. Inherited from UIElement.
MouseUpEvent static Identifies the MouseUp routed event. Inherited from UIElement.
MouseWheelEvent static Identifies the MouseWheel routed event. Inherited from UIElement.
NameProperty static Identifies the Name dependency property. Inherited from FrameworkElement.
OpacityMaskProperty static Identifies the OpacityMask dependency property. Inherited from UIElement.
OpacityProperty static Identifies the Opacity dependency property. Inherited from UIElement.
OptionsProperty static Identifies the SpreadsheetControl.Options dependency property.
OverridesDefaultStyleProperty static Identifies the OverridesDefaultStyle dependency property. Inherited from FrameworkElement.
PaddingProperty static Identifies the Padding dependency property. Inherited from Control.
PivotTableStyleGalleryGroupsProperty static Identifies the SpreadsheetControl.PivotTableStyleGalleryGroups dependency property.
PivotTableStylePopupGalleryGroupsProperty static Identifies the SpreadsheetControl.PivotTableStylePopupGalleryGroups dependency property.
PreviewDragEnterEvent static Identifies the PreviewDragEnter routed event. Inherited from UIElement.
PreviewDragLeaveEvent static Identifies the PreviewDragLeave routed event. Inherited from UIElement.
PreviewDragOverEvent static Identifies the PreviewDragOver routed event. Inherited from UIElement.
PreviewDropEvent static Identifies the PreviewDrop routed event. Inherited from UIElement.
PreviewGiveFeedbackEvent static Identifies the PreviewGiveFeedback routed event. Inherited from UIElement.
PreviewGotKeyboardFocusEvent static Identifies the PreviewGotKeyboardFocus routed event. Inherited from UIElement.
PreviewKeyDownEvent static Identifies the PreviewKeyDown routed event. Inherited from UIElement.
PreviewKeyUpEvent static Identifies the PreviewKeyUp routed event. Inherited from UIElement.
PreviewLostKeyboardFocusEvent static Identifies the PreviewLostKeyboardFocus routed event. Inherited from UIElement.
PreviewMouseDoubleClickEvent static Identifies the PreviewMouseDoubleClick routed event. Inherited from Control.
PreviewMouseDownEvent static Identifies the PreviewMouseDown routed event. Inherited from UIElement.
PreviewMouseLeftButtonDownEvent static Identifies the PreviewMouseLeftButtonDown routed event. Inherited from UIElement.
PreviewMouseLeftButtonUpEvent static Identifies the PreviewMouseLeftButtonUp routed event. Inherited from UIElement.
PreviewMouseMoveEvent static Identifies the PreviewMouseMove routed event. Inherited from UIElement.
PreviewMouseRightButtonDownEvent static Identifies the PreviewMouseRightButtonDown routed event. Inherited from UIElement.
PreviewMouseRightButtonUpEvent static Identifies the PreviewMouseRightButtonUp routed event. Inherited from UIElement.
PreviewMouseUpEvent static Identifies the PreviewMouseUp routed event. Inherited from UIElement.
PreviewMouseWheelEvent static Identifies the PreviewMouseWheel routed event. Inherited from UIElement.
PreviewQueryContinueDragEvent static Identifies the PreviewQueryContinueDrag routed event. Inherited from UIElement.
PreviewStylusButtonDownEvent static Identifies the PreviewStylusButtonDown routed event. Inherited from UIElement.
PreviewStylusButtonUpEvent static Identifies the PreviewStylusButtonUp routed event. Inherited from UIElement.
PreviewStylusDownEvent static Identifies the PreviewStylusDown routed event. Inherited from UIElement.
PreviewStylusInAirMoveEvent static Identifies the PreviewStylusInAirMove routed event. Inherited from UIElement.
PreviewStylusInRangeEvent static Identifies the PreviewStylusInRange routed event. Inherited from UIElement.
PreviewStylusMoveEvent static Identifies the PreviewStylusMove routed event. Inherited from UIElement.
PreviewStylusOutOfRangeEvent static Identifies the PreviewStylusOutOfRange routed event. Inherited from UIElement.
PreviewStylusSystemGestureEvent static Identifies the PreviewStylusSystemGesture routed event. Inherited from UIElement.
PreviewStylusUpEvent static Identifies the PreviewStylusUp routed event. Inherited from UIElement.
PreviewTextInputEvent static Identifies the PreviewTextInput routed event. Inherited from UIElement.
PreviewTouchDownEvent static Identifies the PreviewTouchDown routed event. Inherited from UIElement.
PreviewTouchMoveEvent static Identifies the PreviewTouchMove routed event. Inherited from UIElement.
PreviewTouchUpEvent static Identifies the PreviewTouchUp routed event. Inherited from UIElement.
QueryContinueDragEvent static Identifies the QueryContinueDrag routed event. Inherited from UIElement.
QueryCursorEvent static Identifies the QueryCursor routed event. Inherited from UIElement.
ReadOnlyProperty static Identifies the SpreadsheetControl.ReadOnly dependency property.
RenderTransformOriginProperty static Identifies the RenderTransformOrigin dependency property. Inherited from UIElement.
RenderTransformProperty static Identifies the RenderTransform dependency property. Inherited from UIElement.
RequestBringIntoViewEvent static Identifies the RequestBringIntoView routed event. Inherited from FrameworkElement.
RibbonProperty static Identifies the SpreadsheetControl.Ribbon dependency property.
SelectedCellProperty static Identifies the SpreadsheetControl.SelectedCell dependency property.
SelectedCommentProperty static Identifies the SpreadsheetControl.SelectedComment dependency property.
SelectedPictureProperty static Identifies the SpreadsheetControl.SelectedPicture dependency property.
SelectedShapeProperty static Identifies the SpreadsheetControl.SelectedShape dependency property.
SelectionProperty static Identifies the SpreadsheetControl.Selection dependency property.
SheetCountProperty static Identifies the SpreadsheetControl.SheetCount dependency property.
ShowCellToolTipModeProperty static Identifies the SpreadsheetControl.ShowCellToolTipMode dependency property.
ShowFormulaBarProperty static Identifies the SpreadsheetControl.ShowFormulaBar dependency property.
ShowTabSelectorProperty static Identifies the SpreadsheetControl.ShowTabSelector dependency property.
SizeChangedEvent static Identifies the SizeChanged routed event. Inherited from FrameworkElement.
SnapsToDevicePixelsProperty static Identifies the SnapsToDevicePixels dependency property. Inherited from UIElement.
SpreadsheetProperty static Identifies the SpreadsheetControl.Spreadsheet dependency property.
StyleProperty static Identifies the Style dependency property. Inherited from FrameworkElement.
StylusButtonDownEvent static Identifies the StylusButtonDown routed event. Inherited from UIElement.
StylusButtonUpEvent static Identifies the StylusButtonUp routed event. Inherited from UIElement.
StylusDownEvent static Identifies the StylusDown routed event. Inherited from UIElement.
StylusEnterEvent static Identifies the StylusEnter routed event. Inherited from UIElement.
StylusInAirMoveEvent static Identifies the StylusInAirMove routed event. Inherited from UIElement.
StylusInRangeEvent static Identifies the StylusInRange routed event. Inherited from UIElement.
StylusLeaveEvent static Identifies the StylusLeave routed event. Inherited from UIElement.
StylusMoveEvent static Identifies the StylusMove routed event. Inherited from UIElement.
StylusOutOfRangeEvent static Identifies the StylusOutOfRange routed event. Inherited from UIElement.
StylusSystemGestureEvent static Identifies the StylusSystemGesture routed event. Inherited from UIElement.
StylusUpEvent static Identifies the StylusUp routed event. Inherited from UIElement.
TabIndexProperty static Identifies the TabIndex dependency property. Inherited from Control.
TableStyleGalleryGroupsProperty static Identifies the SpreadsheetControl.TableStyleGalleryGroups dependency property.
TableStylePopupGalleryGroupsProperty static Identifies the SpreadsheetControl.TableStylePopupGalleryGroups dependency property.
TagProperty static Identifies the Tag dependency property. Inherited from FrameworkElement.
TemplateProperty static Identifies the Template dependency property. Inherited from Control.
TextInputEvent static Identifies the TextInput routed event. Inherited from UIElement.
ToolTipClosingEvent static Identifies the ToolTipClosing routed event. Inherited from FrameworkElement.
ToolTipOpeningEvent static Identifies the ToolTipOpening routed event. Inherited from FrameworkElement.
ToolTipProperty static Identifies the ToolTip dependency property. Inherited from FrameworkElement.
TouchDownEvent static Identifies the TouchDown routed event. Inherited from UIElement.
TouchEnterEvent static Identifies the TouchEnter routed event. Inherited from UIElement.
TouchLeaveEvent static Identifies the TouchLeave routed event. Inherited from UIElement.
TouchMoveEvent static Identifies the TouchMove routed event. Inherited from UIElement.
TouchUpEvent static Identifies the TouchUp routed event. Inherited from UIElement.
UidProperty static Identifies the Uid dependency property. Inherited from UIElement.
UnitProperty static Identifies the SpreadsheetControl.Unit dependency property.
UnloadedEvent static Identifies the Unloaded routed event. Inherited from FrameworkElement.
UseDefaultSvgImagesProperty static Identifies the SpreadsheetControl.UseDefaultSvgImages dependency property.
UseLayoutRoundingProperty static Identifies the UseLayoutRounding dependency property. Inherited from FrameworkElement.
VerticalAlignmentProperty static Identifies the VerticalAlignment dependency property. Inherited from FrameworkElement.
VerticalContentAlignmentProperty static Identifies the VerticalContentAlignment dependency property. Inherited from Control.
VerticalScrollbarVisibilityProperty static Identifies the SpreadsheetControl.VerticalScrollbarVisibility dependency property.
VisibilityProperty static Identifies the Visibility dependency property. Inherited from UIElement.
VisibleSheetNamesProperty static Identifies the SpreadsheetControl.VisibleSheetNames dependency property.
WidthProperty static Identifies the Width dependency property. Inherited from FrameworkElement.

Properties

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.
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.
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 SpreadsheetControl.
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.

Methods

Name Description
AddHandler(RoutedEvent, Delegate, Boolean) Adds a routed event handler for a specified routed event, adding the handler to the handler collection on the current element. Specify handledEventsToo as true to have the provided handler be invoked for routed event that had already been marked as handled by another element along the event route. Inherited from UIElement.
AddHandler(RoutedEvent, Delegate) Adds a routed event handler for a specified routed event, adding the handler to the handler collection on the current element. Inherited from UIElement.
AddLogicalChild(Object) protected Adds the provided object to the logical tree of this element. Inherited from FrameworkElement.
AddService(Type, ServiceCreatorCallback, Boolean) Adds the specified service to the service container.
AddService(Type, ServiceCreatorCallback) Adds the specified service to the service container.
AddService(Type, Object, Boolean) Adds the specified service to the service container.
AddService(Type, Object) Adds the specified service to the service container.
AddToEventRoute(EventRoute, RoutedEventArgs) Adds handlers to the specified EventRoute for the current UIElement event handler collection. Inherited from UIElement.
AddVisualChild(Visual) protected Defines the parent-child relationship between two visuals. Inherited from Visual.
ApplyAnimationClock(DependencyProperty, AnimationClock, HandoffBehavior) Applies an animation to a specified dependency property on this element, with the ability to specify what happens if the property already has a running animation. Inherited from UIElement.
ApplyAnimationClock(DependencyProperty, AnimationClock) Applies an animation to a specified dependency property on this element. Any existing animations are stopped and replaced with the new animation. Inherited from UIElement.
ApplyTemplate() Builds the current template’s visual tree if necessary, and returns a value that indicates whether the visual tree was rebuilt by this call. Inherited from FrameworkElement.
Arrange(Rect) Positions child elements and determines a size for a UIElement. Parent elements call this method from their ArrangeCore(Rect) implementation (or a WPF framework-level equivalent) to form a recursive layout update. This method constitutes the second pass of a layout update. Inherited from UIElement.
ArrangeCore(Rect) protected Implements ArrangeCore(Rect) (defined as virtual in UIElement) and seals the implementation. Inherited from FrameworkElement.
ArrangeOverride(Size) protected Called to arrange and size the content of a Control object. Inherited from Control.
AssignShortcutKeyToCommand(Keys, Keys, SpreadsheetCommandId) Assigns a shortcut key to a command.
BeginAnimation(DependencyProperty, AnimationTimeline, HandoffBehavior) Starts a specific animation for a specified animated property on this element, with the option of specifying what happens if the property already has a running animation. Inherited from UIElement.
BeginAnimation(DependencyProperty, AnimationTimeline) Starts an animation for a specified animated property on this element. Inherited from UIElement.
BeginInit() Starts the initialization process for this element. Inherited from FrameworkElement.
BeginInvoke(Action) Executes a delegate asynchronously on the thread with which the SpreadsheetControl’s Dispatcher is associated.
BeginStoryboard(Storyboard, HandoffBehavior, Boolean) Begins the sequence of actions contained in the provided storyboard, with specified state for control of the animation after it is started. Inherited from FrameworkElement.
BeginStoryboard(Storyboard, HandoffBehavior) Begins the sequence of actions contained in the provided storyboard, with options specified for what should happen if the property is already animated. Inherited from FrameworkElement.
BeginStoryboard(Storyboard) Begins the sequence of actions that are contained in the provided storyboard. Inherited from FrameworkElement.
BeginUpdate() Locks the SpreadsheetControl to prevent its visual updates until the SpreadsheetControl.EndUpdate method is called.
BringIntoView() Attempts to bring this element into view, within any scrollable regions it is contained within. Inherited from FrameworkElement.
BringIntoView(Rect) Attempts to bring the provided region size of this element into view, within any scrollable regions it is contained within. Inherited from FrameworkElement.
CancelUpdate() This method supports the internal infrastructure and is not intended to be called directly from your code. Use the SpreadsheetControl.EndUpdate method instead.
CaptureMouse() Attempts to force capture of the mouse to this element. Inherited from UIElement.
CaptureStylus() Attempts to force capture of the stylus to this element. Inherited from UIElement.
CaptureTouch(TouchDevice) Attempts to force capture of a touch to this element. Inherited from UIElement.
CheckAccess() Determines whether the calling thread has access to this DispatcherObject. Inherited from DispatcherObject.
CircleInvalidData() Displays circles around invalid data in a worksheet to which data validation is applied.
ClearValidationCircles() Hides circles around invalid data in a worksheet to which data validation is applied.
ClearValue(DependencyProperty) Clears the local value of a property. The property to be cleared is specified by a DependencyProperty identifier. Inherited from DependencyObject.
ClearValue(DependencyPropertyKey) Clears the local value of a read-only property. The property to be cleared is specified by a DependencyPropertyKey. Inherited from DependencyObject.
CloseCellEditor(CellEditorEnterValueMode) Closes the cell editor.
CoerceValue(DependencyProperty) Coerces the value of the specified dependency property. This is accomplished by invoking any CoerceValueCallback function specified in property metadata for the dependency property as it exists on the calling DependencyObject. Inherited from DependencyObject.
CreateCommand(SpreadsheetCommandId) Creates a command by its identifier.
CreateNewDocument() Creates and loads a new empty workbook.
Dispose() Disposes the SpreadsheetControl and releases all the allocated resources.
EndInit() Indicates that the initialization process for the element is complete. Inherited from FrameworkElement.
EndUpdate() Unlocks the SpreadsheetControl object after a call to the SpreadsheetControl.BeginUpdate method and causes an immediate visual update.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether a provided DependencyObject is equivalent to the current DependencyObject. Inherited from DependencyObject.
ExportToHtml(Stream, Range) Exports the specified range to the specified stream in HTML format.
ExportToHtml(Stream, Worksheet) Exports the specified worksheet to the specified stream in HTML format.
ExportToHtml(Stream, HtmlDocumentExporterOptions) Exports the document’s data to the specified stream in HTML format using the specified options.
ExportToHtml(Stream, Int32) Exports the specified worksheet to the specified stream in HTML format.
ExportToHtml(String, Range) Exports the specified range to the specified file in HTML format.
ExportToHtml(String, Worksheet) Exports the specified worksheet to the specified file in HTML format.
ExportToHtml(String, HtmlDocumentExporterOptions) Exports the document’s data to the specified file in HTML format using the specified options.
ExportToHtml(String, Int32) Exports the specified worksheet to the specified file in HTML format.
ExportToPdf(Stream, PdfExportOptions) Exports the content of the SpreadsheetControl to the specified stream in PDF format using the specified options.
ExportToPdf(Stream) Exports the content of the SpreadsheetControl to the specified stream in PDF format.
ExportToPdf(String, PdfExportOptions) Exports the content of the SpreadsheetControl to the specified file in PDF format using the specified options.
ExportToPdf(String) Exports the content of the SpreadsheetControl to the specified file in PDF format.
FindCommonVisualAncestor(DependencyObject) Returns the common ancestor of two visual objects. Inherited from Visual.
FindName(String) Finds an element that has the provided identifier name. Inherited from FrameworkElement.
FindResource(Object) Searches for a resource with the specified key, and throws an exception if the requested resource is not found. Inherited from FrameworkElement.
Focus() Attempts to set focus to this element. Inherited from UIElement.
GetAnimationBaseValue(DependencyProperty) Returns the base property value for the specified property on this element, disregarding any possible animated value from a running or stopped animation. Inherited from UIElement.
GetBindingExpression(DependencyProperty) Returns the BindingExpression that represents the binding on the specified property. Inherited from FrameworkElement.
GetCellBounds(Int32, Int32) Obtains the coordinates and size of a cell specified by the row and column indices.
GetCellFromPoint(PointF) Gets a worksheet cell located at the specified point.
GetCommand(SpreadsheetCommandId) Obtains a command by the command identifier.
GetFlowDirection(DependencyObject) static Gets the value of the FlowDirection attached property for the specified DependencyObject. Inherited from FrameworkElement.
GetHashCode() Gets a hash code for this DependencyObject. Inherited from DependencyObject.
GetLayoutClip(Size) protected Returns a geometry for a clipping mask. The mask applies if the layout system attempts to arrange an element that is larger than the available display space. Inherited from FrameworkElement.
GetLocalValueEnumerator() Creates a specialized enumerator for determining which dependency properties have locally set values on this DependencyObject. Inherited from DependencyObject.
GetSelectedRanges() Gets ranges selected in the active worksheet.
GetSelectedShapes() Returns shapes currently selected in the worksheet.
GetService(Type) Gets the service object of the specified type.
GetService<T>() Gets the specified service.
GetSpreadsheet(DependencyObject) static Gets the value of the SpreadsheetControl.Spreadsheet attached property for the specified DependencyObject.
GetTemplateChild(String) protected Returns the named element in the visual tree of an instantiated ControlTemplate. Inherited from FrameworkElement.
GetType() Gets the Type of the current instance. Inherited from Object.
GetUIParentCore() protected Returns an alternative logical parent for this element if there is no visual parent. Inherited from FrameworkElement.
GetUseDefaultSvgImages(DependencyObject) static Gets the value of the SpreadsheetControl.UseDefaultSvgImages attached property.
GetValue(DependencyProperty) Returns the current effective value of a dependency property on this instance of a DependencyObject. Inherited from DependencyObject.
GetVisualChild(Int32) protected Overrides GetVisualChild(Int32), and returns a child at the specified index from a collection of child elements. Inherited from FrameworkElement.
HitTestCore(GeometryHitTestParameters) protected Implements HitTestCore(GeometryHitTestParameters) to supply base element hit testing behavior (returning GeometryHitTestResult). Inherited from UIElement.
HitTestCore(PointHitTestParameters) protected Implements HitTestCore(PointHitTestParameters) to supply base element hit testing behavior (returning HitTestResult). Inherited from UIElement.
InputHitTest(Point) Returns the input element within the current element that is at the specified coordinates, relative to the current element’s origin. Inherited from UIElement.
InvalidateArrange() Invalidates the arrange state (layout) for the element. After the invalidation, the element will have its layout updated, which will occur asynchronously unless subsequently forced by UpdateLayout(). Inherited from UIElement.
InvalidateMeasure() Invalidates the measurement state (layout) for the element. Inherited from UIElement.
InvalidateProperty(DependencyProperty) Re-evaluates the effective value for the specified dependency property. Inherited from DependencyObject.
InvalidateVisual() Invalidates the rendering of the element, and forces a complete new layout pass. OnRender(DrawingContext) is called after the layout cycle is completed. Inherited from UIElement.
IsAncestorOf(DependencyObject) Determines whether the visual object is an ancestor of the descendant visual object. Inherited from Visual.
IsDescendantOf(DependencyObject) Determines whether the visual object is a descendant of the ancestor visual object. Inherited from Visual.
LoadDocument() Invokes the Open modal dialog box.
LoadDocument(Byte[], DocumentFormat) Loads a document from a byte array.
LoadDocument(Byte[]) Loads the document from a Byte[] array.
LoadDocument(Stream, DocumentFormat) Loads a document from a stream, specifying the document format.
LoadDocument(Stream) Loads a document from a stream.
LoadDocument(String, DocumentFormat) Loads a document from a file, specifying the document format.
LoadDocument(String) Loads the specified file.
LoadDocument(IWin32Window) Invokes the Open modal dialog box with the specified owner.
Measure(Size) Updates the DesiredSize of a UIElement. Parent elements call this method from their own MeasureCore(Size) implementations to form a recursive layout update. Calling this method constitutes the first pass (the “Measure” pass) of a layout update. Inherited from UIElement.
MeasureCore(Size) protected Implements basic measure-pass layout system behavior for FrameworkElement. Inherited from FrameworkElement.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
MoveFocus(TraversalRequest) Moves the keyboard focus away from this element and to another element in a provided traversal direction. Inherited from FrameworkElement.
OnAccessKey(AccessKeyEventArgs) protected Provides class handling for when an access key that is meaningful for this element is invoked. Inherited from UIElement.
OnApplyTemplate() Called after the template is completely generated and attached to the visual tree.
OnChildDesiredSizeChanged(UIElement) protected Supports layout behavior when a child element is resized. Inherited from UIElement.
OnContextMenuClosing(ContextMenuEventArgs) protected Invoked whenever an unhandled ContextMenuClosing routed event reaches this class in its route. Implement this method to add class handling for this event. Inherited from FrameworkElement.
OnContextMenuOpening(ContextMenuEventArgs) protected Invoked whenever an unhandled ContextMenuOpening routed event reaches this class in its route. Implement this method to add class handling for this event. Inherited from FrameworkElement.
OnCreateAutomationPeer() protected Returns class-specific AutomationPeer implementations for the Windows Presentation Foundation (WPF) infrastructure. Inherited from UIElement.
OnDpiChanged(DpiScale, DpiScale) protected Called when the DPI at which this View is rendered changes. Inherited from Visual.
OnDragEnter(DragEventArgs) protected Invoked when an unhandled DragEnter attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnDragLeave(DragEventArgs) protected Invoked when an unhandled DragLeave attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnDragOver(DragEventArgs) protected Invoked when an unhandled DragOver attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnDrop(DragEventArgs) protected Invoked when an unhandled DragEnter attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnGiveFeedback(GiveFeedbackEventArgs) protected Invoked when an unhandled GiveFeedback attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnGotFocus(RoutedEventArgs) protected Invoked whenever an unhandled GotFocus event reaches this element in its route. Inherited from FrameworkElement.
OnGotMouseCapture(MouseEventArgs) protected Invoked when an unhandled GotMouseCapture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnGotStylusCapture(StylusEventArgs) protected Invoked when an unhandled GotStylusCapture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnGotTouchCapture(TouchEventArgs) protected Provides class handling for the GotTouchCapture routed event that occurs when a touch is captured to this element. Inherited from UIElement.
OnInitialized(EventArgs) protected Raises the Initialized event. This method is invoked whenever IsInitialized is set to true internally. Inherited from FrameworkElement.
OnIsKeyboardFocusedChanged(DependencyPropertyChangedEventArgs) protected Invoked when an unhandled IsKeyboardFocusedChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsKeyboardFocusWithinChanged(DependencyPropertyChangedEventArgs) protected Invoked just before the IsKeyboardFocusWithinChanged event is raised by this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsMouseCapturedChanged(DependencyPropertyChangedEventArgs) protected Invoked when an unhandled IsMouseCapturedChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsMouseCaptureWithinChanged(DependencyPropertyChangedEventArgs) protected Invoked when an unhandled IsMouseCaptureWithinChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsMouseDirectlyOverChanged(DependencyPropertyChangedEventArgs) protected Invoked when an unhandled IsMouseDirectlyOverChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsStylusCapturedChanged(DependencyPropertyChangedEventArgs) protected Invoked when an unhandled IsStylusCapturedChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsStylusCaptureWithinChanged(DependencyPropertyChangedEventArgs) protected Invoked when an unhandled IsStylusCaptureWithinChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnIsStylusDirectlyOverChanged(DependencyPropertyChangedEventArgs) protected Invoked when an unhandled IsStylusDirectlyOverChanged event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnKeyDown(KeyEventArgs) protected Invoked when an unhandled KeyDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnKeyUp(KeyEventArgs) protected Invoked when an unhandled KeyUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnLostFocus(RoutedEventArgs) protected Raises the LostFocus routed event by using the event data that is provided. Inherited from UIElement.
OnLostMouseCapture(MouseEventArgs) protected Invoked when an unhandled LostMouseCapture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnLostStylusCapture(StylusEventArgs) protected Invoked when an unhandled LostStylusCapture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnLostTouchCapture(TouchEventArgs) protected Provides class handling for the LostTouchCapture routed event that occurs when this element loses a touch capture. Inherited from UIElement.
OnManipulationBoundaryFeedback(ManipulationBoundaryFeedbackEventArgs) protected Called when the ManipulationBoundaryFeedback event occurs. Inherited from UIElement.
OnManipulationCompleted(ManipulationCompletedEventArgs) protected Called when the ManipulationCompleted event occurs. Inherited from UIElement.
OnManipulationDelta(ManipulationDeltaEventArgs) protected Called when the ManipulationDelta event occurs. Inherited from UIElement.
OnManipulationInertiaStarting(ManipulationInertiaStartingEventArgs) protected Called when the ManipulationInertiaStarting event occurs. Inherited from UIElement.
OnManipulationStarted(ManipulationStartedEventArgs) protected Called when the ManipulationStarted event occurs. Inherited from UIElement.
OnManipulationStarting(ManipulationStartingEventArgs) protected Provides class handling for the ManipulationStarting routed event that occurs when the manipulation processor is first created. Inherited from UIElement.
OnMouseDoubleClick(MouseButtonEventArgs) protected Raises the MouseDoubleClick routed event. Inherited from Control.
OnMouseEnter(MouseEventArgs) protected Invoked when an unhandled MouseEnter attached event is raised on this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseRightButtonDown(MouseButtonEventArgs) protected Invoked when an unhandled MouseRightButtonDown routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseRightButtonUp(MouseButtonEventArgs) protected Invoked when an unhandled MouseRightButtonUp routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnMouseWheel(MouseWheelEventArgs) protected Invoked when an unhandled MouseWheel attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewDragEnter(DragEventArgs) protected Invoked when an unhandled PreviewDragEnter attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewDragLeave(DragEventArgs) protected Invoked when an unhandled PreviewDragLeave attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewDragOver(DragEventArgs) protected Invoked when an unhandled PreviewDragOver attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewDrop(DragEventArgs) protected Invoked when an unhandled PreviewDrop attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewGiveFeedback(GiveFeedbackEventArgs) protected Invoked when an unhandled PreviewGiveFeedback attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewGotKeyboardFocus(KeyboardFocusChangedEventArgs) protected Invoked when an unhandled PreviewGotKeyboardFocus attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewLostKeyboardFocus(KeyboardFocusChangedEventArgs) protected Invoked when an unhandled PreviewKeyDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseDoubleClick(MouseButtonEventArgs) protected Raises the PreviewMouseDoubleClick routed event. Inherited from Control.
OnPreviewMouseDown(MouseButtonEventArgs) protected Invoked when an unhandled PreviewMouseDown attached routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseLeftButtonDown(MouseButtonEventArgs) protected Invoked when an unhandled PreviewMouseLeftButtonDown routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseLeftButtonUp(MouseButtonEventArgs) protected Invoked when an unhandled PreviewMouseLeftButtonUp routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseMove(MouseEventArgs) protected Invoked when an unhandled PreviewMouseMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseRightButtonDown(MouseButtonEventArgs) protected Invoked when an unhandled PreviewMouseRightButtonDown routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseRightButtonUp(MouseButtonEventArgs) protected Invoked when an unhandled PreviewMouseRightButtonUp routed event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseUp(MouseButtonEventArgs) protected Invoked when an unhandled PreviewMouseUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewMouseWheel(MouseWheelEventArgs) protected Invoked when an unhandled PreviewMouseWheel attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewQueryContinueDrag(QueryContinueDragEventArgs) protected Invoked when an unhandled PreviewQueryContinueDrag attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusButtonDown(StylusButtonEventArgs) protected Invoked when an unhandled PreviewStylusButtonDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusButtonUp(StylusButtonEventArgs) protected Invoked when an unhandled PreviewStylusButtonUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusDown(StylusDownEventArgs) protected Invoked when an unhandled PreviewStylusDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusInAirMove(StylusEventArgs) protected Invoked when an unhandled PreviewStylusInAirMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusInRange(StylusEventArgs) protected Invoked when an unhandled PreviewStylusInRange attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusMove(StylusEventArgs) protected Invoked when an unhandled PreviewStylusMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusOutOfRange(StylusEventArgs) protected Invoked when an unhandled PreviewStylusOutOfRange attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusSystemGesture(StylusSystemGestureEventArgs) protected Invoked when an unhandled PreviewStylusSystemGesture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewStylusUp(StylusEventArgs) protected Invoked when an unhandled PreviewStylusUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewTextInput(TextCompositionEventArgs) protected Invoked when an unhandled PreviewTextInput attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnPreviewTouchDown(TouchEventArgs) protected Provides class handling for the PreviewTouchDown routed event that occurs when a touch presses this element. Inherited from UIElement.
OnPreviewTouchMove(TouchEventArgs) protected Provides class handling for the PreviewTouchMove routed event that occurs when a touch moves while inside this element. Inherited from UIElement.
OnPreviewTouchUp(TouchEventArgs) protected Provides class handling for the PreviewTouchUp routed event that occurs when a touch is released inside this element. Inherited from UIElement.
OnQueryContinueDrag(QueryContinueDragEventArgs) protected Invoked when an unhandled QueryContinueDrag attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnQueryCursor(QueryCursorEventArgs) protected Invoked when an unhandled QueryCursor attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnRender(DrawingContext) protected When overridden in a derived class, participates in rendering operations that are directed by the layout system. The rendering instructions for this element are not used directly when this method is invoked, and are instead preserved for later asynchronous use by layout and drawing. Inherited from UIElement.
OnRenderSizeChanged(SizeChangedInfo) protected Raises the SizeChanged event, using the specified information as part of the eventual event data. Inherited from FrameworkElement.
OnStyleChanged(Style, Style) protected Invoked when the style in use on this element changes, which will invalidate the layout. Inherited from FrameworkElement.
OnStylusButtonDown(StylusButtonEventArgs) protected Invoked when an unhandled StylusButtonDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusButtonUp(StylusButtonEventArgs) protected Invoked when an unhandled StylusButtonUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusDown(StylusDownEventArgs) protected Invoked when an unhandled StylusDown attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusEnter(StylusEventArgs) protected Invoked when an unhandled StylusEnter attached event is raised by this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusInAirMove(StylusEventArgs) protected Invoked when an unhandled StylusInAirMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusInRange(StylusEventArgs) protected Invoked when an unhandled StylusInRange attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusLeave(StylusEventArgs) protected Invoked when an unhandled StylusLeave attached event is raised by this element. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusMove(StylusEventArgs) protected Invoked when an unhandled StylusMove attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusOutOfRange(StylusEventArgs) protected Invoked when an unhandled StylusOutOfRange attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusSystemGesture(StylusSystemGestureEventArgs) protected Invoked when an unhandled StylusSystemGesture attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnStylusUp(StylusEventArgs) protected Invoked when an unhandled StylusUp attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. Inherited from UIElement.
OnTemplateChanged(ControlTemplate, ControlTemplate) protected Called whenever the control’s template changes. Inherited from Control.
OnToolTipClosing(ToolTipEventArgs) protected Invoked whenever an unhandled ToolTipClosing routed event reaches this class in its route. Implement this method to add class handling for this event. Inherited from FrameworkElement.
OnToolTipOpening(ToolTipEventArgs) protected Invoked whenever the ToolTipOpening routed event reaches this class in its route. Implement this method to add class handling for this event. Inherited from FrameworkElement.
OnTouchDown(TouchEventArgs) protected Provides class handling for the TouchDown routed event that occurs when a touch presses inside this element. Inherited from UIElement.
OnTouchEnter(TouchEventArgs) protected Provides class handling for the TouchEnter routed event that occurs when a touch moves from outside to inside the bounds of this element. Inherited from UIElement.
OnTouchLeave(TouchEventArgs) protected Provides class handling for the TouchLeave routed event that occurs when a touch moves from inside to outside the bounds of this UIElement. Inherited from UIElement.
OnTouchMove(TouchEventArgs) protected Provides class handling for the TouchMove routed event that occurs when a touch moves while inside this element. Inherited from UIElement.
OnTouchUp(TouchEventArgs) protected Provides class handling for the TouchUp routed event that occurs when a touch is released inside this element. Inherited from UIElement.
OnVisualChildrenChanged(DependencyObject, DependencyObject) protected Called when the VisualCollection of the visual object is modified. Inherited from Visual.
OnVisualParentChanged(DependencyObject) protected Invoked when the parent of this element in the visual tree is changed. Overrides OnVisualParentChanged(DependencyObject). Inherited from FrameworkElement.
OpenCellEditor(CellEditorMode) Invokes a cell editor and switches to the spreadsheet edit mode, allowing you to edit cell content.
ParentLayoutInvalidated(UIElement) protected Supports incremental layout implementations in specialized subclasses of FrameworkElement. ParentLayoutInvalidated(UIElement) is invoked when a child element has invalidated a property that is marked in metadata as affecting the parent’s measure or arrange passes during layout. Inherited from FrameworkElement.
PointFromScreen(Point) Converts a Point in screen coordinates into a Point that represents the current coordinate system of the Visual. Inherited from Visual.
PointToScreen(Point) Converts a Point that represents the current coordinate system of the Visual into a Point in screen coordinates. Inherited from Visual.
PredictFocus(FocusNavigationDirection) Determines the next element that would receive focus relative to this element for a provided focus movement direction, but does not actually move the focus. Inherited from FrameworkElement.
Print() Prints the document to the default printer.
Print(PrinterSettings) Prints the document using the specified printer settings.
RaiseEvent(RoutedEventArgs) Raises a specific routed event. The RoutedEvent to be raised is identified within the RoutedEventArgs instance that is provided (as the RoutedEvent property of that event data). Inherited from UIElement.
ReadLocalValue(DependencyProperty) Returns the local value of a dependency property, if it exists. Inherited from DependencyObject.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
RegisterName(String, Object) Provides an accessor that simplifies access to the NameScope registration method. Inherited from FrameworkElement.
ReleaseAllTouchCaptures() Releases all captured touch devices from this element. Inherited from UIElement.
ReleaseMouseCapture() Releases the mouse capture, if this element held the capture. Inherited from UIElement.
ReleaseStylusCapture() Releases the stylus device capture, if this element held the capture. Inherited from UIElement.
ReleaseTouchCapture(TouchDevice) Attempts to release the specified touch device from this element. Inherited from UIElement.
RemoveHandler(RoutedEvent, Delegate) Removes the specified routed event handler from this element. Inherited from UIElement.
RemoveLogicalChild(Object) protected Removes the provided object from this element’s logical tree. FrameworkElement updates the affected logical tree parent pointers to keep in sync with this deletion. Inherited from FrameworkElement.
RemoveService(Type, Boolean) Removes the service of the specified type from the service container.
RemoveService(Type) Removes the service of the specified type from the service container.
RemoveShortcutKey(Keys, Keys) Removes a command shortcut.
RemoveVisualChild(Visual) protected Removes the parent-child relationship between two visuals. Inherited from Visual.
ReplaceService<T>(T) Performs a service substitution.
ResetLayout() Forces recalculation of the document layout.
SaveDocument() Saves a document to the original file location, and for a new document, the method invokes the Save As modal dialog box.
SaveDocument(DocumentFormat, EncryptionSettings) Saves a document to an array of bytes in the specified format and with specified encryption settings.
SaveDocument(DocumentFormat) Saves a document to an array of bytes in the specified format.
SaveDocument(Stream, DocumentFormat, EncryptionSettings) Saves the workbook to a stream, specifying the export format and encryption settings.
SaveDocument(Stream, DocumentFormat) Saves the workbook to a stream, specifying the export format.
SaveDocument(String, DocumentFormat, EncryptionSettings) Saves the control’s document to a file, specifying the document’s format and encryption settings.
SaveDocument(String, DocumentFormat) Saves the control’s document to a file, specifying the document’s format.
SaveDocument(String, EncryptionSettings) Saves the document to the specified file with the specified encryption settings. The file format is identified by the file extension.
SaveDocument(String) Saves the document to the specified file in the Excel or text format. The file format is identified by the file extension.
SaveDocument(IWin32Window) Saves a document to the original file location. For a new document, the method invokes the Save As modal dialog box with the specified owner.
SaveDocumentAs() Invokes the Save As modal dialog box and saves the document to the specified location in the specified format.
SaveDocumentAs(IWin32Window) Invokes the Save As modal dialog box and saves the document to the specified location in the specified format.
SetBinding(DependencyProperty, String) Attaches a binding to this element, based on the provided source property name as a path qualification to the data source. Inherited from FrameworkElement.
SetBinding(DependencyProperty, BindingBase) Attaches a binding to this element, based on the provided binding object. Inherited from FrameworkElement.
SetCurrentValue(DependencyProperty, Object) Sets the value of a dependency property without changing its value source. Inherited from DependencyObject.
SetFlowDirection(DependencyObject, FlowDirection) static Sets the value of the FlowDirection attached property for the provided element. Inherited from FrameworkElement.
SetResourceReference(DependencyProperty, Object) Searches for a resource with the specified name and sets up a resource reference to it for the specified property. Inherited from FrameworkElement.
SetSelectedRanges(IList<Range>, Boolean) Selects cell ranges in the worksheet and specifies whether the selection expands to fit merged cells.
SetSelectedRanges(IList<Range>) Selects multiple ranges in the active worksheet.
SetSelectedShapes(IList<Shape>) Select specified shapes in the active worksheet.
SetSpreadsheet(DependencyObject, SpreadsheetControl) static Sets the value of the SpreadsheetControl.Spreadsheet attached property for the specified object.
SetUseDefaultSvgImages(DependencyObject, SpreadsheetControl) static Sets the value of the SpreadsheetControl.UseDefaultSvgImages attached property for the specified object.
SetValue(DependencyProperty, Object) Sets the local value of a dependency property, specified by its dependency property identifier. Inherited from DependencyObject.
SetValue(DependencyPropertyKey, Object) Sets the local value of a read-only dependency property, specified by the DependencyPropertyKey identifier of the dependency property. Inherited from DependencyObject.
ShouldSerializeCommandBindings() Returns whether serialization processes should serialize the contents of the CommandBindings property on instances of this class. Inherited from UIElement.
ShouldSerializeInputBindings() Returns whether serialization processes should serialize the contents of the InputBindings property on instances of this class. Inherited from UIElement.
ShouldSerializeProperty(DependencyProperty) protected Returns a value that indicates whether serialization processes should serialize the value for the provided dependency property. Inherited from DependencyObject.
ShouldSerializeResources() Returns whether serialization processes should serialize the contents of the Resources property. Inherited from FrameworkElement.
ShouldSerializeStyle() Returns whether serialization processes should serialize the contents of the Style property. Inherited from FrameworkElement.
ShouldSerializeTriggers() Returns whether serialization processes should serialize the contents of the Triggers property. Inherited from FrameworkElement.
ShowPrintDialog() Invokes the Print dialog to select a printer, specify the print options (number of copies, page range, and paper source) and print the document.
ShowPrintPreview() Invokes the Print Preview window with a Bar UI.
ShowRibbonPrintPreview() Invokes the Print Preview window with a Ribbon UI.
IQueryAmbient.IsAmbientPropertyAvailable(String) For a description of this member, see the IsAmbientPropertyAvailable(String) method. Inherited from FrameworkElement.
ToString() Returns the string representation of a Control object. Inherited from Control.
TransformToAncestor(Visual3D) Returns a transform that can be used to transform coordinates from the Visual to the specified Visual3D ancestor of the visual object. Inherited from Visual.
TransformToAncestor(Visual) Returns a transform that can be used to transform coordinates from the Visual to the specified Visual ancestor of the visual object. Inherited from Visual.
TransformToDescendant(Visual) Returns a transform that can be used to transform coordinates from the Visual to the specified visual object descendant. Inherited from Visual.
TransformToVisual(Visual) Returns a transform that can be used to transform coordinates from the Visual to the specified visual object. Inherited from Visual.
TranslatePoint(Point, UIElement) Translates a point relative to this element to coordinates that are relative to the specified element. Inherited from UIElement.
TryFindResource(Object) Searches for a resource with the specified key, and returns that resource if found. Inherited from FrameworkElement.
UnregisterName(String) Simplifies access to the NameScope de-registration method. Inherited from FrameworkElement.
UpdateCommandUI() Refreshes the SpreadsheetControl Command UI.
UpdateDefaultStyle() Reapplies the default style to the current FrameworkElement. Inherited from FrameworkElement.
UpdateLayout() Ensures that all visual child elements of this element are properly updated for layout. Inherited from UIElement.
VerifyAccess() Enforces that the calling thread has access to this DispatcherObject. Inherited from DispatcherObject.

Events

Name Description
ActiveSheetChanged Occurs after an active worksheet in a workbook has been changed.
ActiveSheetChanging Occurs when an active worksheet in a workbook is about to be changed.
AfterDropRange Occurs after a user dropped the selected cell range in a new location.
AfterFillRange Occurs after a cell range was automatically filled with data based on values in the source range.
BeforeDispose Occurs before the SpreadsheetControl control is released from memory.
BeforeDragRange Occurs when a user starts to drag the selected cell range.
BeforeDropRange Occurs when a user is about to drop the selected cell range in a new location.
BeforeExport Occurs before the document is saved (exported to a certain format).
BeforeFillRange Occurs when a user drags the fill handle to populate cells with data based on values in the source range.
BeforeImport Occurs before a document is loaded (imported from an external source).
BeforePrintSheet Provides the capability to prevent printing of the required worksheets in a workbook.
CellBeginEdit Occurs before a cell editor is opened.
CellCancelEdit Occurs before the cell editor is closed and the entered value is rolled back.
CellEndEdit Occurs before a cell editor is closed.
CellValueChanged Occurs after a cell value has been changed.
ClipboardDataObtained Occurs after data on the clipboard is obtained and recognized, but before data is pasted.
ClipboardDataPasted Occurs after data was pasted from the clipboard onto a worksheet.
ClipboardDataPasting Occurs before data is pasted into destination cells.
ColumnsInserted Occurs after new columns have been inserted into a worksheet.
ColumnsInserting Occurs when new columns are about to be inserted into a worksheet.
ColumnsRemoved Occurs after columns have been deleted from a worksheet.
ColumnsRemoving Occurs when columns are about to be deleted from a worksheet.
CommentInserted Occurs when a comment is inserted.
CommentInserting Occurs before inserting a comment.
CommentRemoved Occurs when a comment is deleted.
CommentRemoving Occurs before deleting a comment.
ContentChanged Occurs when the document content was changed.
ContextMenuClosing Occurs just before any context menu on the element is closed. Inherited from FrameworkElement.
ContextMenuOpening Occurs when any context menu on the element is opened. Inherited from FrameworkElement.
CopiedRangePasted Occurs after the range content has been pasted into target cells.
CopiedRangePasting Occurs before the range content is pasted into target cells.
CustomAssemblyLoading Occurs before a custom assembly is loaded for use as the Entity Framework data source and allows canceling loading.
CustomCellEdit Allows you to assign a custom in-place editor to a cell.
DataBindingWarning Occurs before a data binding warning dialog is shown in the SpreadsheetControl.
DataContextChanged Occurs when the data context for this element changes. Inherited from FrameworkElement.
DefinedNameConflictResolving Occurs when a formula or sheet being moved or copied contains a defined name which already exists on the destination worksheet or workbook.
DefinedNameDeleting Occurs before a Defined Name is deleted.
DefinedNameEditing Occurs before a Defined Name is being edited.
DefinedNameValidating Occurs when a new Defined Name is created before it is added to a collection.
DocumentClosing Occurs when a document that has not yet been saved is about to be closed.
DocumentLoaded Occurs after a document is loaded into the Spreadsheet control.
DocumentPropertiesChanged Occurs after one of the DocumentProperties is changed.
DocumentSaved Occurs after a document has been saved.
DragEnter Occurs when the input system reports an underlying drag event with this element as the drag target. Inherited from UIElement.
DragLeave Occurs when the input system reports an underlying drag event with this element as the drag origin. Inherited from UIElement.
DragOver Occurs when the input system reports an underlying drag event with this element as the potential drop target. Inherited from UIElement.
Drop Occurs when the input system reports an underlying drop event with this element as the drop target. Inherited from UIElement.
EmptyDocumentCreated Occurs when a new document is created in the Spreadsheet control.
EncryptedFileIntegrityCheckFailed Occurs when the encrypted file did not pass the data integrity verification.
EncryptedFilePasswordCheckFailed Occurs when the encryption password is empty or invalid.
EncryptedFilePasswordRequest Occurs when the WorkbookImportOptions.Password property is not set or contains a wrong password.
FocusableChanged Occurs when the value of the Focusable property changes. Inherited from UIElement.
GiveFeedback Occurs when the input system reports an underlying drag-and-drop event that involves this element. Inherited from UIElement.
GotFocus Occurs when this element gets logical focus. Inherited from UIElement.
GotKeyboardFocus Occurs when the keyboard is focused on this element. Inherited from UIElement.
GotMouseCapture Occurs when this element captures the mouse. Inherited from UIElement.
GotStylusCapture Occurs when this element captures the stylus. Inherited from UIElement.
GotTouchCapture Occurs when a touch is captured to this element. Inherited from UIElement.
HyperlinkClick Occurs when an end-user clicks the hyperlink to activate it.
Initialized Occurs when this FrameworkElement is initialized. This event coincides with cases where the value of the IsInitialized property changes from false (or undefined) to true. Inherited from FrameworkElement.
InitializeDocument Occurs before a document is loaded. Handle this event to set initial document settings.
InvalidFormatException Fires when the supplied data could not be recognized as data in the assumed format for import.
IsEnabledChanged Occurs when the value of the IsEnabled property on this element changes. Inherited from UIElement.
IsHitTestVisibleChanged Occurs when the value of the IsHitTestVisible dependency property changes on this element. Inherited from UIElement.
IsKeyboardFocusedChanged Occurs when the value of the IsKeyboardFocused property changes on this element. Inherited from UIElement.
IsKeyboardFocusWithinChanged Occurs when the value of the IsKeyboardFocusWithin property changes on this element. Inherited from UIElement.
IsMouseCapturedChanged Occurs when the value of the IsMouseCaptured property changes on this element. Inherited from UIElement.
IsMouseCaptureWithinChanged Occurs when the value of the IsMouseCaptureWithinProperty changes on this element. Inherited from UIElement.
IsMouseDirectlyOverChanged Occurs when the value of the IsMouseDirectlyOver property changes on this element. Inherited from UIElement.
IsStylusCapturedChanged Occurs when the value of the IsStylusCaptured property changes on this element. Inherited from UIElement.
IsStylusCaptureWithinChanged Occurs when the value of the IsStylusCaptureWithin property changes on this element. Inherited from UIElement.
IsStylusDirectlyOverChanged Occurs when the value of the IsStylusDirectlyOver property changes on this element. Inherited from UIElement.
IsVisibleChanged Occurs when the value of the IsVisible property changes on this element. Inherited from UIElement.
KeyDown Occurs when a key is pressed while focus is on this element. Inherited from UIElement.
KeyUp Occurs when a key is released while focus is on this element. Inherited from UIElement.
LayoutUpdated Occurs when the layout of the various visual elements associated with the current Dispatcher changes. Inherited from UIElement.
Loaded Occurs when the element is laid out, rendered, and ready for interaction. Inherited from FrameworkElement.
LostFocus Occurs when this element loses logical focus. Inherited from UIElement.
LostKeyboardFocus Occurs when the keyboard is no longer focused on this element. Inherited from UIElement.
LostMouseCapture Occurs when this element loses mouse capture. Inherited from UIElement.
LostStylusCapture Occurs when this element loses stylus capture. Inherited from UIElement.
LostTouchCapture Occurs when this element loses a touch capture. Inherited from UIElement.
ManipulationBoundaryFeedback Occurs when the manipulation encounters a boundary. Inherited from UIElement.
ManipulationCompleted Occurs when a manipulation and inertia on the UIElement object is complete. Inherited from UIElement.
ManipulationDelta Occurs when the input device changes position during a manipulation. Inherited from UIElement.
ManipulationInertiaStarting Occurs when the input device loses contact with the UIElement object during a manipulation and inertia begins. Inherited from UIElement.
ManipulationStarted Occurs when an input device begins a manipulation on the UIElement object. Inherited from UIElement.
ManipulationStarting Occurs when the manipulation processor is first created. Inherited from UIElement.
ModifiedChanged Occurs when the value of the SpreadsheetControl.Modified property is changed.
MouseDoubleClick Occurs when a mouse button is clicked two or more times. Inherited from Control.
MouseDown Occurs when any mouse button is pressed while the pointer is over this element. Inherited from UIElement.
MouseEnter Occurs when the mouse pointer enters the bounds of this element. Inherited from UIElement.
MouseLeave Occurs when the mouse pointer leaves the bounds of this element. Inherited from UIElement.
MouseLeftButtonDown Occurs when the left mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement.
MouseLeftButtonUp Occurs when the left mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
MouseMove Occurs when the mouse pointer moves while over this element. Inherited from UIElement.
MouseRightButtonDown Occurs when the right mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement.
MouseRightButtonUp Occurs when the right mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
MouseUp Occurs when any mouse button is released over this element. Inherited from UIElement.
MouseWheel Occurs when the user rotates the mouse wheel while the mouse pointer is over this element. Inherited from UIElement.
PanesFrozen Occurs when freezing a worksheet area via the control’s UI.
PanesUnfrozen Occurs when unfreezing a locked (frozen) worksheet area via the SpreadsheetControl UI.
PopupMenuShowing Occurs before a popup menu is created for the control’s document whenever a context menu is being invoked.
PreviewDragEnter Occurs when the input system reports an underlying drag event with this element as the drag target. Inherited from UIElement.
PreviewDragLeave Occurs when the input system reports an underlying drag event with this element as the drag origin. Inherited from UIElement.
PreviewDragOver Occurs when the input system reports an underlying drag event with this element as the potential drop target. Inherited from UIElement.
PreviewDrop Occurs when the input system reports an underlying drop event with this element as the drop target. Inherited from UIElement.
PreviewGiveFeedback Occurs when a drag-and-drop operation is started. Inherited from UIElement.
PreviewGotKeyboardFocus Occurs when the keyboard is focused on this element. Inherited from UIElement.
PreviewKeyDown Occurs when a key is pressed while focus is on this element. Inherited from UIElement.
PreviewKeyUp Occurs when a key is released while focus is on this element. Inherited from UIElement.
PreviewLostKeyboardFocus Occurs when the keyboard is no longer focused on this element. Inherited from UIElement.
PreviewMouseDoubleClick Occurs when a user clicks the mouse button two or more times. Inherited from Control.
PreviewMouseDown Occurs when any mouse button is pressed while the pointer is over this element. Inherited from UIElement.
PreviewMouseLeftButtonDown Occurs when the left mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseLeftButtonUp Occurs when the left mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseMove Occurs when the mouse pointer moves while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseRightButtonDown Occurs when the right mouse button is pressed while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseRightButtonUp Occurs when the right mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseUp Occurs when any mouse button is released while the mouse pointer is over this element. Inherited from UIElement.
PreviewMouseWheel Occurs when the user rotates the mouse wheel while the mouse pointer is over this element. Inherited from UIElement.
PreviewQueryContinueDrag Occurs when there is a change in the keyboard or mouse button state during a drag-and-drop operation. Inherited from UIElement.
PreviewStylusButtonDown Occurs when the stylus button is pressed while the pointer is over this element. Inherited from UIElement.
PreviewStylusButtonUp Occurs when the stylus button is released while the pointer is over this element. Inherited from UIElement.
PreviewStylusDown Occurs when the stylus touches the digitizer while it is over this element. Inherited from UIElement.
PreviewStylusInAirMove Occurs when the stylus moves over an element without actually touching the digitizer. Inherited from UIElement.
PreviewStylusInRange Occurs when the stylus is close enough to the digitizer to be detected, while over this element. Inherited from UIElement.
PreviewStylusMove Occurs when the stylus moves while over the element. The stylus must move while being detected by the digitizer to raise this event, otherwise, PreviewStylusInAirMove is raised instead. Inherited from UIElement.
PreviewStylusOutOfRange Occurs when the stylus is too far from the digitizer to be detected. Inherited from UIElement.
PreviewStylusSystemGesture Occurs when a user performs one of several stylus gestures. Inherited from UIElement.
PreviewStylusUp Occurs when the user raises the stylus off the digitizer while the stylus is over this element. Inherited from UIElement.
PreviewTextInput Occurs when this element gets text in a device-independent manner. Inherited from UIElement.
PreviewTouchDown Occurs when a finger touches the screen while the finger is over this element. Inherited from UIElement.
PreviewTouchMove Occurs when a finger moves on the screen while the finger is over this element. Inherited from UIElement.
PreviewTouchUp Occurs when a finger is raised off of the screen while the finger is over this element. Inherited from UIElement.
PropertyChanged Occurs every time any of the SpreadsheetControl class properties has changed its value.
ProtectionWarning Occurs when attempting to edit a locked cell in a protected worksheet.
QueryContinueDrag Occurs when there is a change in the keyboard or mouse button state during a drag-and-drop operation. Inherited from UIElement.
QueryCursor Occurs when the cursor is requested to display. This event is raised on an element each time that the mouse pointer moves to a new location, which means the cursor object might need to be changed based on its new position. Inherited from UIElement.
RangeCopied Occurs after the range content has been copied.
RangeCopying Occurs before a cell range is copied in a worksheet.
ReadOnlyChanged Occurs when the read-only state of the SpreadsheetControl control is changed.
RequestBringIntoView Occurs when BringIntoView(Rect) is called on this element. Inherited from FrameworkElement.
RowsInserted Occurs after new rows have been added to a worksheet.
RowsInserting Occurs when new rows are about to be inserted into a worksheet.
RowsRemoved Occurs after rows have been deleted from a worksheet.
RowsRemoving Occurs when rows are about to be deleted from a worksheet.
ScrollPositionChanged Occurs when a worksheet is being scrolled in the SpreadsheetControl‘s UI.
SelectionChanged Fires when the selection changes in an active worksheet.
ShapeInserted Occurs after a drawing object has been inserted into a worksheet.
ShapeRemoved Occurs after a drawing object has been removed from a worksheet.
ShapeRemoving Occurs before a drawing object is removed from a worksheet.
ShapesCopying Occurs before a drawing object is copied in a worksheet.
SheetInserted Occurs after a new worksheet has been added to a workbook.
SheetRemoved Occurs after a worksheet has been removed from a workbook.
SheetRemoving Occurs when a worksheet is about to be removed from a workbook.
SheetRenamed Occurs after a worksheet has been renamed.
SheetRenaming Occurs when a worksheet is about to be renamed.
SizeChanged Occurs when either the ActualHeight or the ActualWidth properties change value on this element. Inherited from FrameworkElement.
SourceUpdated Occurs when the source value changes for any existing property binding on this element. Inherited from FrameworkElement.
StylusButtonDown Occurs when the stylus button is pressed while the pointer is over this element. Inherited from UIElement.
StylusButtonUp Occurs when the stylus button is released while the pointer is over this element. Inherited from UIElement.
StylusDown Occurs when the stylus touches the digitizer while the stylus is over this element. Inherited from UIElement.
StylusEnter Occurs when the stylus enters the bounds of this element. Inherited from UIElement.
StylusInAirMove Occurs when the stylus moves over an element without actually touching the digitizer. Inherited from UIElement.
StylusInRange Occurs when the stylus is close enough to the digitizer to be detected, while over this element. Inherited from UIElement.
StylusLeave Occurs when the stylus leaves the bounds of the element. Inherited from UIElement.
StylusMove Occurs when the stylus moves over this element. The stylus must move while on the digitizer to raise this event. Otherwise, StylusInAirMove is raised instead. Inherited from UIElement.
StylusOutOfRange Occurs when the stylus is too far from the digitizer to be detected, while over this element. Inherited from UIElement.
StylusSystemGesture Occurs when a user performs one of several stylus gestures. Inherited from UIElement.
StylusUp Occurs when the user raises the stylus off the digitizer while it is over this element. Inherited from UIElement.
TargetUpdated Occurs when the target value changes for any property binding on this element. Inherited from FrameworkElement.
TextInput Occurs when this element gets text in a device-independent manner. Inherited from UIElement.
ToolTipClosing Occurs just before any tooltip on the element is closed. Inherited from FrameworkElement.
ToolTipOpening Occurs when any tooltip on the element is opened. Inherited from FrameworkElement.
TouchDown Occurs when a finger touches the screen while the finger is over this element. Inherited from UIElement.
TouchEnter Occurs when a touch moves from outside to inside the bounds of this element. Inherited from UIElement.
TouchLeave Occurs when a touch moves from inside to outside the bounds of this element. Inherited from UIElement.
TouchMove Occurs when a finger moves on the screen while the finger is over this element. Inherited from UIElement.
TouchUp Occurs when a finger is raised off of the screen while the finger is over this element. Inherited from UIElement.
UnhandledException This event is raised when an exception unhandled by the SpreadsheetControl occurs.
UnitChanged Fires after the SpreadsheetControl.Unit property is changed.
UnitChanging Fires before the SpreadsheetControl.Unit property is changed.
Unloaded Occurs when the element is removed from within an element tree of loaded elements. Inherited from FrameworkElement.
UpdateUI Raised when changes occur which may affect the control’s UI.
VisibleRangeChanged
ZoomChanged Occurs when the current zoom level has been changed.

Attached Properties

Name Description
Spreadsheet static Gets or sets the SpreadsheetControl object to which a child element belongs. This is an attached property.
UseDefaultSvgImages static Gets or sets whether to use bitmap or vector icons for the SpreadsheetControl UI. This is a dependency property.
See Also