Spread Silverlight Documentation
GcSpreadSheet Class Members
Fields  Properties  Methods  Events


The following tables list the members exposed by GcSpreadSheet.

Public Constructors
 NameDescription
Public ConstructorGcSpreadSheet ConstructorInitializes a new instance of the GcSpreadSheet class.  
Top
Public Fields
 NameDescription
Public Fieldstatic (Shared in Visual Basic)HeaderGridLineColorProperty  
Top
Public Properties
 NameDescription
Public PropertyActiveSheetGets the active sheet in the GrapeCity.Windows.SpreadSheet.UI.GcSpread control.  
Public PropertyActiveSheetIndexGets or sets the index of the active sheet in the GrapeCity.Windows.SpreadSheet.UI.GcSpread control.  
Public PropertyActualHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyActualWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyAllowDrop (Inherited from System.Windows.UIElement)
Public PropertyAutoClipboardGets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public PropertyAutoRecalculationGets or sets whether the formula is automatically calculated.  
Public PropertyAutoRefreshGets or sets whether the SpreadSheet can auto-refresh itself.  
Public PropertyBackground (Inherited from System.Windows.Controls.Control)
Public PropertyBorderBrush (Inherited from System.Windows.Controls.Control)
Public PropertyBorderThickness (Inherited from System.Windows.Controls.Control)
Public PropertyCacheMode (Inherited from System.Windows.UIElement)
Public PropertyCanCellOverflowGets or sets whether data can overflow into adjacent empty cells in the component.  
Public PropertyCanEditOverflowGets or sets whether data can overflow into adjacent empty cells in the component while that cell is in edit mode.  
Public PropertyCanTouchMultiSelectIndicates whether the user can select multiple ranges by touch.  
Public PropertyCanUserDragDropGets or sets whether to allow the user to drag and drop cell range data to another range.  
Public PropertyCanUserDragFillGets or sets whether to allow the user to drag fill a range of cells.  
Public PropertyCanUserEditFormulaGets or sets whether to allow the user to enter formulas in a cell in the component.  
Public PropertyCanUserUndoGets or sets whether to allow the user to undo edit operations.  
Public PropertyCanUserZoomGets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.  
Public PropertyClip (Inherited from System.Windows.UIElement)
Public PropertyClipBoardOptionsGets or sets whether the component handles the shortcut keys for Clipboard actions.  
Public PropertyColumnSplitBoxAlignmentGets or sets the column split box alignment.  
Public PropertyColumnSplitBoxPolicyGets or sets under which conditions the GcSpreadSheet component permits column splits.  
Public PropertyCurrentThemeGets or sets the current theme information for the control.  
Public PropertyCurrentThemeNameGets or sets the current theme information for the control.  
Public PropertyCursor (Inherited from System.Windows.FrameworkElement)
Public PropertyDataContext (Inherited from System.Windows.FrameworkElement)
Public PropertyDefaultAutoFillTypeGets or sets the default type of the automatic fill.  
Public PropertyDesiredSize (Inherited from System.Windows.UIElement)
Public PropertyDispatcher (Inherited from System.Windows.DependencyObject)
Public PropertyDocumentUriGets or sets the document uri of the sheet.  
Public PropertyEffect (Inherited from System.Windows.UIElement)
Public PropertyFlowDirection (Inherited from System.Windows.FrameworkElement)
Public PropertyFontFamily (Inherited from System.Windows.Controls.Control)
Public PropertyFontSize (Inherited from System.Windows.Controls.Control)
Public PropertyFontStretch (Inherited from System.Windows.Controls.Control)
Public PropertyFontStyle (Inherited from System.Windows.Controls.Control)
Public PropertyFontWeight (Inherited from System.Windows.Controls.Control)
Public PropertyForeground (Inherited from System.Windows.Controls.Control)
Public PropertyGridLineColorGets or sets the gridline color.  
Public PropertyHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyHighlightInvalidDataSpecifies whether to highlight invalid data.  
Public PropertyHorizontalAlignment (Inherited from System.Windows.FrameworkElement)
Public PropertyHorizontalContentAlignment (Inherited from System.Windows.Controls.Control)
Public PropertyHorizontalScrollBarHeightGets or sets the height of horizontal scroll bars in this control.  
Public PropertyHorizontalScrollBarStyleGets or sets the horizontal scroll bar style.  
Public PropertyHorizontalScrollBarVisibilityGets or sets the horizontal scroll bar visibility setting.  
Public PropertyInputDeviceTypeReturns the last input device type.  
Public PropertyIsEnabled (Inherited from System.Windows.Controls.Control)
Public PropertyIsHitTestVisible (Inherited from System.Windows.UIElement)
Public PropertyIsTabStop (Inherited from System.Windows.Controls.Control)
Public PropertyLanguage (Inherited from System.Windows.FrameworkElement)
Public PropertyMargin (Inherited from System.Windows.FrameworkElement)
Public PropertyMaxHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyMaxWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyMinHeight (Inherited from System.Windows.FrameworkElement)
Public PropertyMinWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyName (Inherited from System.Windows.FrameworkElement)
Public PropertyNamedStylesGets or sets a collection of GrapeCity.Windows.SpreadSheet.Data.StyleInfo objects for this sheet.  
Public PropertyOpacity (Inherited from System.Windows.UIElement)
Public PropertyOpacityMask (Inherited from System.Windows.UIElement)
Public PropertyPadding (Inherited from System.Windows.Controls.Control)
Public PropertyParent (Inherited from System.Windows.FrameworkElement)
Public PropertyProjection (Inherited from System.Windows.UIElement)
Public PropertyProtectGets or sets whether this workbook is protected.  
Public PropertyRangeGroupBackgroundGets or sets the backgroud of the range group  
Public PropertyRangeGroupBorderBrushGets or sets the brush of the border of the range group  
Public PropertyRangeGroupLineStrokeGets or sets the stroke of the group line  
Public PropertyReferenceStyleGets or sets the style for cell and range references in cell formulas on this sheet.  
Public PropertyRenderSize (Inherited from System.Windows.UIElement)
Public PropertyRenderTransform (Inherited from System.Windows.UIElement)
Public PropertyRenderTransformOrigin (Inherited from System.Windows.UIElement)
Public PropertyResizeZeroIndicatorSpecifies the drawing policy when the row or column is resized to zero.  
Public PropertyResources (Inherited from System.Windows.FrameworkElement)
Public PropertyRowSplitBoxAlignmentGets or sets the row split box alignment.  
Public PropertyRowSplitBoxPolicyGets or sets under which conditions the GcSpreadSheet component permits row splits.  
Public PropertyScrollBarTrackPolicyGets or sets whether the sheet in the control scrolls when the user moves the scroll box.  
Public PropertySheetCountGets or sets the number of sheets for this control.  
Public PropertySheetsGets or sets the GrapeCity.Windows.SpreadSheet.Data.Worksheet collection for the GcSpreadSheet control.  
Public PropertyShowColumnRangeGroupGets or sets whether the column range group is visible.  
Public PropertyShowDragDropTipGets or sets a value that indicates whether to display the drag drop tip.  
Public PropertyShowDragFillTipGets or sets a value that indicates whether to show the drag fill tip.  
Public PropertyShowFreezeLineGets or sets a value that indicates whether to show freeze lines.  
Public PropertyShowGridLineGets or sets whether gridlines are displayed.  
Public PropertyShowResizeTipGets or sets how to display the resize tip.  
Public PropertyShowRowRangeGroupGets or sets whether the row range group is visible.  
Public PropertyShowScrollTipGets or sets how to display the scroll tip.  
Public PropertyStartSheetIndexGets or sets the index of the start sheet in the GrapeCity.Windows.SpreadSheet.UI.GcSpread control.  
Public PropertyStyle (Inherited from System.Windows.FrameworkElement)
Public PropertyTabIndex (Inherited from System.Windows.Controls.Control)
Public PropertyTabNavigation (Inherited from System.Windows.Controls.Control)
Public PropertyTabStripEditableGets or sets whether the tab strip is editable.  
Public PropertyTabStripInsertTabGets or sets whether a special tab is displayed that allows inserting new sheets.  
Public PropertyTabStripRatioGets or sets the width of the tab strip for this component expressed as a percentage of the overall horizontal scroll bar width.  
Public PropertyTabStripVisibilityGets or sets the display policy for the sheet tab strip for this component.  
Public PropertyTag (Inherited from System.Windows.FrameworkElement)
Public PropertyTemplate (Inherited from System.Windows.Controls.Control)
Public PropertyThemesGets themes for the control.  
Public PropertyTriggers (Inherited from System.Windows.FrameworkElement)
Public PropertyUndoManagerGets the undo manager for the control.  
Public PropertyUseLayoutRounding (Inherited from System.Windows.UIElement)
Public PropertyVerticalAlignment (Inherited from System.Windows.FrameworkElement)
Public PropertyVerticalContentAlignment (Inherited from System.Windows.Controls.Control)
Public PropertyVerticalScrollBarStyleGets or sets the vertical scroll bar style.  
Public PropertyVerticalScrollBarVisibilityGets or sets the vertical scroll bar visibility setting.  
Public PropertyVerticalScrollBarWidthGets or sets the width of vertical scroll bars in this control.  
Public PropertyViewGets the spread view associated with the control.  
Public PropertyVisibility (Inherited from System.Windows.UIElement)
Public PropertyWidth (Inherited from System.Windows.FrameworkElement)
Public PropertyWorkbookGets the workbook associated with the control.  
Top
Protected Properties
 NameDescription
