GrapeCity.Windows.SpreadSheet.UI Namespace : GcSpreadSheet Class |
The following tables list the members exposed by GcSpreadSheet.
Name | Description | |
---|---|---|
GcSpreadSheet Constructor | Initializes a new instance of the GcSpreadSheet class. |
Name | Description | |
---|---|---|
HeaderGridLineColorProperty |
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. | |
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. |
Name | Description | |
---|---|---|
DefaultStyleKey | (Inherited from System.Windows.Controls.Control) |
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) |
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) |
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. |