Spread Silverlight Documentation
SheetView Class Members
Properties  Methods  Events


The following tables list the members exposed by SheetView.

Public Properties
 NameDescription
Public PropertyActualHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyActualWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyAllowDrop (Inherited from System.Windows.UIElement)
Public PropertyAutoClipboardGets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public PropertyBackground (Inherited from System.Windows.Controls.Panel)
Public PropertyCacheMode (Inherited from System.Windows.UIElement)
Public PropertyCanCellOverflowGets or sets whether data can overflow into adjacent empty cells in the component.  
Public PropertyCanEditOverflowGets or sets whether data can overflow into adjacent empty cells in the component while the cell is in edit mode.  
Public PropertyCanSelectFormulaGets a value that indicates whether the user is editing a formula.  
Public PropertyCanTouchMultiSelectIndicates whether the user can select multiple ranges by touch.  
Public PropertyCanUserDragDropGets or sets whether to allow users to drag and drop a range.  
Public PropertyCanUserDragFillGets or sets whether to allow users to drag and fill a range.  
Public PropertyCanUserEditFormulaGets or sets whether to allow the user to enter formulas in a cell in the component.  
Public PropertyCanUserUndoGets or sets whether to allow the user to undo edit operations.  
Public PropertyCanUserZoomGets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.  
Public PropertyCellEditorGets the cell editor control on the editing viewport.  
Public PropertyCellEditorStatusGets the cell editor status.  
Public PropertyChildren (Inherited from System.Windows.Controls.Panel)
Public PropertyClip (Inherited from System.Windows.UIElement)
Public PropertyClipBoardOptionsGets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public PropertyCursor (Inherited from System.Windows.FrameworkElement)
Public PropertyDataContext (Inherited from System.Windows.FrameworkElement)
Public PropertyDefaultAutoFillTypeGets or sets the default type of the automatic fill.  
Public PropertyDesiredSize (Inherited from System.Windows.UIElement)
Public PropertyDispatcher (Inherited from System.Windows.DependencyObject)
Public PropertyEditorInfoGets the information of the editor when the sheetview enters the formula selection mode.  
Public PropertyEffect (Inherited from System.Windows.UIElement)
Public PropertyFlowDirection (Inherited from System.Windows.FrameworkElement)
Public PropertyHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyHighlightInvalidDataGets or sets whether to highlight invalid data.  
Public PropertyHorizontalAlignment (Inherited from System.Windows.FrameworkElement)
Public PropertyHorizontalScrollableGets or sets a value that indicates whether the horizontal scroll bar is scrollable.  
Public PropertyInputDeviceTypeReturns the last input device type.  
Public PropertyIsCellEditingGets a value that indicates whether there is a cell in edit mode.  
Public PropertyIsHitTestVisible (Inherited from System.Windows.UIElement)
Public PropertyIsItemsHost (Inherited from System.Windows.Controls.Panel)
Public PropertyKeyMapGets the key map collection that contains associated keys and actions.  
Public PropertyLanguage (Inherited from System.Windows.FrameworkElement)
Public PropertyMargin (Inherited from System.Windows.FrameworkElement)
Public PropertyMaxHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyMaxWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyMinHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyMinWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyName (Inherited from System.Windows.FrameworkElement)
Public PropertyOpacity (Inherited from System.Windows.UIElement)
Public PropertyOpacityMask (Inherited from System.Windows.UIElement)
Public PropertyParent (Inherited from System.Windows.FrameworkElement)
Public PropertyProjection (Inherited from System.Windows.UIElement)
Public PropertyRangeGroupBackgroundGets or sets the backgroud of the range group  
Public PropertyRangeGroupBorderBrushGets or sets the brush of the border of the range group  
Public PropertyRangeGroupLineStrokeGets or sets the stroke of the group line  
Public PropertyRenderSize (Inherited from System.Windows.UIElement)
Public PropertyRenderTransform (Inherited from System.Windows.UIElement)
Public PropertyRenderTransformOrigin (Inherited from System.Windows.UIElement)
Public PropertyResizeZeroIndicatorSpecifies the drawing policy when the row or column is resized to zero.  
Public PropertyResources (Inherited from System.Windows.FrameworkElement)
Public PropertyShowColumnRangeGroupGets or sets whether the column range group is visible.  
Public PropertyShowDragDropTipGets or sets a value that indicates whether to show the drag drop tip.  
Public PropertyShowDragFillTipGets or sets a value that indicates whether to show a drag fill tip.  
Public PropertyShowFreezeLineGets or sets a value that indicates whether to show the freeze line.  
Public PropertyShowResizeTipGets or sets how to display the resize tip.  
Public PropertyShowRowRangeGroupGets or sets whether the row range group is visible.  
Public PropertyShowScrollTipGets or sets how to display the scroll tip.  
Public PropertyStyle (Inherited from System.Windows.FrameworkElement)
Public PropertyTag (Inherited from System.Windows.FrameworkElement)
Public PropertyTriggers (Inherited from System.Windows.FrameworkElement)
Public PropertyUndoManagerGets the undo manager for the control.  
Public PropertyUseLayoutRounding (Inherited from System.Windows.UIElement)
Public PropertyVerticalAlignment (Inherited from System.Windows.FrameworkElement)
Public PropertyVerticalScrollableGets or sets a value that indicates whether the vertical scroll bar is scrollable.  
Public PropertyVisibility (Inherited from System.Windows.UIElement)
Public PropertyWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyWorksheetGets the worksheet associated with the view.  
Public PropertyZoomFactorGets or sets the scaling factor for displaying this sheet.  
Top
Public Methods
 NameDescription