Protected PropertyDefaultStyleKey (Inherited from System.Windows.Controls.Control)
Top
Public Methods
 NameDescription
Public MethodAddColumnViewportAdds a new column viewport to the control.  
Public MethodAddCustomFunctionAdds a custom function to the workbook.  
Public MethodAddHandler (Inherited from System.Windows.UIElement)
Public MethodAddRowViewportAdds a new row viewport to the control.  
Public MethodApplyTemplate (Inherited from System.Windows.Controls.Control)
Public MethodArrange (Inherited from System.Windows.UIElement)
Public MethodAutoFitColumnOverloaded. Automatically fits the viewport column.  
Public MethodAutoFitRowOverloaded. Automatically fits the viewport row.  
Public MethodCaptureMouse (Inherited from System.Windows.UIElement)
Public MethodClearCustomFunctionsRemoves all user-defined custom functions (FunctionInfo object) on this sheet.  
Public MethodClearCustomNameClears the custom name in the workbook.  
Public MethodClearCustomNamesRemoves all custom names on this workbook.  
Public MethodClearValue (Inherited from System.Windows.DependencyObject)
Public MethodDoCommandExecutes a command.  
Public MethodFindName (Inherited from System.Windows.FrameworkElement)
Public MethodFocus (Inherited from System.Windows.Controls.Control)
Public MethodGetActiveColumnViewportIndexGets the current active column viewport index in the control.  
Public MethodGetActiveRowViewportIndexGets the current active row viewport index in the control.  
Public MethodGetAnimationBaseValue (Inherited from System.Windows.DependencyObject)
Public MethodGetBindingExpression (Inherited from System.Windows.FrameworkElement)
Public MethodGetColumnViewportCountGets the column viewport count in the control.  
Public MethodGetCustomFunctionGets a custom function from the workbook.  
Public MethodGetCustomNameGets custom name information from the workbook.  
Public MethodGetRowViewportCountGets the row viewport count in the control.  
Public MethodGetValue (Inherited from System.Windows.DependencyObject)
Public MethodGetViewportBottomRowGets the row viewport's bottom row index.  
Public MethodGetViewportLeftColumnGets the column viewport's left column index.  
Public MethodGetViewportRightColumnGets the column viewport's right column index.  
Public MethodGetViewportTopRowGets the row viewport's top row index.  
Public MethodHitTestPerforms a hit test.  
Public MethodInvalidateInvalidates the measurement state (layout) and the arrangement state (layout) for the control. After the invalidation, the control layout and data are updated.  
Public MethodInvalidateArrange (Inherited from System.Windows.UIElement)
Public MethodInvalidateChartsOverloaded. Invalidates the charts.  
Public MethodInvalidateColumnsOverloaded. Invalidates the column state in the control. After the invalidation, the column layout and data are updated.  
Public MethodInvalidateCustomFloatingObjectsOverloaded. Invalidates the custom floating objects.  
Public MethodInvalidateFloatingObjectsOverloaded. Invalidates the charts.  
Public MethodInvalidateMeasure (Inherited from System.Windows.UIElement)
Public MethodInvalidatePicturesOverloaded. Invalidates the pictures.  
Public MethodInvalidateRangeOverloaded. Invalidates a range state in the control. After the invalidation, the range layout and data are updated.  
Public MethodInvalidateRowsOverloaded. Invalidates the row state in the control. After the invalidation, the row layout and data are updated.  
Public MethodInvalidateSheetInvalidates the measurement state (layout) and the arrangement state (layout) for the view. After the invalidation, the view layout and data are updated.  
Public MethodInvalidateSurfaceChartInvalidates the surface chart.  
Public MethodInvalidateSurfaceChartsInvalidates the surface charts.  
Public MethodMeasure (Inherited from System.Windows.UIElement)
Public MethodOnApplyTemplateOverridden. Is invoked whenever application code or internal processes call FrameworkElement.ApplyTemplate, when overridden in a derived class.  
Public MethodOpenCSVOverloaded. Loads the CSV (comma-separated values) file.  
Public MethodOpenExcelOverloaded. Opens an Excel Compound Document File and loads it into GcSpreadSheet.  
Public MethodOpenTextFileLoads the CSV file with the specified separator.  
Public MethodOpenXmlLoads the data on the sheet from the specified XML stream.  
Public MethodPrintOverloaded. Prints the specified sheet.  
Public MethodReadLocalValue (Inherited from System.Windows.DependencyObject)
Public MethodReleaseMouseCapture (Inherited from System.Windows.UIElement)
Public MethodRemoveColumnViewportRemoves a column viewport from the control.  
Public MethodRemoveCustomFunctionsRemoves a custom function from the workbook.  
Public MethodRemoveHandler (Inherited from System.Windows.UIElement)
Public MethodRemoveRowViewportRemoves a row viewport from the control.  
Public MethodResetThemesResets the changed theme color and font name.  
Public MethodResumeCalcServiceResumes the calculation service.  
Public MethodResumeEventResumes the event.  
Public MethodSaveCSVOverloaded. Saves the CSV (comma-separated values) file.  
Public MethodSaveExcelOverloaded. Saves GcSpreadSheet to an Excel Compound Document File.  
Public MethodSavePdfOverloaded. Saves the content of the component to the specified stream.  
Public MethodSaveTextFileRangeSaves the range of cells in the specified sheet as delimited text with the specified delimiters, to a stream.  
Public MethodSaveXmlOverloaded. Saves the data on the sheet to the specified XML stream.  
Public MethodSearchOverloaded. Searches the text in the cells in the specified sheet.  
Public MethodSetActiveViewportActivates a viewport in the control.  
Public MethodSetBinding (Inherited from System.Windows.FrameworkElement)
Public MethodSetCustomNameOverloaded. Sets a custom name formula to the workbook.  
Public MethodSetValue (Inherited from System.Windows.DependencyObject)
Public MethodSetViewportLeftColumnSets the column viewport's left column.  
Public MethodSetViewportTopRowSets the row viewport's top row.  
Public MethodShowActiveCellMoves the current active cell to the specified position.  
Public MethodShowCellMoves a cell to the specified position.  
Public MethodShowColumnMoves a column to the specified position.  
Public MethodShowRowMoves a row to the specified position.  
Public MethodSuspendCalcServiceSuspends the calculation service.  
Public MethodSuspendEventSuspends the event.  
Public MethodTransformToVisual (Inherited from System.Windows.UIElement)
Public MethodUpdateLayout (Inherited from System.Windows.UIElement)
Top
Protected Methods
 NameDescription
