| Name | Description | |
|---|---|---|
 | AccessKey | (Inherited from Windows.UI.Xaml.UIElement) |
| AccessKeyScopeOwner | (Inherited from Windows.UI.Xaml.UIElement) |
| ActualHeight | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| ActualWidth | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| AllowDrop | (Inherited from Windows.UI.Xaml.UIElement) |
| AllowFocusOnInteraction | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| AllowFocusWhenDisabled | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| AutoClipboard | Gets or sets whether the component handles the shortcut keys for Clipboard actions. |
| Background | (Inherited from Windows.UI.Xaml.Controls.Panel) |
| BaseUri | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| CacheMode | (Inherited from Windows.UI.Xaml.UIElement) |
| CanCellOverflow | Gets or sets whether data can overflow into adjacent empty cells in the component. |
| CanDrag | (Inherited from Windows.UI.Xaml.UIElement) |
| CanEditOverflow | Gets or sets whether data can overflow into adjacent empty cells in the component while the cell is in edit mode. |
| CanSelectFormula | Gets a value that indicates whether the user is editing a formula. |
| CanTouchMultiSelect | Indicates whether the user can select multiple ranges by touch. |
| CanUserDragDrop | Gets or sets whether to allow users to drag and drop a range. |
| CanUserDragFill | Gets or sets whether to allow users to drag and fill a range. |
| CanUserEditFormula | Gets or sets whether to allow the user to enter formulas in a cell in the component. |
| CanUserUndo | Gets or sets whether to allow the user to undo edit operations. |
| CanUserZoom | Gets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel. |
| CellEditor | Gets the cell editor control on the editing viewport. |
| CellEditorStatus | Gets the cell editor status. |
| Children | (Inherited from Windows.UI.Xaml.Controls.Panel) |
| ChildrenTransitions | (Inherited from Windows.UI.Xaml.Controls.Panel) |
| Clip | (Inherited from Windows.UI.Xaml.UIElement) |
| ClipBoardOptions | Gets or sets whether the component handles the shortcut keys for Clipboard actions. |
| CompositeMode | (Inherited from Windows.UI.Xaml.UIElement) |
| ContextFlyout | (Inherited from Windows.UI.Xaml.UIElement) |
| DataContext | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| DefaultAutoFillType | Gets or sets the default type of the automatic fill. |
| DesiredSize | (Inherited from Windows.UI.Xaml.UIElement) |
| Dispatcher | (Inherited from Windows.UI.Xaml.DependencyObject) |
| EditorInfo | Gets the information of the editor when the sheetview enters the formula selection mode. |
| ExitDisplayModeOnAccessKeyInvoked | (Inherited from Windows.UI.Xaml.UIElement) |
| FlowDirection | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| FocusVisualMargin | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| FocusVisualPrimaryBrush | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| FocusVisualPrimaryThickness | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| FocusVisualSecondaryBrush | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| FocusVisualSecondaryThickness | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| Height | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| HighContrastAdjustment | (Inherited from Windows.UI.Xaml.UIElement) |
| HighlightInvalidData | Gets or sets whether to highlight invalid data. |
| HorizontalAlignment | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| HorizontalScrollable | Gets or sets a value that indicates whether the horizontal scroll bar is scrollable. |
| InputDeviceType | Returns the last input device type. |
| IsAccessKeyScope | (Inherited from Windows.UI.Xaml.UIElement) |
| IsCellEditing | Gets a value that indicates whether there is a cell in edit mode. |
| IsDoubleTapEnabled | (Inherited from Windows.UI.Xaml.UIElement) |
| IsHitTestVisible | (Inherited from Windows.UI.Xaml.UIElement) |
| IsHoldingEnabled | (Inherited from Windows.UI.Xaml.UIElement) |
| IsItemsHost | (Inherited from Windows.UI.Xaml.Controls.Panel) |
| IsRightTapEnabled | (Inherited from Windows.UI.Xaml.UIElement) |
| IsTapEnabled | (Inherited from Windows.UI.Xaml.UIElement) |
| KeyMap | Gets the key map collection that contains associated keys and actions. |
| KeyTipHorizontalOffset | (Inherited from Windows.UI.Xaml.UIElement) |
| KeyTipPlacementMode | (Inherited from Windows.UI.Xaml.UIElement) |
| KeyTipVerticalOffset | (Inherited from Windows.UI.Xaml.UIElement) |
| Language | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| Lights | (Inherited from Windows.UI.Xaml.UIElement) |
| ManipulationMode | (Inherited from Windows.UI.Xaml.UIElement) |
| Margin | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| MaxHeight | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| MaxWidth | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| MinHeight | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| MinWidth | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| Name | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| Opacity | (Inherited from Windows.UI.Xaml.UIElement) |
| Parent | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| PointerCaptures | (Inherited from Windows.UI.Xaml.UIElement) |
| Projection | (Inherited from Windows.UI.Xaml.UIElement) |
| RangeGroupBackground | Gets or sets the backgroud of the range group |
| RangeGroupBorderBrush | Gets or sets the brush of the border of the range group |
| RangeGroupLineStroke | Gets or sets the stroke of the group line |
| RenderSize | (Inherited from Windows.UI.Xaml.UIElement) |
| RenderTransform | (Inherited from Windows.UI.Xaml.UIElement) |
| RenderTransformOrigin | (Inherited from Windows.UI.Xaml.UIElement) |
| RequestedTheme | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| ResizeZeroIndicator | Specifies the drawing policy when the row or column is resized to zero. |
| Resources | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| ShowColumnRangeGroup | Gets or sets whether the column range group is visible. |
| ShowDragDropTip | Gets or sets a value that indicates whether to show the drag drop tip. |
| ShowDragFillTip | Gets or sets a value that indicates whether to show a drag fill tip. |
| ShowFreezeLine | Gets or sets a value that indicates whether to show the freeze line. |
| ShowResizeTip | Gets or sets how to display the resize tip. |
| ShowRowRangeGroup | Gets or sets whether the row range group is visible. |
| ShowScrollTip | Gets or sets how to display the scroll tip. |
| Style | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| TabFocusNavigation | (Inherited from Windows.UI.Xaml.UIElement) |
| Tag | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| Transform3D | (Inherited from Windows.UI.Xaml.UIElement) |
| Transitions | (Inherited from Windows.UI.Xaml.UIElement) |
| Triggers | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| UndoManager | Gets the undo manager for the control. |
| UseFormatterForEditing | Specifies whether to edit a cell's value using the formatter. |
| UseLayoutRounding | (Inherited from Windows.UI.Xaml.UIElement) |
| ValidateForPasting | Specifies whether to validate value when pasting. |
| VerticalAlignment | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| VerticalScrollable | Gets or sets a value that indicates whether the vertical scroll bar is scrollable. |
| Visibility | (Inherited from Windows.UI.Xaml.UIElement) |
| Width | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| Worksheet | Gets the worksheet associated with the view. |
| XYFocusDownNavigationStrategy | (Inherited from Windows.UI.Xaml.UIElement) |
| XYFocusKeyboardNavigation | (Inherited from Windows.UI.Xaml.UIElement) |
| XYFocusLeftNavigationStrategy | (Inherited from Windows.UI.Xaml.UIElement) |
| XYFocusRightNavigationStrategy | (Inherited from Windows.UI.Xaml.UIElement) |
| XYFocusUpNavigationStrategy | (Inherited from Windows.UI.Xaml.UIElement) |
| ZoomFactor | Gets or sets the scaling factor for displaying this sheet. |
The following tables list the members exposed by SheetView.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | AddHandler | (Inherited from Windows.UI.Xaml.UIElement) |
| AddSelection | Adds a cell or cells to the selection. |
| AdjustColumnViewport | Adjusts the adjacent column viewport's width. |
| AdjustRowViewport | Adjusts the adjacent row viewport's height. |
| Arrange | (Inherited from Windows.UI.Xaml.UIElement) |
| AutoFitColumn | Overloaded. Automatically fits the viewport column. |
| AutoFitRow | Overloaded. Automatically fits the viewport row. |
| BeginFormulaSelection | Enters a state where the user can select formulas with the mouse or keyboard. |
| CancelDirectManipulations | (Inherited from Windows.UI.Xaml.UIElement) |
| CapturePointer | (Inherited from Windows.UI.Xaml.UIElement) |
| ClearUndoManager | Clears all undo and redo actions in the current UndoManager. |
| ClearValue | (Inherited from Windows.UI.Xaml.DependencyObject) |
| ClipboardCopy | Copies the text of a cell range to the Clipboard. |
| ClipboardCut | Cuts the text of a cell range to the Clipboard. |
| ClipboardPaste | Overloaded. Pastes content from the Clipboard to a cell range on the sheet. |
| CreateObjRef | (Inherited from System.MarshalByRefObject) |
| EndFormulaSelection | Exits the state where the user can select formulas with the mouse or keyboard. |
| Equals | (Inherited from System.Runtime.InteropServices.WindowsRuntime.RuntimeClass) |
| ExtendSelection | Specifies the last cell in the cell selection. |
| FindName | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| GetAnimationBaseValue | (Inherited from Windows.UI.Xaml.DependencyObject) |
| GetBindingExpression | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| GetFloatingObjectZIndex | Gets the index of the floating object Z. |
| GetHashCode | (Inherited from System.Runtime.InteropServices.WindowsRuntime.RuntimeClass) |
| GetLifetimeService | (Inherited from System.MarshalByRefObject) |
| GetNextPageColumnCount | Gets the column count when scrolling right one page. |
| GetNextPageRowCount | Gets the row count when scrolling down one page. |
| GetPrePageColumnCount | Gets the column count when scrolling left one page. |
| GetPrePageRowCount | Gets the row count when scrolling up one page. |
| GetSpreadChartView | Ges the spread chart view. |
| GetValue | (Inherited from Windows.UI.Xaml.DependencyObject) |
| GetViewportBottomRow | Gets the row viewport's bottom row index. |
| GetViewportLeftColumn | Gets the column viewport's left column index. |
| GetViewportRightColumn | Gets the column viewport's right column index. |
| GetViewportTopRow | Gets the row viewport's top row index. |
| InitializeLifetimeService | (Inherited from System.MarshalByRefObject) |
| Invalidate | Invalidates the measurement state (layout) and the arranged state (layout) for the control. The view layout and data is updated after the invalidation. |
| InvalidateArrange | (Inherited from Windows.UI.Xaml.UIElement) |
| InvalidateCharts | Overloaded. Invalidates the charts. |
| InvalidateColumns | Invalidates the column state in the control; the column layout and data is updated after the invalidation. |
| InvalidateCustomFloatingObjects | Overloaded. Invalidates the custom floating objects. |
| InvalidateFloatingObjects | Overloaded. Invalidates the charts. |
| InvalidateMeasure | (Inherited from Windows.UI.Xaml.UIElement) |
| InvalidatePictures | Overloaded. Invalidates the pictures. |
| InvalidateRange | Invalidates a range state in the control; the range layout and data is updated after the invalidation. |
| InvalidateRows | Invalidates the row state in the control; the row layout and data is updated after the invalidation. |
| Measure | (Inherited from Windows.UI.Xaml.UIElement) |
| ReadLocalValue | (Inherited from Windows.UI.Xaml.DependencyObject) |
| RegisterPropertyChangedCallback | (Inherited from Windows.UI.Xaml.DependencyObject) |
| ReleasePointerCapture | (Inherited from Windows.UI.Xaml.UIElement) |
| ReleasePointerCaptures | (Inherited from Windows.UI.Xaml.UIElement) |
| RemoveHandler | (Inherited from Windows.UI.Xaml.UIElement) |
| ResumeEvent | Resumes the events. |
| SetActiveCell | Sets the active cell of the sheet. |
| SetBinding | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| SetFloatingObjectZIndex | Sets the index of the floating object Z. |
| SetSelection | Selects the specified cells. |
| SetValue | (Inherited from Windows.UI.Xaml.DependencyObject) |
| SetViewportLeftColumn | Overloaded. Sets the active column viewport's left column. |
| SetViewportTopRow | Overloaded. Sets the active row viewport's top row. |
| ShowAutoFillIndicator | Displays the automatic fill indicator. |
| StartBringIntoView | Overloaded. (Inherited from Windows.UI.Xaml.UIElement) |
| StartCellEditing | Starts to edit the active cell. |
| StartDragAsync | (Inherited from Windows.UI.Xaml.UIElement) |
| StopCellEditing | Stops editing the active cell. |
| SuspendEvent | Suspends all events. |
| ToString | (Inherited from System.Runtime.InteropServices.WindowsRuntime.RuntimeClass) |
| TransformToVisual | (Inherited from Windows.UI.Xaml.UIElement) |
| UnregisterPropertyChangedCallback | (Inherited from Windows.UI.Xaml.DependencyObject) |
| UpdateLayout | (Inherited from Windows.UI.Xaml.UIElement) |
Protected Methods
| Name | Description | |
|---|---|---|
 | ArrangeOverride | Overridden. Positions child elements and determines a size for a System.Windows.FrameworkElement derived class, when overridden in a derived class. |