Public MethodAddHandler (Inherited from System.Windows.UIElement)
Public MethodAddSelectionAdds a cell or cells to the selection.  
Public MethodAdjustColumnViewportAdjusts the adjacent column viewport's width.  
Public MethodAdjustRowViewportAdjusts the adjacent row viewport's height.  
Public MethodArrange (Inherited from System.Windows.UIElement)
Public MethodAutoFitColumnOverloaded. Automatically fits the viewport column.  
Public MethodAutoFitRowOverloaded. Automatically fits the viewport row.  
Public MethodBeginFormulaSelectionEnters a state where the user can select formulas with the mouse or keyboard.  
Public MethodCaptureMouse (Inherited from System.Windows.UIElement)
Public MethodClearUndoManagerClears all undo and redo actions in the current UndoManager.  
Public MethodClearValue (Inherited from System.Windows.DependencyObject)
Public MethodClipboardCopyCopies the text of a cell range to the Clipboard.  
Public MethodClipboardCutCuts the text of a cell range to the Clipboard.  
Public Methodstatic (Shared in Visual Basic)ClipboardPasteOverloaded. Pastes content from the Clipboard to a cell range on the sheet.  
Public MethodEndFormulaSelectionExits the state where the user can select formulas with the mouse or keyboard.  
Public MethodExtendSelectionSpecifies the last cell in the cell selection.  
Public MethodFindName (Inherited from System.Windows.FrameworkElement)
Public MethodGetAnimationBaseValue (Inherited from System.Windows.DependencyObject)
Public MethodGetBindingExpression (Inherited from System.Windows.FrameworkElement)
Public MethodGetFloatingObjectZIndexGets the index of the floating object Z.  
Public MethodGetNextPageColumnCountGets the column count when scrolling right one page.  
Public MethodGetNextPageRowCountGets the row count when scrolling down one page.  
Public MethodGetPrePageColumnCountGets the column count when scrolling left one page.  
Public MethodGetPrePageRowCountGets the row count when scrolling up one page.  
Public MethodGetSpreadChartViewGes the spread chart view.  
Public MethodGetValue (Inherited from System.Windows.DependencyObject)
Public MethodGetViewportBottomRowGets the row viewport's bottom row index.  
Public MethodGetViewportLeftColumnGets the column viewport's left column index.  
Public MethodGetViewportRightColumnGets the column viewport's right column index.  
Public MethodGetViewportTopRowGets the row viewport's top row index.  
Public MethodInvalidateInvalidates 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 System.Windows.UIElement)
Public MethodInvalidateChartsOverloaded. Invalidates the charts.  
Public MethodInvalidateColumnsInvalidates 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 System.Windows.UIElement)
Public MethodInvalidatePicturesOverloaded. Invalidates the pictures.  
Public MethodInvalidateRangeInvalidates a range state in the control; the range layout and data is updated after the invalidation.  
Public MethodInvalidateRowsInvalidates the row state in the control; the row layout and data is updated after the invalidation.  
Public MethodInvalidateSurfaceChartsOverloaded. Invalidates the surface charts.  
Public MethodMeasure (Inherited from System.Windows.UIElement)
Public MethodOnApplyTemplate (Inherited from System.Windows.FrameworkElement)
Public MethodReadLocalValue (Inherited from System.Windows.DependencyObject)
Public MethodReleaseMouseCapture (Inherited from System.Windows.UIElement)
Public MethodRemoveHandler (Inherited from System.Windows.UIElement)
Public MethodResumeEventResumes the events.  
Public MethodSetActiveCellSets the active cell of the sheet.  
Public MethodSetBinding (Inherited from System.Windows.FrameworkElement)
Public MethodSetFloatingObjectZIndexSets the index of the floating object Z.  
Public MethodSetSelectionSelects the specified cells.  
Public MethodSetValue (Inherited from System.Windows.DependencyObject)
Public MethodSetViewportLeftColumnOverloaded. Sets the active column viewport's left column.  
Public MethodSetViewportTopRowOverloaded. Sets the active row viewport's top row.  
Public MethodShowAutoFillIndicatorDisplays the automatic fill indicator.  
Public MethodStartCellEditingStarts to edit the active cell.  
Public MethodStopCellEditingStops editing the active cell.  
Public MethodSuspendEventSuspends all events.  
Public MethodTransformToVisual (Inherited from System.Windows.UIElement)
Public MethodUpdateLayout (Inherited from System.Windows.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 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 MethodOnCreateAutomationPeer (Inherited from System.Windows.UIElement)
Protected MethodUpdateTouchHitTestInfo  
Protected MethodUpdateTouchHitTestInfoForHold  
Top
Public Events
 NameDescription
Public EventBindingValidationError (Inherited from System.Windows.FrameworkElement)
Public EventCellClickOccurs when the user presses down the left mouse button in a cell.  
Public EventCellDoubleClickOccurs when the user presses down the left mouse button twice (double-clicks) in a cell.  
Public EventCellTextRenderingOccurs when [cell text rendering].  
Public EventCellValueApplyingOccurs when [cell value applying].  
Public EventClipboardChangedOccurs when a Clipboard change occurs that affects GcSpreadSheet.  
Public EventClipboardChangingOccurs when the Clipboard is changing due to a GcSpreadSheet action.  
Public EventClipboardPastedOccurs when the user has pasted from the Clipboard.  
Public EventClipboardPastingOccurs when the user pastes from the Clipboard.  
Public EventColumnWidthChangedOccurs when the column width has changed.  
Public EventColumnWidthChangingOccurs when the column width is changing.  
Public EventDataValidationListPopupOpeningOccurs when [data validation list popup opening].  
Public EventDragDropBlockOccurs when the user drags and drops a range of cells.  
Public EventDragDropBlockCompletedOccurs at the completion of the user dragging and dropping a range of cells.  
Public EventDragEnter (Inherited from System.Windows.UIElement)
Public EventDragFillBlockOccurs when the user drags to fill a range of cells.  
Public EventDragFillBlockCompletedOccurs at the completion of the user dragging to fill a range of cells.  
Public EventDragLeave (Inherited from System.Windows.UIElement)
Public EventDragOver (Inherited from System.Windows.UIElement)
Public EventDrop (Inherited from System.Windows.UIElement)
Public EventEditChangeOccurs when a cell is in edit mode and the text is changed.  
Public EventEditEndOccurs when a cell leaves edit mode.  
Public EventEditStartingOccurs when a cell is going in to edit mode.  
Public EventEnterCellOccurs when the user enters a cell.  
Public EventFilterPopupOpeningOccurs when [filter popup opening].  
Public EventFloatingObjectPastedOccurs when [floating object pasted].  
Public EventGotFocus (Inherited from System.Windows.UIElement)
Public EventInvalidOperationOccurs when an invalid operation is performed.  
Public EventKeyDown (Inherited from System.Windows.UIElement)
Public EventKeyUp (Inherited from System.Windows.UIElement)
Public EventLayoutUpdated (Inherited from System.Windows.FrameworkElement)
Public EventLeaveCellOccurs when the user leaves a cell.  
Public EventLeftColumnChangedOccurs when the left column changes.  
Public EventLoaded (Inherited from System.Windows.FrameworkElement)
Public EventLostFocus (Inherited from System.Windows.UIElement)
Public EventLostMouseCapture (Inherited from System.Windows.UIElement)
Public EventMouseEnter (Inherited from System.Windows.UIElement)
Public EventMouseLeave (Inherited from System.Windows.UIElement)
Public EventMouseLeftButtonDown (Inherited from System.Windows.UIElement)
Public EventMouseLeftButtonUp (Inherited from System.Windows.UIElement)
Public EventMouseMove (Inherited from System.Windows.UIElement)
Public EventMouseRightButtonDown (Inherited from System.Windows.UIElement)
Public EventMouseRightButtonUp (Inherited from System.Windows.UIElement)
Public EventMouseWheel (Inherited from System.Windows.UIElement)
Public EventRangeFilteredOccurs when a column has just been automatically sorted.  
Public EventRangeFilteringOccurs when a column is about to be automatically filtered.  
Public EventRangeGroupStateChangedOccurs when the user has changed the state of outline (range group) rows or columns.  
Public EventRangeGroupStateChangingOccurs before the user changes the state of outline (range group) rows or columns.  
Public EventRangeSortedOccurs when a column has just been automatically sorted.  
Public EventRangeSortingOccurs when a column is about to be automatically sorted.  
Public EventRowHeightChangedOccurs when the row height has changed.  
Public EventRowHeightChangingOccurs when the row height is changing.  
Public EventSelectionChangedOccurs when the selection of cells on the sheet has changed.  
Public EventSelectionChangingOccurs when the selection of cells on the sheet is changing.  
Public EventSheetTabClickOccurs when the user clicks the sheet tab.  
Public EventSheetTabDoubleClickOccurs when the user double-clicks the sheet tab.  
Public EventSizeChanged (Inherited from System.Windows.FrameworkElement)
Public EventTextInput (Inherited from System.Windows.UIElement)
Public EventTextInputStart (Inherited from System.Windows.UIElement)
Public EventTextInputUpdate (Inherited from System.Windows.UIElement)
Public EventTopRowChangedOccurs when the top row changes.  
Public EventUnloaded (Inherited from System.Windows.FrameworkElement)
Public EventUserFormulaEnteredOccurs when the user types a formula.  
Public EventUserZoomingOccurs when the user zooms.  
Public EventValidationDragDropBlockOccurs when the user drags and drops a range of cells.  
Public EventValidationErrorOccurs when the applied cell value is invalid.  
Public EventValidationPastingOccurs when validation the whether the pasting is validate.  
Public EventValueChangedOccurs when the value in the subeditor changes.  
Top
See Also

Reference

SheetView Class
GrapeCity.Windows.SpreadSheet.UI Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.