GrapeCity.Xaml.SpreadSheet.UI
SheetView Class Members
Properties  Methods  Events


The following tables list the members exposed by SheetView.

Public Properties
 NameDescription
Public PropertyActualHeight (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyActualWidth (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyAllowDrop (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyAutoClipboard Gets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public PropertyBackground (Inherited from Windows.UI.Xaml.Controls.Panel)
Public PropertyBaseUri (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyCacheMode (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyCanCellOverflow Gets or sets whether data can overflow into adjacent empty cells in the component.  
Public PropertyCanEditOverflow Gets or sets whether data can overflow into adjacent empty cells in the component while the cell is in edit mode.  
Public PropertyCanSelectFormula Gets a value that indicates whether the user is editing a formula.  
Public PropertyCanTouchMultiSelect Indicates whether the user can select multiple ranges by touch.  
Public PropertyCanUserDragDrop Gets or sets whether to allow users to drag and drop a range.  
Public PropertyCanUserDragFill Gets or sets whether to allow users to drag and fill a range.  
Public PropertyCanUserEditFormula Gets or sets whether to allow the user to enter formulas in a cell in the component.  
Public PropertyCanUserUndo Gets or sets whether to allow the user to undo edit operations.  
Public PropertyCanUserZoom Gets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.  
Public PropertyCellEditor Gets the cell editor control on the editing viewport.  
Public PropertyCellEditorStatus Gets the cell editor status.  
Public PropertyChildren (Inherited from Windows.UI.Xaml.Controls.Panel)
Public PropertyChildrenTransitions (Inherited from Windows.UI.Xaml.Controls.Panel)
Public PropertyClip (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyClipBoardOptions Gets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public PropertyDataContext (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyDefaultAutoFillType Gets or sets the default type of the automatic fill.  
Public PropertyDesiredSize (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyDispatcher (Inherited from Windows.UI.Xaml.DependencyObject)
Public PropertyEditorInfo Gets the information of the editor when the sheetview enters the formula selection mode.  
Public PropertyFlowDirection (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyHeight (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyHighlightInvalidData Gets or sets whether to highlight invalid data.  
Public PropertyHorizontalAlignment (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyHorizontalScrollable Gets or sets a value that indicates whether the horizontal scroll bar is scrollable.  
Public PropertyInputDeviceType Returns the last input device type.  
Public PropertyIsCellEditing Gets a value that indicates whether there is a cell in edit mode.  
Public PropertyIsDoubleTapEnabled (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyIsHitTestVisible (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyIsHoldingEnabled (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyIsItemsHost (Inherited from Windows.UI.Xaml.Controls.Panel)
Public PropertyIsRightTapEnabled (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyIsTapEnabled (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyKeyMap Gets the key map collection that contains associated keys and actions.  
Public PropertyLanguage (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyManipulationMode (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyMargin (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyMaxHeight (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyMaxWidth (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyMinHeight (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyMinWidth (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyName (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyOpacity (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyParent (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyPointerCaptures (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyProjection (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyRangeGroupBackground Gets or sets the backgroud of the range group  
Public PropertyRangeGroupBorderBrush Gets or sets the brush of the border of the range group  
Public PropertyRangeGroupLineStroke Gets or sets the stroke of the group line  
Public PropertyRenderSize (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyRenderTransform (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyRenderTransformOrigin (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyResizeZeroIndicator Specifies the drawing policy when the row or column is resized to zero.  
Public PropertyResources (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyShowColumnRangeGroup Gets or sets whether the column range group is visible.  
Public PropertyShowDragDropTip Gets or sets a value that indicates whether to show the drag drop tip.  
Public PropertyShowDragFillTip Gets or sets a value that indicates whether to show a drag fill tip.  
Public PropertyShowFreezeLine Gets or sets a value that indicates whether to show the freeze line.  
Public PropertyShowResizeTip Gets or sets how to display the resize tip.  
Public PropertyShowRowRangeGroup Gets or sets whether the row range group is visible.  
Public PropertyShowScrollTip Gets or sets how to display the scroll tip.  
Public PropertyStyle (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyTag (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyTransitions (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyTriggers (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyUndoManager Gets the undo manager for the control.  
Public PropertyUseLayoutRounding (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyVerticalAlignment (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyVerticalScrollable Gets or sets a value that indicates whether the vertical scroll bar is scrollable.  
Public PropertyVisibility (Inherited from Windows.UI.Xaml.UIElement)
Public PropertyWidth (Inherited from Windows.UI.Xaml.FrameworkElement)
Public PropertyWorksheet Gets the worksheet associated with the view.  
Public PropertyZoomFactor Gets or sets the scaling factor for displaying this sheet.  
Top
Public Methods
 NameDescription
Public MethodAddHandler (Inherited from Windows.UI.Xaml.UIElement)
Public MethodAddSelection Adds a cell or cells to the selection.  
Public MethodAdjustColumnViewport Adjusts the adjacent column viewport's width.  
Public MethodAdjustRowViewport Adjusts the adjacent row viewport's height.  
Public MethodArrange (Inherited from Windows.UI.Xaml.UIElement)
Public MethodAutoFitColumnOverloaded.  Automatically fits the viewport column.  
Public MethodAutoFitRowOverloaded.  Automatically fits the viewport row.  
Public MethodBeginFormulaSelection Enters a state where the user can select formulas with the mouse or keyboard.  
Public MethodCapturePointer (Inherited from Windows.UI.Xaml.UIElement)
Public MethodClearUndoManager Clears all undo and redo actions in the current UndoManager.  
Public MethodClearValue (Inherited from Windows.UI.Xaml.DependencyObject)
Public MethodClipboardCopy Copies the text of a cell range to the Clipboard.  
Public MethodClipboardCut Cuts the text of a cell range to the Clipboard.  
Public MethodClipboardPasteOverloaded.  Pastes content from the Clipboard to a cell range on the sheet.  
Public MethodCreateObjRef (Inherited from System.MarshalByRefObject)
Public MethodEndFormulaSelection Exits the state where the user can select formulas with the mouse or keyboard.  
Public MethodEquals (Inherited from System.Runtime.InteropServices.WindowsRuntime.RuntimeClass)
Public MethodExtendSelection Specifies the last cell in the cell selection.  
Public MethodFindName (Inherited from Windows.UI.Xaml.FrameworkElement)
Public MethodGetAnimationBaseValue (Inherited from Windows.UI.Xaml.DependencyObject)
Public MethodGetFloatingObjectZIndex Gets the index of the floating object Z.  
Public MethodGetHashCode (Inherited from System.Runtime.InteropServices.WindowsRuntime.RuntimeClass)
Public MethodGetLifetimeService (Inherited from System.MarshalByRefObject)
Public MethodGetNextPageColumnCount Gets the column count when scrolling right one page.  
Public MethodGetNextPageRowCount Gets the row count when scrolling down one page.  
Public MethodGetPrePageColumnCount Gets the column count when scrolling left one page.  
Public MethodGetPrePageRowCount Gets the row count when scrolling up one page.  
Public MethodGetSpreadChartView Ges the spread chart view.  
Public MethodGetValue (Inherited from Windows.UI.Xaml.DependencyObject)
Public MethodGetViewportBottomRow Gets the row viewport's bottom row index.  
Public MethodGetViewportLeftColumn Gets the column viewport's left column index.  
Public MethodGetViewportRightColumn Gets the column viewport's right column index.  
Public MethodGetViewportTopRow Gets the row viewport's top row index.  
Public MethodInitializeLifetimeService (Inherited from System.MarshalByRefObject)
Public MethodInvalidate Invalidates the measurement state (layout) and the arranged state (layout) for the control. The view layout and data is updated after the invalidation.  
Public MethodInvalidateArrange (Inherited from Windows.UI.Xaml.UIElement)
Public MethodInvalidateChartsOverloaded.  Invalidates the charts.  
Public MethodInvalidateColumns Invalidates the column state in the control; the column layout and data is updated after the invalidation.  
Public MethodInvalidateCustomFloatingObjectsOverloaded.  Invalidates the custom floating objects.  
Public MethodInvalidateFloatingObjectsOverloaded.  Invalidates the charts.  
Public MethodInvalidateMeasure (Inherited from Windows.UI.Xaml.UIElement)
Public MethodInvalidatePicturesOverloaded.  Invalidates the pictures.  
Public MethodInvalidateRange Invalidates a range state in the control; the range layout and data is updated after the invalidation.  
Public MethodInvalidateRows Invalidates the row state in the control; the row layout and data is updated after the invalidation.  
Public MethodMeasure (Inherited from Windows.UI.Xaml.UIElement)
Public MethodReadLocalValue (Inherited from Windows.UI.Xaml.DependencyObject)
Public MethodReleasePointerCapture (Inherited from Windows.UI.Xaml.UIElement)
Public MethodReleasePointerCaptures (Inherited from Windows.UI.Xaml.UIElement)
Public MethodRemoveHandler (Inherited from Windows.UI.Xaml.UIElement)
Public MethodResumeEvent Resumes the events.  
Public MethodSetActiveCell Sets the active cell of the sheet.  
Public MethodSetBinding (Inherited from Windows.UI.Xaml.FrameworkElement)
Public MethodSetFloatingObjectZIndex Sets the index of the floating object Z.  
Public MethodSetSelection Selects the specified cells.  
Public MethodSetValue (Inherited from Windows.UI.Xaml.DependencyObject)
Public MethodSetViewportLeftColumnOverloaded.  Sets the active column viewport's left column.  
Public MethodSetViewportTopRowOverloaded.  Sets the active row viewport's top row.  
Public MethodShowAutoFillIndicator Displays the automatic fill indicator.  
Public MethodStartCellEditing Starts to edit the active cell.  
Public MethodStopCellEditing Stops editing the active cell.  
Public MethodSuspendEvent Suspends all events.  
Public MethodToString (Inherited from System.Runtime.InteropServices.WindowsRuntime.RuntimeClass)
Public MethodTransformToVisual (Inherited from Windows.UI.Xaml.UIElement)
Public MethodUpdateLayout (Inherited from Windows.UI.Xaml.UIElement)
Top
Protected Methods
 NameDescription
Protected MethodArrangeOverrideOverridden. Positions child elements and determines a size for a System.Windows.FrameworkElement derived class, when overridden in a derived class.  
Protected MethodFindSubElementsForTouchTargeting (Inherited from Windows.UI.Xaml.UIElement)
Protected MethodMeasureOverrideOverridden. 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.  
Protected MethodMemberwiseCloneOverloaded.  (Inherited from System.MarshalByRefObject)
Protected MethodOnApplyTemplate (Inherited from Windows.UI.Xaml.FrameworkElement)
Protected MethodOnCreateAutomationPeer (Inherited from Windows.UI.Xaml.UIElement)
Protected MethodOnDisconnectVisualChildren (Inherited from Windows.UI.Xaml.UIElement)
Protected MethodUpdateTouchHitTestInfo  
Protected MethodUpdateTouchHitTestInfoForHold  
Top
Public Events
 NameDescription
Public EventCellClick Occurs when the user presses down the left mouse button in a cell.  
Public EventCellDoubleClick Occurs when the user presses down the left mouse button twice (double-clicks) in a cell.  
Public EventCellTextRendering Occurs when [cell text rendering].  
Public EventCellValueApplying Occurs when [cell value applying].  
Public EventClipboardChanged Occurs when a Clipboard change occurs that affects GcSpreadSheet.  
Public EventClipboardChanging Occurs when the Clipboard is changing due to a GcSpreadSheet action.  
Public EventClipboardPasted Occurs when the user has pasted from the Clipboard.  
Public EventClipboardPasting Occurs when the user pastes from the Clipboard.  
Public EventColumnWidthChanged Occurs when the column width has changed.  
Public EventColumnWidthChanging Occurs when the column width is changing.  
Public EventDataValidationListPopupOpening Occurs when [data validation list popup opening].  
Public EventDoubleTapped (Inherited from Windows.UI.Xaml.UIElement)
Public EventDragDropBlock Occurs when the user drags and drops a range of cells.  
Public EventDragDropBlockCompleted Occurs at the completion of the user dragging and dropping a range of cells.  
Public EventDragEnter (Inherited from Windows.UI.Xaml.UIElement)
Public EventDragFillBlock Occurs when the user drags to fill a range of cells.  
Public EventDragFillBlockCompleted Occurs at the completion of the user dragging to fill a range of cells.  
Public EventDragLeave (Inherited from Windows.UI.Xaml.UIElement)
Public EventDragOver (Inherited from Windows.UI.Xaml.UIElement)
Public EventDrop (Inherited from Windows.UI.Xaml.UIElement)
Public EventEditChange Occurs when a cell is in edit mode and the text is changed.  
Public EventEditEnd Occurs when a cell leaves edit mode.  
Public EventEditStarting Occurs when a cell is going in to edit mode.  
Public EventEnterCell Occurs when the user enters a cell.  
Public EventFilterPopupOpening Occurs when [filter popup opening].  
Public EventFloatingObjectPasted Occurs when [floating object pasted].  
Public EventGotFocus (Inherited from Windows.UI.Xaml.UIElement)
Public EventHolding (Inherited from Windows.UI.Xaml.UIElement)
Public EventInvalidOperation Occurs when an invalid operation is performed.  
Public EventKeyDown (Inherited from Windows.UI.Xaml.UIElement)
Public EventKeyUp (Inherited from Windows.UI.Xaml.UIElement)
Public EventLayoutUpdated (Inherited from Windows.UI.Xaml.FrameworkElement)
Public EventLeaveCell Occurs when the user leaves a cell.  
Public EventLeftColumnChanged Occurs when the left column changes.  
Public EventLoaded (Inherited from Windows.UI.Xaml.FrameworkElement)
Public EventLostFocus (Inherited from Windows.UI.Xaml.UIElement)
Public EventManipulationCompleted (Inherited from Windows.UI.Xaml.UIElement)
Public EventManipulationDelta (Inherited from Windows.UI.Xaml.UIElement)
Public EventManipulationInertiaStarting (Inherited from Windows.UI.Xaml.UIElement)
Public EventManipulationStarted (Inherited from Windows.UI.Xaml.UIElement)
Public EventManipulationStarting (Inherited from Windows.UI.Xaml.UIElement)
Public EventPointerCanceled (Inherited from Windows.UI.Xaml.UIElement)
Public EventPointerCaptureLost (Inherited from Windows.UI.Xaml.UIElement)
Public EventPointerEntered (Inherited from Windows.UI.Xaml.UIElement)
Public EventPointerExited (Inherited from Windows.UI.Xaml.UIElement)
Public EventPointerMoved (Inherited from Windows.UI.Xaml.UIElement)
Public EventPointerPressed (Inherited from Windows.UI.Xaml.UIElement)
Public EventPointerReleased (Inherited from Windows.UI.Xaml.UIElement)
Public EventPointerWheelChanged (Inherited from Windows.UI.Xaml.UIElement)
Public EventRangeFiltered Occurs when a column has just been automatically sorted.  
Public EventRangeFiltering Occurs when a column is about to be automatically filtered.  
Public EventRangeGroupStateChanged Occurs when the user has changed the state of outline (range group) rows or columns.  
Public EventRangeGroupStateChanging Occurs before the user changes the state of outline (range group) rows or columns.  
Public EventRangeSorted Occurs when a column has just been automatically sorted.  
Public EventRangeSorting Occurs when a column is about to be automatically sorted.  
Public EventRightTapped (Inherited from Windows.UI.Xaml.UIElement)
Public EventRowHeightChanged Occurs when the row height has changed.  
Public EventRowHeightChanging Occurs when the row height is changing.  
Public EventSelectionChanged Occurs when the selection of cells on the sheet has changed.  
Public EventSelectionChanging Occurs when the selection of cells on the sheet is changing.  
Public EventSheetTabClick Occurs when the user clicks the sheet tab.  
Public EventSheetTabDoubleClick Occurs when the user double-clicks the sheet tab.  
Public EventSizeChanged (Inherited from Windows.UI.Xaml.FrameworkElement)
Public EventTapped (Inherited from Windows.UI.Xaml.UIElement)
Public EventTopRowChanged Occurs when the top row changes.  
Public EventUnloaded (Inherited from Windows.UI.Xaml.FrameworkElement)
Public EventUserFormulaEntered Occurs when the user types a formula.  
Public EventUserZooming Occurs when the user zooms.  
Public EventValidationDragDropBlock Occurs when the user drags and drops a range of cells.  
Public EventValidationError Occurs when the applied cell value is invalid.  
Public EventValidationPasting Occurs when validation the whether the pasting is validate.  
Public EventValueChanged Occurs when the value in the subeditor changes.  
Top
See Also

Reference

SheetView Class
GrapeCity.Xaml.SpreadSheet.UI Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options