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 | (Inherited from System.Windows.UIElement) |
| AddRowViewport | Adds a new row viewport to the control. |
| ApplyTemplate | (Inherited from System.Windows.Controls.Control) |
| Arrange | (Inherited from System.Windows.UIElement) |
| AutoFitColumn | Overloaded. Automatically fits the viewport column. |
| AutoFitRow | Overloaded. Automatically fits the viewport row. |
| CaptureMouse | (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 | (Inherited from System.Windows.DependencyObject) |
| DoCommand | Executes a command. |
| FindName | (Inherited from System.Windows.FrameworkElement) |
| Focus | (Inherited from System.Windows.Controls.Control) |
| 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.DependencyObject) |
| 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. |
| 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. |
| 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. |
| 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. |
| Measure | (Inherited from System.Windows.UIElement) |
| 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 | Loads the data on the sheet from the specified XML stream. |
| Overloaded. Prints the specified sheet. | |
| ReadLocalValue | (Inherited from System.Windows.DependencyObject) |
| ReleaseMouseCapture | (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 stream. |
| 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 stream. |
| Search | Overloaded. Searches the text in the cells in the specified sheet. |
| SetActiveViewport | Activates a viewport in the control. |
| SetBinding | (Inherited from System.Windows.FrameworkElement) |
| SetCustomName | Overloaded. Sets a custom name formula to the workbook. |
| SetValue | (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. |
| TransformToVisual | (Inherited from System.Windows.UIElement) |
| UpdateLayout | (Inherited from System.Windows.UIElement) |
Protected Methods
| Name | Description | |
|---|---|---|
 | ArrangeOverride | (Inherited from System.Windows.FrameworkElement) |
| GetTemplateChild | (Inherited from System.Windows.Controls.Control) |
| MeasureOverride | (Inherited from System.Windows.FrameworkElement) |
| OnCreateAutomationPeer | (Inherited from System.Windows.UIElement) |
| OnDragEnter | (Inherited from System.Windows.Controls.Control) |
| OnDragLeave | (Inherited from System.Windows.Controls.Control) |
| OnDragOver | (Inherited from System.Windows.Controls.Control) |
| OnDrop | (Inherited from System.Windows.Controls.Control) |
| OnGotFocus | (Inherited from System.Windows.Controls.Control) |
| OnKeyDown | (Inherited from System.Windows.Controls.Control) |
| OnKeyUp | (Inherited from System.Windows.Controls.Control) |
| OnLostFocus | (Inherited from System.Windows.Controls.Control) |
| OnLostMouseCapture | (Inherited from System.Windows.Controls.Control) |
| OnMouseEnter | (Inherited from System.Windows.Controls.Control) |
| OnMouseLeave | (Inherited from System.Windows.Controls.Control) |
| OnMouseLeftButtonDown | (Inherited from System.Windows.Controls.Control) |
| OnMouseLeftButtonUp | (Inherited from System.Windows.Controls.Control) |
| OnMouseMove | (Inherited from System.Windows.Controls.Control) |
| OnMouseRightButtonDown | (Inherited from System.Windows.Controls.Control) |
| OnMouseRightButtonUp | (Inherited from System.Windows.Controls.Control) |
| OnMouseWheel | (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. |
| OnTextInputStart | (Inherited from System.Windows.Controls.Control) |
| OnTextInputUpdate | (Inherited from System.Windows.Controls.Control) |
See Also