GrapeCity.Xaml.SpreadSheet.UI Namespace : SheetView Class |
The following tables list the members exposed by SheetView.
Name | Description | |
---|---|---|
![]() | ActualHeight | (Inherited from Windows.UI.Xaml.FrameworkElement) |
![]() | ActualWidth | (Inherited from Windows.UI.Xaml.FrameworkElement) |
![]() | AllowDrop | (Inherited from Windows.UI.Xaml.UIElement) |
![]() | 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. |
![]() | 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. |
![]() | 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. |
![]() | FlowDirection | (Inherited from Windows.UI.Xaml.FrameworkElement) |
![]() | Height | (Inherited from Windows.UI.Xaml.FrameworkElement) |
![]() | 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. |
![]() | 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. |
![]() | Language | (Inherited from Windows.UI.Xaml.FrameworkElement) |
![]() | 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) |
![]() | 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) |
![]() | Tag | (Inherited from Windows.UI.Xaml.FrameworkElement) |
![]() | Transitions | (Inherited from Windows.UI.Xaml.UIElement) |
![]() | Triggers | (Inherited from Windows.UI.Xaml.FrameworkElement) |
![]() | UndoManager | Gets the undo manager for the control. |
![]() | UseLayoutRounding | (Inherited from Windows.UI.Xaml.UIElement) |
![]() | 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. |
![]() | ZoomFactor | Gets or sets the scaling factor for displaying this sheet. |
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. |
![]() | 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) |
![]() | 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) |
![]() | 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. |
![]() | StartCellEditing | Starts to edit the active cell. |
![]() | 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) |
![]() | UpdateLayout | (Inherited from Windows.UI.Xaml.UIElement) |
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) |
![]() | 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 |
Name | Description | |
---|---|---|
![]() | 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. |
![]() | 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) |
![]() | Drop | (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]. |
![]() | 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) |
![]() | 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) |
![]() | 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. |