| 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) |
| 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) |
| 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. |
| ColumnSplitBoxAlignment | Gets or sets the column split box alignment. |
| ColumnSplitBoxPolicy | Gets or sets under which conditions the GcSpreadSheet component permits column splits. |
| 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. |
| DesiredSize | (Inherited from System.Windows.UIElement) |
| Dispatcher | (Inherited from System.Windows.DependencyObject) |
| DocumentUri | Gets or sets the document uri of the sheet. |
| Effect | (Inherited from System.Windows.UIElement) |
| FlowDirection | (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) |
| Foreground | (Inherited from System.Windows.Controls.Control) |
| GridLineColor | Gets or sets the gridline color. |
| 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. |
| InputDeviceType | Returns the last input device type. |
| IsEnabled | (Inherited from System.Windows.Controls.Control) |
| IsHitTestVisible | (Inherited from System.Windows.UIElement) |
| IsTabStop | (Inherited from System.Windows.Controls.Control) |
| Language | (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) |
| Padding | (Inherited from System.Windows.Controls.Control) |
| Parent | (Inherited from System.Windows.FrameworkElement) |
| Projection | (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. |
| 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) |
| TabNavigation | (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) |
| Themes | Gets themes for the control. |
| Triggers | (Inherited from System.Windows.FrameworkElement) |
| 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.UIElement) |
| 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 | |
|---|---|---|
 | DefaultStyleKey | (Inherited from System.Windows.Controls.Control) |
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) |
Public Events
| Name | Description | |
|---|---|---|
 | ActiveSheetChanged | Occurs when the user has changed the active sheet. |
| ActiveSheetChanging | Occurs when the user changes the active sheet. |
| BindingValidationError | (Inherited from System.Windows.FrameworkElement) |
| 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. |
| 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. |
| GotFocus | (Inherited from System.Windows.UIElement) |
| InvalidOperation | Occurs when an invalid operation is performed. |
| IsEnabledChanged | (Inherited from System.Windows.Controls.Control) |
| KeyDown | (Inherited from System.Windows.UIElement) |
| KeyUp | (Inherited from System.Windows.UIElement) |
| LayoutUpdated | (Inherited from System.Windows.FrameworkElement) |
| 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) |
| LostMouseCapture | (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) |
| MouseWheel | (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. |
| 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) |
| TextInput | (Inherited from System.Windows.UIElement) |
| TextInputStart | (Inherited from System.Windows.UIElement) |
| TextInputUpdate | (Inherited from System.Windows.UIElement) |
| TopRowChanged | Occurs when the top row changes. |
| TouchToolbarOpening | Occurs before GcSpreadSheet shows the touch strip menu bar. |
| 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