Protected MethodArrangeOverride (Inherited from System.Windows.FrameworkElement)
Protected MethodGetTemplateChild (Inherited from System.Windows.Controls.Control)
Protected MethodMeasureOverride (Inherited from System.Windows.FrameworkElement)
Protected MethodOnCreateAutomationPeer (Inherited from System.Windows.UIElement)
Protected MethodOnDragEnter (Inherited from System.Windows.Controls.Control)
Protected MethodOnDragLeave (Inherited from System.Windows.Controls.Control)
Protected MethodOnDragOver (Inherited from System.Windows.Controls.Control)
Protected MethodOnDrop (Inherited from System.Windows.Controls.Control)
Protected MethodOnGotFocus (Inherited from System.Windows.Controls.Control)
Protected MethodOnKeyDown (Inherited from System.Windows.Controls.Control)
Protected MethodOnKeyUp (Inherited from System.Windows.Controls.Control)
Protected MethodOnLostFocus (Inherited from System.Windows.Controls.Control)
Protected MethodOnLostMouseCapture (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseEnter (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseLeave (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseLeftButtonDown (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseLeftButtonUp (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseMove (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseRightButtonDown (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseRightButtonUp (Inherited from System.Windows.Controls.Control)
Protected MethodOnMouseWheel (Inherited from System.Windows.Controls.Control)
Protected MethodOnTextInputOverridden. 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.  
Protected MethodOnTextInputStart (Inherited from System.Windows.Controls.Control)
Protected MethodOnTextInputUpdate (Inherited from System.Windows.Controls.Control)
Top
Public Events
 NameDescription
Public EventActiveSheetChangedOccurs when the user has changed the active sheet.  
Public EventActiveSheetChangingOccurs when the user changes the active sheet.  
Public EventBindingValidationError (Inherited from System.Windows.FrameworkElement)
Public EventCellClickOccurs when the user presses down the left mouse button in a cell.  
Public EventCellDoubleClickOccurs when the user presses down the left mouse button twice (double-clicks) in a cell.  
Public EventCellTextRenderingOccurs when the cell text is rendering.  
Public EventCellValueApplyingOccurs when [cell value applying].  
Public EventClipboardChangedOccurs when a Clipboard change occurs that can effect the GcSpreadSheet control.  
Public EventClipboardChangingOccurs when the Clipboard is changing due to a GcSpreadSheet action.  
Public EventClipboardPastedOccurs when the user pastes from the Clipboard.  
Public EventClipboardPastingOccurs when the user pastes from the Clipboard.  
Public EventColumnViewportWidthChangedOccurs when a viewport column width has changed.  
Public EventColumnViewportWidthChangingOccurs when a viewport column is about to be changed.  
Public EventColumnWidthChangedOccurs when the column width has changed.  
Public EventColumnWidthChangingOccurs when the column width is changing.  
Public EventDataValidationListPopupOpeningOccurs when a data validation list popup is opening.  
Public EventDragDropBlockOccurs when the user drags and drops a range of cells.  
Public EventDragDropBlockCompletedOccurs at the completion of the user dragging and dropping a range of cells.  
Public EventDragEnter (Inherited from System.Windows.UIElement)
Public EventDragFillBlockOccurs when the user drags to fill a range of cells.  
Public EventDragFillBlockCompletedOccurs at the completion of the user dragging to fill a range of cells.  
Public EventDragLeave (Inherited from System.Windows.UIElement)
Public EventDragOver (Inherited from System.Windows.UIElement)
Public EventDrop (Inherited from System.Windows.UIElement)
Public EventEditChangeOccurs when a cell is in edit mode and the text is changed.  
Public EventEditEndOccurs when a cell leaves edit mode.  
Public EventEditStartingOccurs when a cell goes in edit mode.  
Public EventEnterCellOccurs when the user enters a cell.  
Public EventExcelErrorOccurs when an error occurs during loading or saving an Excel-formatted file.  
Public EventFilterPopupOpeningOccurs when the filter popup is opening.  
Public EventFloatingObjectPastedOccurs when the floating object is pasted.  
Public EventGotFocus (Inherited from System.Windows.UIElement)
Public EventInvalidOperationOccurs when an invalid operation is performed.  
Public EventIsEnabledChanged (Inherited from System.Windows.Controls.Control)
Public EventKeyDown (Inherited from System.Windows.UIElement)
Public EventKeyUp (Inherited from System.Windows.UIElement)
Public EventLayoutUpdated (Inherited from System.Windows.FrameworkElement)
Public EventLeaveCellOccurs when the user leaves a cell.  
Public EventLeftColumnChangedOccurs when the left column changes.  
Public EventLoaded (Inherited from System.Windows.FrameworkElement)
Public EventLostFocus (Inherited from System.Windows.UIElement)
Public EventLostMouseCapture (Inherited from System.Windows.UIElement)
Public EventMouseEnter (Inherited from System.Windows.UIElement)
Public EventMouseLeave (Inherited from System.Windows.UIElement)
Public EventMouseLeftButtonDown (Inherited from System.Windows.UIElement)
Public EventMouseLeftButtonUp (Inherited from System.Windows.UIElement)
Public EventMouseMove (Inherited from System.Windows.UIElement)
Public EventMouseRightButtonDown (Inherited from System.Windows.UIElement)
Public EventMouseRightButtonUp (Inherited from System.Windows.UIElement)
Public EventMouseWheel (Inherited from System.Windows.UIElement)
Public EventRangeFilteredOccurs when a column has just been automatically sorted.  
Public EventRangeFilteringOccurs when a column is about to be automatically filtered.  
Public EventRangeGroupStateChangedOccurs after the user has changed the state of the outline (range group) rows or columns.  
Public EventRangeGroupStateChangingOccurs before the user changes the state of the outline (range group) rows or columns.  
Public EventRangeSortedOccurs when a column has just been automatically sorted.  
Public EventRangeSortingOccurs when a column is about to be automatically sorted.  
Public EventRowHeightChangedOccurs when the row height has changed.  
Public EventRowHeightChangingOccurs when the row height is changing.  
Public EventRowViewportHeightChangedOccurs when a viewport row height has changed.  
Public EventRowViewportHeightChangingOccurs when a viewport row height is about to be changed.  
Public EventSelectionChangedOccurs when the selection of cells on the sheet is changed.  
Public EventSelectionChangingOccurs when the selection of cells on the sheet is changing.  
Public EventSheetTabClickOccurs when the user clicks the sheet tab.  
Public EventSheetTabDoubleClickOccurs when the user double-clicks the sheet tab.  
Public EventSizeChanged (Inherited from System.Windows.FrameworkElement)
Public EventTextInput (Inherited from System.Windows.UIElement)
Public EventTextInputStart (Inherited from System.Windows.UIElement)
Public EventTextInputUpdate (Inherited from System.Windows.UIElement)
Public EventTopRowChangedOccurs when the top row changes.  
Public EventTouchToolbarOpeningOccurs before GcSpreadSheet shows the touch strip menu bar.  
Public EventUnloaded (Inherited from System.Windows.FrameworkElement)
Public EventUserFormulaEnteredOccurs when the user types a formula.  
Public EventUserZoomingOccurs when the user zooms.  
Public EventValidationDragDropBlockOccurs when the user drags and drops a range of cells.  
Public EventValidationErrorOccurs when the cell value is invalid.  
Public EventValidationPastingOccurs when a validator is being pasted.  
Public EventValueChangedOccurs when the value in the subeditor changes.  
Top
See Also

Reference

GcSpreadSheet Class
GrapeCity.Windows.SpreadSheet.UI Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.