Spread WPF 17
GrapeCity.Windows.SpreadSheet.UI Namespace / SheetView Class
Properties Methods Events

In This Topic
    SheetView Class Members
    In This Topic

    The following tables list the members exposed by SheetView.

    Public Properties
     NameDescription
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public PropertyGets or sets whether the component handles the shortcut keys for Clipboard actions.  
    Public Property (Inherited from System.Windows.Controls.Panel)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public PropertyGets or sets whether data can overflow into adjacent empty cells in the component.  
    Public PropertyGets or sets whether data can overflow into adjacent empty cells in the component while the cell is in edit mode.  
    Public PropertyGets a value that indicates whether the user is editing a formula.  
    Public PropertyIndicates whether the user can select multiple ranges by touch.  
    Public PropertyGets or sets whether to allow users to drag and drop a range.  
    Public PropertyGets or sets whether to allow users to drag and fill a range.  
    Public PropertyGets or sets whether to allow the user to enter formulas in a cell in the component.  
    Public PropertyGets or sets whether to allow the user to undo edit operations.  
    Public PropertyGets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.  
    Public PropertyGets the cell editor control on the editing viewport.  
    Public PropertyGets the cell editor status.  
    Public Property (Inherited from System.Windows.Controls.Panel)
    Public Property (Inherited from System.Windows.UIElement)
    Public PropertyGets or sets whether the component handles the shortcut keys for Clipboard actions.  
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public PropertyGets or sets the default type of the automatic fill.  
    Public Property (Inherited from System.Windows.DependencyObject)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.Threading.DispatcherObject)
    Public PropertyGets the information of the editor when the sheetview enters the formula selection mode.  
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.Controls.Panel)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public PropertyGets or sets whether to highlight invalid data.  
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public PropertyGets or sets a value that indicates whether the horizontal scroll bar is scrollable.  
    Public Property (Inherited from System.Windows.UIElement)
    Public PropertyReturns the last input device type.  
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public PropertyGets a value that indicates whether there is a cell in edit mode.  
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.Controls.Panel)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.DependencyObject)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public PropertyGets the key map collection that contains associated keys and actions.  
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.Controls.Panel)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public PropertyGets or sets the backgroud of the range group  
    Public PropertyGets or sets the brush of the border of the range group  
    Public PropertyGets or sets the stroke of the group line  
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public PropertySpecifies the drawing policy when the row or column is resized to zero.  
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public PropertyGets or sets whether the column range group is visible.  
    Public PropertyGets or sets a value that indicates whether to show the drag drop tip.  
    Public PropertyGets or sets a value that indicates whether to show a drag fill tip.  
    Public PropertyGets or sets a value that indicates whether to show the freeze line.  
    Public PropertyGets or sets how to display the resize tip.  
    Public PropertyGets or sets whether the row range group is visible.  
    Public PropertyGets or sets how to display the scroll tip.  
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public Property (Inherited from System.Windows.UIElement)
    Public PropertyGets the undo manager for the control.  
    Public PropertySpecifies whether to edit a cell's value using the formatter.  
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public PropertySpecifies whether to validate value when pasting.  
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public PropertyGets or sets a value that indicates whether the vertical scroll bar is scrollable.  
    Public Property (Inherited from System.Windows.UIElement)
    Public Property (Inherited from System.Windows.FrameworkElement)
    Public PropertyGets the worksheet associated with the view.  
    Public PropertyGets or sets the scaling factor for displaying this sheet.  
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded.  (Inherited from System.Windows.UIElement)
    Public MethodAdds a cell or cells to the selection.  
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodAdjusts the adjacent column viewport's width.  
    Public MethodAdjusts the adjacent row viewport's height.  
    Public MethodOverloaded.  (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodOverloaded. Automatically fits the viewport column.  
    Public MethodOverloaded. Automatically fits the viewport row.  
    Public MethodOverloaded.  (Inherited from System.Windows.UIElement)
    Public MethodEnters a state where the user can select formulas with the mouse or keyboard.  
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodOverloaded.  (Inherited from System.Windows.FrameworkElement)
    Public MethodOverloaded.  (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodClears all undo and redo actions in the current UndoManager.  
    Public MethodOverloaded.  (Inherited from System.Windows.DependencyObject)
    Public MethodCopies the text of a cell range to the Clipboard.  
    Public MethodCuts the text of a cell range to the Clipboard.  
    Public MethodOverloaded. Pastes content from the Clipboard to a cell range on the sheet.  
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodExits the state where the user can select formulas with the mouse or keyboard.  
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodSpecifies the last cell in the cell selection.  
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodGets the index of the floating object Z.  
    Public Method (Inherited from System.Windows.DependencyObject)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodGets the column count when scrolling right one page.  
    Public MethodGets the row count when scrolling down one page.  
    Public MethodGets the column count when scrolling left one page.  
    Public MethodGets the row count when scrolling up one page.  
    Public MethodGes the spread chart view.  
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodGets the row viewport's bottom row index.  
    Public MethodGets the column viewport's left column index.  
    Public MethodGets the column viewport's right column index.  
    Public MethodGets the row viewport's top row index.  
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodInvalidates the measurement state (layout) and the arranged state (layout) for the control. The view layout and data is updated after the invalidation.  
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodOverloaded. Invalidates the charts.  
    Public MethodInvalidates the column state in the control; the column layout and data is updated after the invalidation.  
    Public MethodOverloaded. Invalidates the custom floating objects.  
    Public MethodOverloaded. Invalidates the charts.  
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodOverloaded. Invalidates the pictures.  
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodInvalidates a range state in the control; the range layout and data is updated after the invalidation.  
    Public MethodInvalidates the row state in the control; the row layout and data is updated after the invalidation.  
    Public MethodOverloaded. Invalidates the surface charts.  
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodResumes the events.  
    Public MethodSets the active cell of the sheet.  
    Public MethodOverloaded.  (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodSets the index of the floating object Z.  
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodSelects the specified cells.  
    Public MethodOverloaded.  (Inherited from System.Windows.DependencyObject)
    Public MethodOverloaded. Sets the active column viewport's left column.  
    Public MethodOverloaded. Sets the active row viewport's top row.  
    Public MethodDisplays the automatic fill indicator.  
    Public MethodStarts to edit the active cell.  
    Public MethodStops editing the active cell.  
    Public MethodSuspends all events.  
    Public MethodOverloaded.  (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Top
    Public Events
     NameDescription
    Public EventOccurs when the user presses down the left mouse button in a cell.  
    Public EventOccurs when the user presses down the left mouse button twice (double-clicks) in a cell.  
    Public EventOccurs when [cell text rendering].  
    Public EventOccurs when [cell value applying].  
    Public EventOccurs when a Clipboard change occurs that affects GcSpreadSheet.  
    Public EventOccurs when the Clipboard is changing due to a GcSpreadSheet action.  
    Public EventOccurs when the user has pasted from the Clipboard.  
    Public EventOccurs when the user pastes from the Clipboard.  
    Public EventOccurs when the column width has changed.  
    Public EventOccurs when the column width is changing.  
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public EventOccurs when [data validation list popup opening].  
    Public EventOccurs when the user drags and drops a range of cells.  
    Public EventOccurs at the completion of the user dragging and dropping a range of cells.  
    Public Event (Inherited from System.Windows.UIElement)
    Public EventOccurs when the user drags to fill a range of cells.  
    Public EventOccurs at the completion of the user dragging to fill a range of cells.  
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public EventOccurs when a cell is in edit mode and the text is changed.  
    Public EventOccurs when a cell leaves edit mode.  
    Public EventOccurs when a cell is going in to edit mode.  
    Public EventOccurs when the user enters a cell.  
    Public EventOccurs when [filter popup opening].  
    Public EventOccurs when [floating object pasted].  
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public EventOccurs when an invalid operation is performed.  
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public EventOccurs when the user leaves a cell.  
    Public EventOccurs when the left column changes.  
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public EventOccurs when a column has just been automatically sorted.  
    Public EventOccurs when a column is about to be automatically filtered.  
    Public EventOccurs when the user has changed the state of outline (range group) rows or columns.  
    Public EventOccurs before the user changes the state of outline (range group) rows or columns.  
    Public EventOccurs when a column has just been automatically sorted.  
    Public EventOccurs when a column is about to be automatically sorted.  
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public EventOccurs when the row height has changed.  
    Public EventOccurs when the row height is changing.  
    Public EventOccurs when the selection of cells on the sheet has changed.  
    Public EventOccurs when the selection of cells on the sheet is changing.  
    Public EventOccurs when the user clicks the sheet tab.  
    Public EventOccurs when the user double-clicks the sheet tab.  
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public EventOccurs when the top row changes.  
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.UIElement)
    Public Event (Inherited from System.Windows.FrameworkElement)
    Public EventOccurs when the user types a formula.  
    Public EventOccurs when the user zooms.  
    Public EventOccurs when the user drags and drops a range of cells.  
    Public EventOccurs when the applied cell value is invalid.  
    Public EventOccurs when validation the whether the pasting is validate.  
    Public EventOccurs when the value in the subeditor changes.  
    Top
    See Also