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) |