For a list of all members of this type, see GcSpreadSheet members.
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 sheet 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) |
| 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) |
See Also