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


GrapeCity.Xaml.SpreadSheet.UI Namespace : SheetView Class

The following tables list the members exposed by SheetView.

Public Properties
 NameDescription
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property Gets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public Property (Inherited from Windows.UI.Xaml.Controls.Panel)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property Gets or sets whether data can overflow into adjacent empty cells in the component.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property Gets or sets whether data can overflow into adjacent empty cells in the component while the cell is in edit mode.  
Public Property Gets a value that indicates whether the user is editing a formula.  
Public Property Indicates whether the user can select multiple ranges by touch.  
Public Property Gets or sets whether to allow users to drag and drop a range.  
Public Property Gets or sets whether to allow users to drag and fill a range.  
Public Property Gets or sets whether to allow the user to enter formulas in a cell in the component.  
Public Property Gets or sets whether to allow the user to undo edit operations.  
Public Property Gets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.  
Public Property Gets the cell editor control on the editing viewport.  
Public Property Gets the cell editor status.  
Public Property (Inherited from Windows.UI.Xaml.Controls.Panel)
Public Property (Inherited from Windows.UI.Xaml.Controls.Panel)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property Gets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property Gets or sets the default type of the automatic fill.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.DependencyObject)
Public Property Gets the information of the editor when the sheetview enters the formula selection mode.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property Gets or sets whether to highlight invalid data.  
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property Gets or sets a value that indicates whether the horizontal scroll bar is scrollable.  
Public Property Returns the last input device type.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property Gets a value that indicates whether there is a cell in edit mode.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.Controls.Panel)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property Gets the key map collection that contains associated keys and actions.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property Gets or sets the backgroud of the range group  
Public Property Gets or sets the brush of the border of the range group  
Public Property Gets or sets the stroke of the group line  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property Specifies the drawing policy when the row or column is resized to zero.  
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property Gets or sets whether the column range group is visible.  
Public Property Gets or sets a value that indicates whether to show the drag drop tip.  
Public Property Gets or sets a value that indicates whether to show a drag fill tip.  
Public Property Gets or sets a value that indicates whether to show the freeze line.  
Public Property Gets or sets how to display the resize tip.  
Public Property Gets or sets whether the row range group is visible.  
Public Property Gets or sets how to display the scroll tip.  
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property Gets the undo manager for the control.  
Public Property Specifies whether to edit a cell's value using the formatter.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property Specifies whether to validate value when pasting.  
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property Gets or sets a value that indicates whether the vertical scroll bar is scrollable.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Property Gets the worksheet associated with the view.  
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property (Inherited from Windows.UI.Xaml.UIElement)
Public Property Gets or sets the scaling factor for displaying this sheet.  
Top
Public Methods
 NameDescription
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public Method Adds a cell or cells to the selection.  
Public Method Adjusts the adjacent column viewport's width.  
Public Method Adjusts the adjacent row viewport's height.  
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public MethodOverloaded.  Automatically fits the viewport column.  
Public MethodOverloaded.  Automatically fits the viewport row.  
Public Method Enters a state where the user can select formulas with the mouse or keyboard.  
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public Method Clears all undo and redo actions in the current UndoManager.  
Public Method (Inherited from Windows.UI.Xaml.DependencyObject)
Public Method Copies the text of a cell range to the Clipboard.  
Public Method Cuts 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.MarshalByRefObject)
Public Method Exits the state where the user can select formulas with the mouse or keyboard.  
Public Method (Inherited from System.Runtime.InteropServices.WindowsRuntime.RuntimeClass)
Public Method Specifies the last cell in the cell selection.  
Public Method (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Method (Inherited from Windows.UI.Xaml.DependencyObject)
Public Method (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Method Gets the index of the floating object Z.  
Public Method (Inherited from System.Runtime.InteropServices.WindowsRuntime.RuntimeClass)
Public Method (Inherited from System.MarshalByRefObject)
Public Method Gets the column count when scrolling right one page.  
Public Method Gets the row count when scrolling down one page.  
Public Method Gets the column count when scrolling left one page.  
Public Method Gets the row count when scrolling up one page.  
Public Method Ges the spread chart view.  
Public Method (Inherited from Windows.UI.Xaml.DependencyObject)
Public Method Gets the row viewport's bottom row index.  
Public Method Gets the column viewport's left column index.  
Public Method Gets the column viewport's right column index.  
Public Method Gets the row viewport's top row index.  
Public Method (Inherited from System.MarshalByRefObject)
Public Method Invalidates 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 Windows.UI.Xaml.UIElement)
Public MethodOverloaded.  Invalidates the charts.  
Public Method Invalidates 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 Windows.UI.Xaml.UIElement)
Public MethodOverloaded.  Invalidates the pictures.  
Public Method Invalidates a range state in the control; the range layout and data is updated after the invalidation.  
Public Method Invalidates the row state in the control; the row layout and data is updated after the invalidation.  
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public Method (Inherited from Windows.UI.Xaml.DependencyObject)
Public Method (Inherited from Windows.UI.Xaml.DependencyObject)
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public Method Resumes the events.  
Public Method Sets the active cell of the sheet.  
Public Method (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Method Sets the index of the floating object Z.  
Public Method Selects the specified cells.  
Public Method (Inherited from Windows.UI.Xaml.DependencyObject)
Public MethodOverloaded.  Sets the active column viewport's left column.  
Public MethodOverloaded.  Sets the active row viewport's top row.  
Public Method Displays the automatic fill indicator.  
Public MethodOverloaded.  (Inherited from Windows.UI.Xaml.UIElement)
Public Method Starts to edit the active cell.  
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public Method Stops editing the active cell.  
Public Method Suspends all events.  
Public Method (Inherited from System.Runtime.InteropServices.WindowsRuntime.RuntimeClass)
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Public Method (Inherited from Windows.UI.Xaml.DependencyObject)
Public Method (Inherited from Windows.UI.Xaml.UIElement)
Top
Protected Methods
 NameDescription
Protected MethodOverridden. Positions child elements and determines a size for a System.Windows.FrameworkElement derived class, when overridden in a derived class.  
Protected Method (Inherited from Windows.UI.Xaml.UIElement)
Protected Method (Inherited from Windows.UI.Xaml.FrameworkElement)
Protected MethodOverridden. 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 MethodOverloaded.  (Inherited from System.MarshalByRefObject)
Protected Method (Inherited from Windows.UI.Xaml.FrameworkElement)
Protected Method (Inherited from Windows.UI.Xaml.UIElement)
Protected Method (Inherited from Windows.UI.Xaml.UIElement)
Protected Method  
Protected Method  
Top
Public Events
 NameDescription
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event Occurs when the user presses down the left mouse button in a cell.  
Public Event Occurs when the user presses down the left mouse button twice (double-clicks) in a cell.  
Public Event Occurs when [cell text rendering].  
Public Event Occurs when [cell value applying].  
Public Event Occurs when a Clipboard change occurs that affects GcSpreadSheet.  
Public Event Occurs when the Clipboard is changing due to a GcSpreadSheet action.  
Public Event Occurs when the user has pasted from the Clipboard.  
Public Event Occurs when the user pastes from the Clipboard.  
Public Event Occurs when the column width has changed.  
Public Event Occurs when the column width is changing.  
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Event Occurs when [data validation list popup opening].  
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event Occurs when the user drags and drops a range of cells.  
Public Event Occurs at the completion of the user dragging and dropping a range of cells.  
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event Occurs when the user drags to fill a range of cells.  
Public Event Occurs at the completion of the user dragging to fill a range of cells.  
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event Occurs when a cell is in edit mode and the text is changed.  
Public Event Occurs when a cell leaves edit mode.  
Public Event Occurs when a cell is going in to edit mode.  
Public Event Occurs when the user enters a cell.  
Public Event Occurs when [filter popup opening].  
Public Event Occurs when [floating object pasted].  
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event Occurs when an invalid operation is performed.  
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Event Occurs when the user leaves a cell.  
Public Event Occurs when the left column changes.  
Public Event (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Event (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event Occurs when a column has just been automatically sorted.  
Public Event Occurs when a column is about to be automatically filtered.  
Public Event Occurs when the user has changed the state of outline (range group) rows or columns.  
Public Event Occurs before the user changes the state of outline (range group) rows or columns.  
Public Event Occurs when a column has just been automatically sorted.  
Public Event Occurs when a column is about to be automatically sorted.  
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event Occurs when the row height has changed.  
Public Event Occurs when the row height is changing.  
Public Event Occurs when the selection of cells on the sheet has changed.  
Public Event Occurs when the selection of cells on the sheet is changing.  
Public Event Occurs when the user clicks the sheet tab.  
Public Event Occurs when the user double-clicks the sheet tab.  
Public Event (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Event (Inherited from Windows.UI.Xaml.UIElement)
Public Event Occurs when the top row changes.  
Public Event (Inherited from Windows.UI.Xaml.FrameworkElement)
Public Event Occurs when the user types a formula.  
Public Event Occurs when the user zooms.  
Public Event Occurs when the user drags and drops a range of cells.  
Public Event Occurs when the applied cell value is invalid.  
Public Event Occurs when validation the whether the pasting is validate.  
Public Event Occurs when the value in the subeditor changes.  
Top
See Also

Reference

SheetView Class
GrapeCity.Xaml.SpreadSheet.UI Namespace