Name | Description | |
---|---|---|
GcSpreadSheet Constructor | Initializes a new instance of the 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) | |
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. |
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) |