| FindSubElementsForTouchTargeting | (Inherited from Windows.UI.Xaml.UIElement) |
| GoToElementStateCore | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| MeasureOverride | Overridden. This method measures the layout size required for child elements and determines a size for the System.Windows.FrameworkElement-derived class, when overridden in a derived class. |
| MemberwiseClone | Overloaded. (Inherited from System.MarshalByRefObject) |
| OnApplyTemplate | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| OnCreateAutomationPeer | (Inherited from Windows.UI.Xaml.UIElement) |
| OnDisconnectVisualChildren | (Inherited from Windows.UI.Xaml.UIElement) |
| UpdateTouchHitTestInfo | |
| UpdateTouchHitTestInfoForHold |
Public Events
| Name | Description | |
|---|---|---|
 | AccessKeyDisplayDismissed | (Inherited from Windows.UI.Xaml.UIElement) |
| AccessKeyDisplayRequested | (Inherited from Windows.UI.Xaml.UIElement) |
| AccessKeyInvoked | (Inherited from Windows.UI.Xaml.UIElement) |
| CellClick | Occurs when the user presses down the left mouse button in a cell. |
| CellDoubleClick | Occurs when the user presses down the left mouse button twice (double-clicks) in a cell. |
| CellTextRendering | Occurs when [cell text rendering]. |
| CellValueApplying | Occurs when [cell value applying]. |
| ClipboardChanged | Occurs when a Clipboard change occurs that affects GcSpreadSheet. |
| ClipboardChanging | Occurs when the Clipboard is changing due to a GcSpreadSheet action. |
| ClipboardPasted | Occurs when the user has pasted from the Clipboard. |
| ClipboardPasting | Occurs when the user pastes from the Clipboard. |
| ColumnWidthChanged | Occurs when the column width has changed. |
| ColumnWidthChanging | Occurs when the column width is changing. |
| ContextCanceled | (Inherited from Windows.UI.Xaml.UIElement) |
| ContextRequested | (Inherited from Windows.UI.Xaml.UIElement) |
| DataContextChanged | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| DataValidationListPopupOpening | Occurs when [data validation list popup opening]. |
| DoubleTapped | (Inherited from Windows.UI.Xaml.UIElement) |
| DragDropBlock | Occurs when the user drags and drops a range of cells. |
| DragDropBlockCompleted | Occurs at the completion of the user dragging and dropping a range of cells. |
| DragEnter | (Inherited from Windows.UI.Xaml.UIElement) |
| DragFillBlock | Occurs when the user drags to fill a range of cells. |
| DragFillBlockCompleted | Occurs at the completion of the user dragging to fill a range of cells. |
| DragLeave | (Inherited from Windows.UI.Xaml.UIElement) |
| DragOver | (Inherited from Windows.UI.Xaml.UIElement) |
| DragStarting | (Inherited from Windows.UI.Xaml.UIElement) |
| Drop | (Inherited from Windows.UI.Xaml.UIElement) |
| DropCompleted | (Inherited from Windows.UI.Xaml.UIElement) |
| EditChange | Occurs when a cell is in edit mode and the text is changed. |
| EditEnd | Occurs when a cell leaves edit mode. |
| EditStarting | Occurs when a cell is going in to edit mode. |
| EnterCell | Occurs when the user enters a cell. |
| FilterPopupOpening | Occurs when [filter popup opening]. |
| FloatingObjectPasted | Occurs when [floating object pasted]. |
| GettingFocus | (Inherited from Windows.UI.Xaml.UIElement) |
| GotFocus | (Inherited from Windows.UI.Xaml.UIElement) |
| Holding | (Inherited from Windows.UI.Xaml.UIElement) |
| InvalidOperation | Occurs when an invalid operation is performed. |
| KeyDown | (Inherited from Windows.UI.Xaml.UIElement) |
| KeyUp | (Inherited from Windows.UI.Xaml.UIElement) |
| LayoutUpdated | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| LeaveCell | Occurs when the user leaves a cell. |
| LeftColumnChanged | Occurs when the left column changes. |
| Loaded | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| Loading | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| LosingFocus | (Inherited from Windows.UI.Xaml.UIElement) |
| LostFocus | (Inherited from Windows.UI.Xaml.UIElement) |
| ManipulationCompleted | (Inherited from Windows.UI.Xaml.UIElement) |
| ManipulationDelta | (Inherited from Windows.UI.Xaml.UIElement) |
| ManipulationInertiaStarting | (Inherited from Windows.UI.Xaml.UIElement) |
| ManipulationStarted | (Inherited from Windows.UI.Xaml.UIElement) |
| ManipulationStarting | (Inherited from Windows.UI.Xaml.UIElement) |
| NoFocusCandidateFound | (Inherited from Windows.UI.Xaml.UIElement) |
| PointerCanceled | (Inherited from Windows.UI.Xaml.UIElement) |
| PointerCaptureLost | (Inherited from Windows.UI.Xaml.UIElement) |
| PointerEntered | (Inherited from Windows.UI.Xaml.UIElement) |
| PointerExited | (Inherited from Windows.UI.Xaml.UIElement) |
| PointerMoved | (Inherited from Windows.UI.Xaml.UIElement) |
| PointerPressed | (Inherited from Windows.UI.Xaml.UIElement) |
| PointerReleased | (Inherited from Windows.UI.Xaml.UIElement) |
| PointerWheelChanged | (Inherited from Windows.UI.Xaml.UIElement) |
| RangeFiltered | Occurs when a column has just been automatically sorted. |
| RangeFiltering | Occurs when a column is about to be automatically filtered. |
| RangeGroupStateChanged | Occurs when the user has changed the state of outline (range group) rows or columns. |
| RangeGroupStateChanging | Occurs before the user changes the state of outline (range group) rows or columns. |
| RangeSorted | Occurs when a column has just been automatically sorted. |
| RangeSorting | Occurs when a column is about to be automatically sorted. |
| RightTapped | (Inherited from Windows.UI.Xaml.UIElement) |
| RowHeightChanged | Occurs when the row height has changed. |
| RowHeightChanging | Occurs when the row height is changing. |
| SelectionChanged | Occurs when the selection of cells on the sheet has changed. |
| SelectionChanging | Occurs when the selection of cells on the sheet is changing. |
| SheetTabClick | Occurs when the user clicks the sheet tab. |
| SheetTabDoubleClick | Occurs when the user double-clicks the sheet tab. |
| SizeChanged | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| Tapped | (Inherited from Windows.UI.Xaml.UIElement) |
| TopRowChanged | Occurs when the top row changes. |
| Unloaded | (Inherited from Windows.UI.Xaml.FrameworkElement) |
| UserFormulaEntered | Occurs when the user types a formula. |
| UserZooming | Occurs when the user zooms. |
| ValidationDragDropBlock | Occurs when the user drags and drops a range of cells. |
| ValidationError | Occurs when the applied cell value is invalid. |
| ValidationPasting | Occurs when validation the whether the pasting is validate. |
| ValueChanged | Occurs when the value in the subeditor changes. |
See Also