| Name | Description | |
|---|---|---|
 | GcSpreadSheet Constructor | Initializes a new instance of the GcSpreadSheet class. |
The following tables list the members exposed by GcSpreadSheet.
Public Constructors
Public Fields
| Name | Description | |
|---|---|---|
  | HeaderGridLineColorProperty |
Public Properties
| Name | Description | |
|---|---|---|
 | ActiveSheet | Gets the active sheet in the GrapeCity.Windows.SpreadSheet.UI.GcSpread control. |
| ActiveSheetIndex | Gets or sets the index of the active sheet in the GrapeCity.Windows.SpreadSheet.UI.GcSpread control. |
| ActualHeight | (Inherited from System.Windows.FrameworkElement) |
| ActualWidth | (Inherited from System.Windows.FrameworkElement) |
| AllowDrop | (Inherited from System.Windows.UIElement) |
| AreAnyTouchesCaptured | (Inherited from System.Windows.UIElement) |
| AreAnyTouchesCapturedWithin | (Inherited from System.Windows.UIElement) |
| AreAnyTouchesDirectlyOver | (Inherited from System.Windows.UIElement) |
| AreAnyTouchesOver | (Inherited from System.Windows.UIElement) |
| AutoClipboard | Gets or sets whether the component handles the shortcut keys for Clipboard actions. |
| AutoRecalculation | Gets or sets whether the formula is automatically calculated. |
| AutoRefresh | Gets or sets whether the SpreadSheet can auto-refresh itself. |
| Background | (Inherited from System.Windows.Controls.Control) |
| BindingGroup | (Inherited from System.Windows.FrameworkElement) |
| BitmapEffect | (Inherited from System.Windows.UIElement) |
| BitmapEffectInput | (Inherited from System.Windows.UIElement) |
| BorderBrush | (Inherited from System.Windows.Controls.Control) |
| BorderThickness | (Inherited from System.Windows.Controls.Control) |
| CacheMode | (Inherited from System.Windows.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 that cell is in edit mode. |
| CanTouchMultiSelect | Indicates whether the user can select multiple ranges by touch. |
| CanUserDragDrop | Gets or sets whether to allow the user to drag and drop cell range data to another range. |
| CanUserDragFill | Gets or sets whether to allow the user to drag fill a range of cells. |
| 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. |
| Clip | (Inherited from System.Windows.UIElement) |
| ClipBoardOptions | Gets or sets whether the component handles the shortcut keys for Clipboard actions. |
| ClipToBounds | (Inherited from System.Windows.UIElement) |
| ColumnSplitBoxAlignment | Gets or sets the column split box alignment. |
| ColumnSplitBoxPolicy | Gets or sets under which conditions the GcSpreadSheet component permits column splits. |
| CommandBindings | (Inherited from System.Windows.UIElement) |
| ContextMenu | (Inherited from System.Windows.FrameworkElement) |
| CurrentTheme | Gets or sets the current theme information for the control. |
| CurrentThemeName | Gets or sets the current theme information for the control. |
| Cursor | (Inherited from System.Windows.FrameworkElement) |
| DataContext | (Inherited from System.Windows.FrameworkElement) |
| DefaultAutoFillType | Gets or sets the default type of the automatic fill. |
| DependencyObjectType | (Inherited from System.Windows.DependencyObject) |
| DesiredSize | (Inherited from System.Windows.UIElement) |
| Dispatcher | (Inherited from System.Windows.Threading.DispatcherObject) |
| DocumentUri | Gets or sets the document uri of the sheet. |
| Effect | (Inherited from System.Windows.UIElement) |
| FlowDirection | (Inherited from System.Windows.FrameworkElement) |
| Focusable | (Inherited from System.Windows.UIElement) |
| FocusVisualStyle | (Inherited from System.Windows.FrameworkElement) |
| FontFamily | (Inherited from System.Windows.Controls.Control) |
| FontSize | (Inherited from System.Windows.Controls.Control) |
| FontStretch | (Inherited from System.Windows.Controls.Control) |
| FontStyle | (Inherited from System.Windows.Controls.Control) |
| FontWeight | (Inherited from System.Windows.Controls.Control) |
| ForceCursor | (Inherited from System.Windows.FrameworkElement) |
| Foreground | (Inherited from System.Windows.Controls.Control) |
| GridLineColor | Gets or sets the gridline color. |
| HasAnimatedProperties | (Inherited from System.Windows.UIElement) |
| Height | (Inherited from System.Windows.FrameworkElement) |
| HighlightInvalidData | Specifies whether to highlight invalid data. |
| HorizontalAlignment | (Inherited from System.Windows.FrameworkElement) |
| HorizontalContentAlignment | (Inherited from System.Windows.Controls.Control) |
| HorizontalScrollBarHeight | Gets or sets the height of horizontal scroll bars in this control. |
| HorizontalScrollBarStyle | Gets or sets the horizontal scroll bar style. |
| HorizontalScrollBarVisibility | Gets or sets the horizontal scroll bar visibility setting. |
| InputBindings | (Inherited from System.Windows.UIElement) |
| InputDeviceType | Returns the last input device type. |
| InputScope | (Inherited from System.Windows.FrameworkElement) |
| IsArrangeValid | (Inherited from System.Windows.UIElement) |
| IsEnabled | (Inherited from System.Windows.UIElement) |
| IsFocused | (Inherited from System.Windows.UIElement) |
| IsHitTestVisible | (Inherited from System.Windows.UIElement) |
| IsInitialized | (Inherited from System.Windows.FrameworkElement) |
| IsInputMethodEnabled | (Inherited from System.Windows.UIElement) |
| IsKeyboardFocused | (Inherited from System.Windows.UIElement) |
| IsKeyboardFocusWithin | (Inherited from System.Windows.UIElement) |
| IsLoaded | (Inherited from System.Windows.FrameworkElement) |
| IsManipulationEnabled | (Inherited from System.Windows.UIElement) |
| IsMeasureValid | (Inherited from System.Windows.UIElement) |
| IsMouseCaptured | (Inherited from System.Windows.UIElement) |
| IsMouseCaptureWithin | (Inherited from System.Windows.UIElement) |
| IsMouseDirectlyOver | (Inherited from System.Windows.UIElement) |
| IsMouseOver | (Inherited from System.Windows.UIElement) |
| IsSealed | (Inherited from System.Windows.DependencyObject) |
| IsStylusCaptured | (Inherited from System.Windows.UIElement) |
| IsStylusCaptureWithin | (Inherited from System.Windows.UIElement) |
| IsStylusDirectlyOver | (Inherited from System.Windows.UIElement) |
| IsStylusOver | (Inherited from System.Windows.UIElement) |
| IsTabStop | (Inherited from System.Windows.Controls.Control) |
| IsVisible | (Inherited from System.Windows.UIElement) |
| Language | (Inherited from System.Windows.FrameworkElement) |
| LayoutTransform | (Inherited from System.Windows.FrameworkElement) |
| Margin | (Inherited from System.Windows.FrameworkElement) |
| MaxHeight | (Inherited from System.Windows.FrameworkElement) |
| MaxWidth | (Inherited from System.Windows.FrameworkElement) |
| MinHeight | (Inherited from System.Windows.FrameworkElement) |
| MinWidth | (Inherited from System.Windows.FrameworkElement) |
| Name | (Inherited from System.Windows.FrameworkElement) |
| NamedStyles | Gets or sets a collection of GrapeCity.Windows.SpreadSheet.Data.StyleInfo objects for this sheet. |
| Opacity | (Inherited from System.Windows.UIElement) |
| OpacityMask | (Inherited from System.Windows.UIElement) |
| OverridesDefaultStyle | (Inherited from System.Windows.FrameworkElement) |
| Padding | (Inherited from System.Windows.Controls.Control) |
| Parent | (Inherited from System.Windows.FrameworkElement) |
| PersistId | (Inherited from System.Windows.UIElement) |
| Protect | Gets or sets whether this workbook is protected. |
| 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 |
| ReferenceStyle | Gets or sets the style for cell and range references in cell formulas on this sheet. |
| RenderSize | (Inherited from System.Windows.UIElement) |
| RenderTransform | (Inherited from System.Windows.UIElement) |
| RenderTransformOrigin | (Inherited from System.Windows.UIElement) |
| ResizeZeroIndicator | Specifies the drawing policy when the row or column is resized to zero. |
| Resources | (Inherited from System.Windows.FrameworkElement) |
| RowSplitBoxAlignment | Gets or sets the row split box alignment. |
| RowSplitBoxPolicy | Gets or sets under which conditions the GcSpreadSheet component permits row splits. |
| ScrollBarTrackPolicy | Gets or sets whether the sheet in the control scrolls when the user moves the scroll box. |
| SheetCount | Gets or sets the number of sheets for this control. |
| Sheets | Gets or sets the GrapeCity.Windows.SpreadSheet.Data.Worksheet collection for the GcSpreadSheet control. |
| ShowColumnRangeGroup | Gets or sets whether the column range group is visible. |
| ShowDragDropTip | Gets or sets a value that indicates whether to display the drag drop tip. |
| ShowDragFillTip | Gets or sets a value that indicates whether to show the drag fill tip. |
| ShowFreezeLine | Gets or sets a value that indicates whether to show freeze lines. |
| ShowGridLine | Gets or sets whether gridlines are displayed. |
| 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. |
| SnapsToDevicePixels | (Inherited from System.Windows.UIElement) |
| StartSheetIndex | Gets or sets the index of the start sheet in the GrapeCity.Windows.SpreadSheet.UI.GcSpread control. |
| Style | (Inherited from System.Windows.FrameworkElement) |
| TabIndex | (Inherited from System.Windows.Controls.Control) |
| TabStripEditable | Gets or sets whether the tab strip is editable. |
| TabStripInsertTab | Gets or sets whether a special tab is displayed that allows inserting new sheets. |
| TabStripRatio | Gets or sets the width of the tab strip for this component expressed as a percentage of the overall horizontal scroll bar width. |
| TabStripVisibility | Gets or sets the display policy for the sheet tab strip for this component. |
| Tag | (Inherited from System.Windows.FrameworkElement) |
| Template | (Inherited from System.Windows.Controls.Control) |
| TemplatedParent | (Inherited from System.Windows.FrameworkElement) |
| Themes | Gets themes for the control. |
| ToolTip | (Inherited from System.Windows.FrameworkElement) |
| TouchesCaptured | (Inherited from System.Windows.UIElement) |
| TouchesCapturedWithin | (Inherited from System.Windows.UIElement) |
| TouchesDirectlyOver | (Inherited from System.Windows.UIElement) |
| TouchesOver | (Inherited from System.Windows.UIElement) |
| Triggers | (Inherited from System.Windows.FrameworkElement) |
| Uid | (Inherited from System.Windows.UIElement) |
| UndoManager | Gets the undo manager for the control. |
| UseFormatterForEditing | Specifies whether to edit a cell's value using the formatter. |
| UseLayoutRounding | (Inherited from System.Windows.FrameworkElement) |
| VerticalAlignment | (Inherited from System.Windows.FrameworkElement) |
| VerticalContentAlignment | (Inherited from System.Windows.Controls.Control) |
| VerticalScrollBarStyle | Gets or sets the vertical scroll bar style. |
| VerticalScrollBarVisibility | Gets or sets the vertical scroll bar visibility setting. |
| VerticalScrollBarWidth | Gets or sets the width of vertical scroll bars in this control. |
| View | Gets the spread view associated with the control. |
| Visibility | (Inherited from System.Windows.UIElement) |
| Width | (Inherited from System.Windows.FrameworkElement) |
| Workbook | Gets the workbook associated with the control. |
Protected Properties
| Name | Description | |
|---|---|---|
 | IsEnabledCore | (Inherited from System.Windows.UIElement) |
| StylusPlugIns | (Inherited from System.Windows.UIElement) |
| VisualBitmapEffect | (Inherited from System.Windows.Media.Visual) |
| VisualBitmapEffectInput | (Inherited from System.Windows.Media.Visual) |
| VisualBitmapScalingMode | (Inherited from System.Windows.Media.Visual) |
| VisualCacheMode | (Inherited from System.Windows.Media.Visual) |
| VisualChildrenCount | (Inherited from System.Windows.FrameworkElement) |
| VisualClip | (Inherited from System.Windows.Media.Visual) |
| VisualEdgeMode | (Inherited from System.Windows.Media.Visual) |
| VisualEffect | (Inherited from System.Windows.Media.Visual) |
| VisualOffset | (Inherited from System.Windows.Media.Visual) |
| VisualOpacity | (Inherited from System.Windows.Media.Visual) |
| VisualOpacityMask | (Inherited from System.Windows.Media.Visual) |
| VisualParent | (Inherited from System.Windows.Media.Visual) |
| VisualScrollableAreaClip | (Inherited from System.Windows.Media.Visual) |
| VisualTransform | (Inherited from System.Windows.Media.Visual) |
| VisualXSnappingGuidelines | (Inherited from System.Windows.Media.Visual) |
| VisualYSnappingGuidelines | (Inherited from System.Windows.Media.Visual) |
Public Methods
| Name | Description | |
|---|---|---|
 | AddColumnViewport | Adds a new column viewport to the control. |
| AddCustomFunction | Adds a custom function to the workbook. |
| AddHandler | Overloaded. (Inherited from System.Windows.UIElement) |
| AddRowViewport | Adds a new row viewport to the control. |
| AddToEventRoute | (Inherited from System.Windows.UIElement) |
| ApplyAnimationClock | Overloaded. (Inherited from System.Windows.UIElement) |
| ApplyTemplate | (Inherited from System.Windows.FrameworkElement) |
| Arrange | (Inherited from System.Windows.UIElement) |
| AutoFitColumn | Overloaded. Automatically fits the viewport column. |
| AutoFitRow | Overloaded. Automatically fits the viewport row. |
| BeginAnimation | Overloaded. (Inherited from System.Windows.UIElement) |
| BeginInit | (Inherited from System.Windows.FrameworkElement) |
| BeginStoryboard | Overloaded. (Inherited from System.Windows.FrameworkElement) |
| BringIntoView | Overloaded. (Inherited from System.Windows.FrameworkElement) |
| CaptureMouse | (Inherited from System.Windows.UIElement) |
| CaptureStylus | (Inherited from System.Windows.UIElement) |
| CaptureTouch | (Inherited from System.Windows.UIElement) |
| ClearCustomFunctions | Removes all user-defined custom functions (FunctionInfo object) on this sheet. |
| ClearCustomName | Clears the custom name in the workbook. |
| ClearCustomNames | Removes all custom names on this workbook. |
| ClearValue | Overloaded. (Inherited from System.Windows.DependencyObject) |
| CoerceValue | (Inherited from System.Windows.DependencyObject) |
| DoCommand | Executes a command. |
| EndInit | (Inherited from System.Windows.FrameworkElement) |
| Equals | (Inherited from System.Windows.DependencyObject) |
| FindCommonVisualAncestor | (Inherited from System.Windows.Media.Visual) |
| FindName | (Inherited from System.Windows.FrameworkElement) |
| FindResource | (Inherited from System.Windows.FrameworkElement) |
| Focus | (Inherited from System.Windows.UIElement) |
| GetActiveColumnViewportIndex | Gets the current active column viewport index in the control. |
| GetActiveRowViewportIndex | Gets the current active row viewport index in the control. |
| GetAnimationBaseValue | (Inherited from System.Windows.UIElement) |
| GetBindingExpression | (Inherited from System.Windows.FrameworkElement) |
| GetColumnViewportCount | Gets the column viewport count in the control. |
| GetCustomFunction | Gets a custom function from the workbook. |
| GetCustomName | Gets custom name information from the workbook. |
| GetHashCode | (Inherited from System.Windows.DependencyObject) |
| GetLocalValueEnumerator | (Inherited from System.Windows.DependencyObject) |
| GetRowViewportCount | Gets the row viewport count in the control. |
| GetValue | (Inherited from System.Windows.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. |
| HitTest | Performs a hit test. |
| InputHitTest | (Inherited from System.Windows.UIElement) |
| Invalidate | Invalidates the measurement state (layout) and the arrangement state (layout) for the control. After the invalidation, the control layout and data are updated. |
| InvalidateArrange | (Inherited from System.Windows.UIElement) |
| InvalidateCharts | Overloaded. Invalidates the charts. |
| InvalidateColumns | Overloaded. Invalidates the column state in the control. After the invalidation, the column layout and data are updated. |
| InvalidateCustomFloatingObjects | Overloaded. Invalidates the custom floating objects. |
| InvalidateFloatingObjects | Overloaded. Invalidates the charts. |
| InvalidateMeasure | (Inherited from System.Windows.UIElement) |
| InvalidatePictures | Overloaded. Invalidates the pictures. |
| InvalidateProperty | (Inherited from System.Windows.DependencyObject) |
| InvalidateRange | Overloaded. Invalidates a range state in the control. After the invalidation, the range layout and data are updated. |
| InvalidateRows | Overloaded. Invalidates the row state in the control. After the invalidation, the row layout and data are updated. |
| InvalidateSheet | Invalidates the measurement state (layout) and the arrangement state (layout) for the view. After the invalidation, the view layout and data are updated. |
| InvalidateSurfaceChart | Invalidates the surface chart. |
| InvalidateSurfaceCharts | Invalidates the surface charts. |
| InvalidateVisual | (Inherited from System.Windows.UIElement) |
| IsAncestorOf | (Inherited from System.Windows.Media.Visual) |
| IsDescendantOf | (Inherited from System.Windows.Media.Visual) |
| Measure | (Inherited from System.Windows.UIElement) |
| MoveFocus | (Inherited from System.Windows.FrameworkElement) |
| OnApplyTemplate | Overridden. Is invoked whenever application code or internal processes call FrameworkElement.ApplyTemplate, when overridden in a derived class. |
| OpenCSV | Overloaded. Loads the CSV (comma-separated values) file. |
| OpenExcel | Overloaded. Opens an Excel Compound Document File and loads it into GcSpreadSheet. |
| OpenTextFile | Loads the CSV file with the specified separator. |
| OpenXml | Overloaded. Loads the data on the sheet from the specified XML file. |
| PointFromScreen | (Inherited from System.Windows.Media.Visual) |
| PointToScreen | (Inherited from System.Windows.Media.Visual) |
| PredictFocus | (Inherited from System.Windows.FrameworkElement) |
| Overloaded. Prints the specified sheet. | |
| PrintPreview | Overloaded. Displays the specified sheet in a preview dialog. |
| PrintToDocument | Overloaded. Prints the specified sheet. |
| PrintWithoutPrintDialog | Overloaded. Prints the specified pages without displaying the print dialog. |
| RaiseEvent | (Inherited from System.Windows.UIElement) |
| ReadLocalValue | (Inherited from System.Windows.DependencyObject) |
| RegisterName | (Inherited from System.Windows.FrameworkElement) |
| ReleaseAllTouchCaptures | (Inherited from System.Windows.UIElement) |
| ReleaseMouseCapture | (Inherited from System.Windows.UIElement) |
| ReleaseStylusCapture | (Inherited from System.Windows.UIElement) |
| ReleaseTouchCapture | (Inherited from System.Windows.UIElement) |
| RemoveColumnViewport | Removes a column viewport from the control. |
| RemoveCustomFunctions | Removes a custom function from the workbook. |
| RemoveHandler | (Inherited from System.Windows.UIElement) |
| RemoveRowViewport | Removes a row viewport from the control. |
| ResetThemes | Resets the changed theme color and font name. |
| ResumeCalcService | Resumes the calculation service. |
| ResumeEvent | Resumes the event. |
| SaveCSV | Overloaded. Saves the CSV (comma-separated values) file. |
| SaveExcel | Overloaded. Saves GcSpreadSheet to an Excel Compound Document File. |
| SavePdf | Overloaded. Saves the content of the component to the specified PDF file. |
| SaveTextFileRange | Saves the range of cells in the specified sheet as delimited text with the specified delimiters, to a stream. |
| SaveXml | Overloaded. Saves the data on the sheet to the specified XML file. |
| Search | Overloaded. Searches the text in the cells in the specified sheet. |
| SetActiveViewport | Activates a viewport in the control. |
| SetBinding | Overloaded. (Inherited from System.Windows.FrameworkElement) |
| SetCurrentValue | (Inherited from System.Windows.DependencyObject) |
| SetCustomName | Overloaded. Sets a custom name formula to the workbook. |
| SetResourceReference | (Inherited from System.Windows.FrameworkElement) |
| SetValue | Overloaded. (Inherited from System.Windows.DependencyObject) |
| SetViewportLeftColumn | Sets the column viewport's left column. |
| SetViewportTopRow | Sets the row viewport's top row. |
| ShowActiveCell | Moves the current active cell to the specified position. |
| ShowCell | Moves a cell to the specified position. |
| ShowColumn | Moves a column to the specified position. |
| ShowRow | Moves a row to the specified position. |
| SuspendCalcService | Suspends the calculation service. |
| SuspendEvent | Suspends the event. |
| ToString | (Inherited from System.Windows.Controls.Control) |
| TransformToAncestor | Overloaded. (Inherited from System.Windows.Media.Visual) |
| TransformToDescendant | (Inherited from System.Windows.Media.Visual) |
| TransformToVisual | (Inherited from System.Windows.Media.Visual) |
| TranslatePoint | (Inherited from System.Windows.UIElement) |
| TryFindResource | (Inherited from System.Windows.FrameworkElement) |
| UnregisterName | (Inherited from System.Windows.FrameworkElement) |
| UpdateDefaultStyle | (Inherited from System.Windows.FrameworkElement) |
| UpdateLayout | (Inherited from System.Windows.UIElement) |
Protected Methods
| Name | Description | |
|---|---|---|
 | AddVisualChild | (Inherited from System.Windows.Media.Visual) |
| ArrangeCore | (Inherited from System.Windows.FrameworkElement) |
| ArrangeOverride | (Inherited from System.Windows.Controls.Control) |
| GetLayoutClip | (Inherited from System.Windows.FrameworkElement) |
| GetVisualChild | (Inherited from System.Windows.FrameworkElement) |
| HitTestCore | Overloaded. (Inherited from System.Windows.UIElement) |
| MeasureCore | (Inherited from System.Windows.FrameworkElement) |
| MeasureOverride | (Inherited from System.Windows.Controls.Control) |
| OnAccessKey | (Inherited from System.Windows.UIElement) |
| OnChildDesiredSizeChanged | (Inherited from System.Windows.UIElement) |
| OnContextMenuClosing | (Inherited from System.Windows.FrameworkElement) |
| OnContextMenuOpening | (Inherited from System.Windows.FrameworkElement) |
| OnCreateAutomationPeer | (Inherited from System.Windows.UIElement) |
| OnDpiChanged | (Inherited from System.Windows.Media.Visual) |
| OnDragEnter | (Inherited from System.Windows.UIElement) |
| OnDragLeave | (Inherited from System.Windows.UIElement) |
| OnDragOver | (Inherited from System.Windows.UIElement) |
| OnDrop | (Inherited from System.Windows.UIElement) |
| OnGiveFeedback | (Inherited from System.Windows.UIElement) |
| OnGotFocus | (Inherited from System.Windows.FrameworkElement) |
| OnGotKeyboardFocus | (Inherited from System.Windows.UIElement) |
| OnGotMouseCapture | (Inherited from System.Windows.UIElement) |
| OnGotStylusCapture | (Inherited from System.Windows.UIElement) |
| OnGotTouchCapture | (Inherited from System.Windows.UIElement) |
| OnInitialized | (Inherited from System.Windows.FrameworkElement) |
| OnIsKeyboardFocusedChanged | (Inherited from System.Windows.UIElement) |
| OnIsKeyboardFocusWithinChanged | (Inherited from System.Windows.UIElement) |
| OnIsMouseCapturedChanged | (Inherited from System.Windows.UIElement) |
| OnIsMouseCaptureWithinChanged | (Inherited from System.Windows.UIElement) |
| OnIsMouseDirectlyOverChanged | (Inherited from System.Windows.UIElement) |
| OnIsStylusCapturedChanged | (Inherited from System.Windows.UIElement) |
| OnIsStylusCaptureWithinChanged | (Inherited from System.Windows.UIElement) |
| OnIsStylusDirectlyOverChanged | (Inherited from System.Windows.UIElement) |
| OnKeyDown | (Inherited from System.Windows.UIElement) |
| OnKeyUp | (Inherited from System.Windows.UIElement) |
| OnLostFocus | (Inherited from System.Windows.UIElement) |
| OnLostKeyboardFocus | (Inherited from System.Windows.UIElement) |
| OnLostMouseCapture | (Inherited from System.Windows.UIElement) |
| OnLostStylusCapture | (Inherited from System.Windows.UIElement) |
| OnLostTouchCapture | (Inherited from System.Windows.UIElement) |
| OnManipulationBoundaryFeedback | (Inherited from System.Windows.UIElement) |
| OnManipulationCompleted | (Inherited from System.Windows.UIElement) |
| OnManipulationDelta | (Inherited from System.Windows.UIElement) |
| OnManipulationInertiaStarting | (Inherited from System.Windows.UIElement) |
| OnManipulationStarted | (Inherited from System.Windows.UIElement) |
| OnManipulationStarting | (Inherited from System.Windows.UIElement) |
| OnMouseDoubleClick | (Inherited from System.Windows.Controls.Control) |
| OnMouseDown | (Inherited from System.Windows.UIElement) |
| OnMouseEnter | (Inherited from System.Windows.UIElement) |
| OnMouseLeave | (Inherited from System.Windows.UIElement) |
| OnMouseLeftButtonDown | (Inherited from System.Windows.UIElement) |
| OnMouseLeftButtonUp | (Inherited from System.Windows.UIElement) |
| OnMouseMove | (Inherited from System.Windows.UIElement) |
| OnMouseRightButtonDown | (Inherited from System.Windows.UIElement) |
| OnMouseRightButtonUp | (Inherited from System.Windows.UIElement) |
| OnMouseUp | (Inherited from System.Windows.UIElement) |
| OnMouseWheel | (Inherited from System.Windows.UIElement) |
| OnPreviewDragEnter | (Inherited from System.Windows.UIElement) |
| OnPreviewDragLeave | (Inherited from System.Windows.UIElement) |
| OnPreviewDragOver | (Inherited from System.Windows.UIElement) |
| OnPreviewDrop | (Inherited from System.Windows.UIElement) |
| OnPreviewGiveFeedback | (Inherited from System.Windows.UIElement) |
| OnPreviewGotKeyboardFocus | (Inherited from System.Windows.UIElement) |
| OnPreviewKeyDown | (Inherited from System.Windows.UIElement) |
| OnPreviewKeyUp | (Inherited from System.Windows.UIElement) |
| OnPreviewLostKeyboardFocus | (Inherited from System.Windows.UIElement) |
| OnPreviewMouseDoubleClick | (Inherited from System.Windows.Controls.Control) |
| OnPreviewMouseDown | (Inherited from System.Windows.UIElement) |
| OnPreviewMouseLeftButtonDown | (Inherited from System.Windows.UIElement) |
| OnPreviewMouseLeftButtonUp | (Inherited from System.Windows.UIElement) |
| OnPreviewMouseMove | (Inherited from System.Windows.UIElement) |
| OnPreviewMouseRightButtonDown | (Inherited from System.Windows.UIElement) |
| OnPreviewMouseRightButtonUp | (Inherited from System.Windows.UIElement) |
| OnPreviewMouseUp | (Inherited from System.Windows.UIElement) |
| OnPreviewMouseWheel | (Inherited from System.Windows.UIElement) |
| OnPreviewQueryContinueDrag | (Inherited from System.Windows.UIElement) |
| OnPreviewStylusButtonDown | (Inherited from System.Windows.UIElement) |
| OnPreviewStylusButtonUp | (Inherited from System.Windows.UIElement) |
| OnPreviewStylusDown | (Inherited from System.Windows.UIElement) |
| OnPreviewStylusInAirMove | (Inherited from System.Windows.UIElement) |
| OnPreviewStylusInRange | (Inherited from System.Windows.UIElement) |
| OnPreviewStylusMove | (Inherited from System.Windows.UIElement) |
| OnPreviewStylusOutOfRange | (Inherited from System.Windows.UIElement) |
| OnPreviewStylusSystemGesture | (Inherited from System.Windows.UIElement) |
| OnPreviewStylusUp | (Inherited from System.Windows.UIElement) |
| OnPreviewTextInput | (Inherited from System.Windows.UIElement) |
| OnPreviewTouchDown | (Inherited from System.Windows.UIElement) |
| OnPreviewTouchMove | (Inherited from System.Windows.UIElement) |
| OnPreviewTouchUp | (Inherited from System.Windows.UIElement) |
| OnPropertyChanged | (Inherited from System.Windows.FrameworkElement) |
| OnQueryContinueDrag | (Inherited from System.Windows.UIElement) |
| OnQueryCursor | (Inherited from System.Windows.UIElement) |
| OnRender | (Inherited from System.Windows.UIElement) |
| OnStylusButtonDown | (Inherited from System.Windows.UIElement) |
| OnStylusButtonUp | (Inherited from System.Windows.UIElement) |
| OnStylusDown | (Inherited from System.Windows.UIElement) |
| OnStylusEnter | (Inherited from System.Windows.UIElement) |
| OnStylusInAirMove | (Inherited from System.Windows.UIElement) |
| OnStylusInRange | (Inherited from System.Windows.UIElement) |
| OnStylusLeave | (Inherited from System.Windows.UIElement) |
| OnStylusMove | (Inherited from System.Windows.UIElement) |
| OnStylusOutOfRange | (Inherited from System.Windows.UIElement) |
| OnStylusSystemGesture | (Inherited from System.Windows.UIElement) |
| OnStylusUp | (Inherited from System.Windows.UIElement) |
| OnTemplateChanged | (Inherited from System.Windows.Controls.Control) |
| OnTextInput | Overridden. Invoked when an unhandled System.Windows.Input.TextCompositionManager.TextInput attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event. |
| OnToolTipClosing | (Inherited from System.Windows.FrameworkElement) |
| OnToolTipOpening | (Inherited from System.Windows.FrameworkElement) |
| OnTouchDown | (Inherited from System.Windows.UIElement) |
| OnTouchEnter | (Inherited from System.Windows.UIElement) |
| OnTouchLeave | (Inherited from System.Windows.UIElement) |
| OnTouchMove | (Inherited from System.Windows.UIElement) |
| OnTouchUp | (Inherited from System.Windows.UIElement) |
| RemoveVisualChild | (Inherited from System.Windows.Media.Visual) |
Public Events
| Name | Description | |
|---|---|---|
 | ActiveSheetChanged | Occurs when the user has changed the active sheet. |
| ActiveSheetChanging | Occurs when the user changes the active sheet. |
| 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 the cell text is rendering. |
| CellValueApplying | Occurs when [cell value applying]. |
| ClipboardChanged | Occurs when a Clipboard change occurs that can effect the GcSpreadSheet control. |
| ClipboardChanging | Occurs when the Clipboard is changing due to a GcSpreadSheet action. |
| ClipboardPasted | Occurs when the user pastes from the Clipboard. |
| ClipboardPasting | Occurs when the user pastes from the Clipboard. |
| ColumnViewportWidthChanged | Occurs when a viewport column width has changed. |
| ColumnViewportWidthChanging | Occurs when a viewport column is about to be changed. |
| ColumnWidthChanged | Occurs when the column width has changed. |
| ColumnWidthChanging | Occurs when the column width is changing. |
| ContextMenuClosing | (Inherited from System.Windows.FrameworkElement) |
| ContextMenuOpening | (Inherited from System.Windows.FrameworkElement) |
| DataContextChanged | (Inherited from System.Windows.FrameworkElement) |
| DataValidationListPopupOpening | Occurs when a data validation list popup is opening. |
| 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 System.Windows.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 System.Windows.UIElement) |
| DragOver | (Inherited from System.Windows.UIElement) |
| Drop | (Inherited from System.Windows.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 goes in edit mode. |
| EnterCell | Occurs when the user enters a cell. |
| ExcelError | Occurs when an error occurs during loading or saving an Excel-formatted file. |
| FilterPopupOpening | Occurs when the filter popup is opening. |
| FloatingObjectPasted | Occurs when the floating object is pasted. |
| FocusableChanged | (Inherited from System.Windows.UIElement) |
| GiveFeedback | (Inherited from System.Windows.UIElement) |
| GotFocus | (Inherited from System.Windows.UIElement) |
| GotKeyboardFocus | (Inherited from System.Windows.UIElement) |
| GotMouseCapture | (Inherited from System.Windows.UIElement) |
| GotStylusCapture | (Inherited from System.Windows.UIElement) |
| GotTouchCapture | (Inherited from System.Windows.UIElement) |
| Initialized | (Inherited from System.Windows.FrameworkElement) |
| InvalidOperation | Occurs when an invalid operation is performed. |
| IsEnabledChanged | (Inherited from System.Windows.UIElement) |
| IsHitTestVisibleChanged | (Inherited from System.Windows.UIElement) |
| IsKeyboardFocusedChanged | (Inherited from System.Windows.UIElement) |
| IsKeyboardFocusWithinChanged | (Inherited from System.Windows.UIElement) |
| IsMouseCapturedChanged | (Inherited from System.Windows.UIElement) |
| IsMouseCaptureWithinChanged | (Inherited from System.Windows.UIElement) |
| IsMouseDirectlyOverChanged | (Inherited from System.Windows.UIElement) |
| IsStylusCapturedChanged | (Inherited from System.Windows.UIElement) |
| IsStylusCaptureWithinChanged | (Inherited from System.Windows.UIElement) |
| IsStylusDirectlyOverChanged | (Inherited from System.Windows.UIElement) |
| IsVisibleChanged | (Inherited from System.Windows.UIElement) |
| KeyDown | (Inherited from System.Windows.UIElement) |
| KeyUp | (Inherited from System.Windows.UIElement) |
| LayoutUpdated | (Inherited from System.Windows.UIElement) |
| LeaveCell | Occurs when the user leaves a cell. |
| LeftColumnChanged | Occurs when the left column changes. |
| Loaded | (Inherited from System.Windows.FrameworkElement) |
| LostFocus | (Inherited from System.Windows.UIElement) |
| LostKeyboardFocus | (Inherited from System.Windows.UIElement) |
| LostMouseCapture | (Inherited from System.Windows.UIElement) |
| LostStylusCapture | (Inherited from System.Windows.UIElement) |
| LostTouchCapture | (Inherited from System.Windows.UIElement) |
| ManipulationBoundaryFeedback | (Inherited from System.Windows.UIElement) |
| ManipulationCompleted | (Inherited from System.Windows.UIElement) |
| ManipulationDelta | (Inherited from System.Windows.UIElement) |
| ManipulationInertiaStarting | (Inherited from System.Windows.UIElement) |
| ManipulationStarted | (Inherited from System.Windows.UIElement) |
| ManipulationStarting | (Inherited from System.Windows.UIElement) |
| MouseDoubleClick | (Inherited from System.Windows.Controls.Control) |
| MouseDown | (Inherited from System.Windows.UIElement) |
| MouseEnter | (Inherited from System.Windows.UIElement) |
| MouseLeave | (Inherited from System.Windows.UIElement) |
| MouseLeftButtonDown | (Inherited from System.Windows.UIElement) |
| MouseLeftButtonUp | (Inherited from System.Windows.UIElement) |
| MouseMove | (Inherited from System.Windows.UIElement) |
| MouseRightButtonDown | (Inherited from System.Windows.UIElement) |
| MouseRightButtonUp | (Inherited from System.Windows.UIElement) |
| MouseUp | (Inherited from System.Windows.UIElement) |
| MouseWheel | (Inherited from System.Windows.UIElement) |
| PreviewDragEnter | (Inherited from System.Windows.UIElement) |
| PreviewDragLeave | (Inherited from System.Windows.UIElement) |
| PreviewDragOver | (Inherited from System.Windows.UIElement) |
| PreviewDrop | (Inherited from System.Windows.UIElement) |
| PreviewGiveFeedback | (Inherited from System.Windows.UIElement) |
| PreviewGotKeyboardFocus | (Inherited from System.Windows.UIElement) |
| PreviewKeyDown | (Inherited from System.Windows.UIElement) |
| PreviewKeyUp | (Inherited from System.Windows.UIElement) |
| PreviewLostKeyboardFocus | (Inherited from System.Windows.UIElement) |
| PreviewMouseDoubleClick | (Inherited from System.Windows.Controls.Control) |
| PreviewMouseDown | (Inherited from System.Windows.UIElement) |
| PreviewMouseLeftButtonDown | (Inherited from System.Windows.UIElement) |
| PreviewMouseLeftButtonUp | (Inherited from System.Windows.UIElement) |
| PreviewMouseMove | (Inherited from System.Windows.UIElement) |
| PreviewMouseRightButtonDown | (Inherited from System.Windows.UIElement) |
| PreviewMouseRightButtonUp | (Inherited from System.Windows.UIElement) |
| PreviewMouseUp | (Inherited from System.Windows.UIElement) |
| PreviewMouseWheel | (Inherited from System.Windows.UIElement) |
| PreviewQueryContinueDrag | (Inherited from System.Windows.UIElement) |
| PreviewStylusButtonDown | (Inherited from System.Windows.UIElement) |
| PreviewStylusButtonUp | (Inherited from System.Windows.UIElement) |
| PreviewStylusDown | (Inherited from System.Windows.UIElement) |
| PreviewStylusInAirMove | (Inherited from System.Windows.UIElement) |
| PreviewStylusInRange | (Inherited from System.Windows.UIElement) |
| PreviewStylusMove | (Inherited from System.Windows.UIElement) |
| PreviewStylusOutOfRange | (Inherited from System.Windows.UIElement) |
| PreviewStylusSystemGesture | (Inherited from System.Windows.UIElement) |
| PreviewStylusUp | (Inherited from System.Windows.UIElement) |
| PreviewTextInput | (Inherited from System.Windows.UIElement) |
| PreviewTouchDown | (Inherited from System.Windows.UIElement) |
| PreviewTouchMove | (Inherited from System.Windows.UIElement) |
| PreviewTouchUp | (Inherited from System.Windows.UIElement) |
| QueryContinueDrag | (Inherited from System.Windows.UIElement) |
| QueryCursor | (Inherited from System.Windows.UIElement) |
| RangeFiltered | Occurs when a column has just been automatically sorted. |
| RangeFiltering | Occurs when a column is about to be automatically filtered. |
| RangeGroupStateChanged | Occurs after the user has changed the state of the outline (range group) rows or columns. |
| RangeGroupStateChanging | Occurs before the user changes the state of the 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. |
| RequestBringIntoView | (Inherited from System.Windows.FrameworkElement) |
| RowHeightChanged | Occurs when the row height has changed. |
| RowHeightChanging | Occurs when the row height is changing. |
| RowViewportHeightChanged | Occurs when a viewport row height has changed. |
| RowViewportHeightChanging | Occurs when a viewport row height is about to be changed. |
| SelectionChanged | Occurs when the selection of cells on the sheet is 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 System.Windows.FrameworkElement) |
| SourceUpdated | (Inherited from System.Windows.FrameworkElement) |
| StylusButtonDown | (Inherited from System.Windows.UIElement) |
| StylusButtonUp | (Inherited from System.Windows.UIElement) |
| StylusDown | (Inherited from System.Windows.UIElement) |
| StylusEnter | (Inherited from System.Windows.UIElement) |
| StylusInAirMove | (Inherited from System.Windows.UIElement) |
| StylusInRange | (Inherited from System.Windows.UIElement) |
| StylusLeave | (Inherited from System.Windows.UIElement) |
| StylusMove | (Inherited from System.Windows.UIElement) |
| StylusOutOfRange | (Inherited from System.Windows.UIElement) |
| StylusSystemGesture | (Inherited from System.Windows.UIElement) |
| StylusUp | (Inherited from System.Windows.UIElement) |
| TargetUpdated | (Inherited from System.Windows.FrameworkElement) |
| TextInput | (Inherited from System.Windows.UIElement) |
| ToolTipClosing | (Inherited from System.Windows.FrameworkElement) |
| ToolTipOpening | (Inherited from System.Windows.FrameworkElement) |
| TopRowChanged | Occurs when the top row changes. |
| TouchDown | (Inherited from System.Windows.UIElement) |
| TouchEnter | (Inherited from System.Windows.UIElement) |
| TouchLeave | (Inherited from System.Windows.UIElement) |
| TouchMove | (Inherited from System.Windows.UIElement) |
| TouchToolbarOpening | Occurs before GcSpreadSheet shows the touch strip menu bar. |
| TouchUp | (Inherited from System.Windows.UIElement) |
| Unloaded | (Inherited from System.Windows.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 cell value is invalid. |
| ValidationPasting | Occurs when a validator is being pasted. |
| ValueChanged | Occurs when the value in the subeditor changes. |
See Also