Name | Description | |
---|---|---|
![]() | AddControl | Overloaded. Adds a child control to a specified sheet at the location of the specified row and column. |
![]() | AddCustomFunction | Adds a user-defined custom function (GrapeCity.CalcEngine.Function object) to the model for use in formulas. |
![]() | AddNewSheetView | Creates a new SheetView and inserts or replaces the sheet at the specified sheet index. |
![]() | AddViewport | Overloaded. Adds a row or column of viewports. |
![]() | BeginInvoke | Overloaded. (Inherited from System.Windows.Forms.Control) |
![]() | BringToFront | (Inherited from System.Windows.Forms.Control) |
![]() | CancelAnnotationMode | Cancels annotation mode. |
![]() | CancelCellEditing | Cancels cell editing. |
![]() | Contains | (Inherited from System.Windows.Forms.Control) |
![]() | CreateControl | (Inherited from System.Windows.Forms.Control) |
![]() | CreateGraphics | (Inherited from System.Windows.Forms.Control) |
![]() | CreateTableStyle | Creates a table style based on the table style contained in the table style collection or a built-in table style. |
![]() | DrawToBitmap | (Inherited from System.Windows.Forms.Control) |
![]() | EndInvoke | (Inherited from System.Windows.Forms.Control) |
![]() | FindForm | (Inherited from System.Windows.Forms.Control) |
![]() | Focus | (Inherited from System.Windows.Forms.Control) |
![]() | GetActionMap | Gets the action map, that maps action identifiers (for keystrokes) to particular actions. |
![]() | GetActiveColumnViewportIndex | Overloaded. Gets the index of the active viewport column for the active sheet. |
![]() | GetActiveRowViewportIndex | Overloaded. Gets the index of the active viewport row for the active sheet. |
![]() | GetCellFromPixel | Gets the row and column indexes of the cell at the specified pointer location. |
![]() | GetCellRectangle | Gets the rectangle of the cell. |
![]() | GetChildAtPoint | Overloaded. (Inherited from System.Windows.Forms.Control) |
![]() | GetColumnHeaderRectangle | Gets the rectangle of the column header. |
![]() | GetColumnPageBreaks | Overloaded. Gets the column page breaks for the specified sheet under the current printing conditions. |
![]() | GetColumnRangeGroupHeight | Gets the height of the column range group. |
![]() | GetColumnSplitBarRectangle | Gets the rectangle of the column split bar. |
![]() | GetColumnSplitBoxRectangle | Gets the rectangle of the column split box. |
![]() | GetColumnViewportCount | Overloaded. Gets the number of viewport columns in the active sheet. |
![]() | GetColumnViewportIndexFromX | Gets the index of the viewport column for the specified coordinate for the active sheet. |
![]() | GetContainerControl | (Inherited from System.Windows.Forms.Control) |
![]() | GetCursor | Gets the pointer displayed over different areas of the component. |
![]() ![]() | GetExcelSheetNames | Overloaded. Gets an array of sheet names from the specified Excel stream. |
![]() | GetFilterBarHeaderRectangle | Gets the rectangle of the column header. |
![]() | GetFilterBarRectangle | Gets the rectangle of the filter bar. |
![]() | GetHorizontalScrollBarRectangle | Gets the rectangle of the horizontal scroll bar. |
![]() | GetInputMap | Overloaded. Gets the input map defined for the specified focus mode. |
![]() | GetInputMapWhenChildHasFocus | Gets the input map when a child control has keyboard focus. |
![]() | GetInputMapWhenShapeHasFocus | Gets the input map when a shape has keyboard focus. |
![]() | GetMaximumCellOverflowWidth | Gets the maximum cell overflow width in pixels. |
![]() | GetOwnerPrintColumnPageBreaks | Overloaded. Gets the column page breaks for the specified sheet under the current printing conditions. |
![]() | GetOwnerPrintInfo | Gets the printing information required to print a given sheet into the supplied rectangle. |
![]() | GetOwnerPrintPageCount | Gets the number of pages required to print a given sheet into the supplied rectangle. |
![]() | GetOwnerPrintRowPageBreaks | Overloaded. Gets the row page breaks for the specified sheet under the current printing conditions. |
![]() | GetPreferredSize | (Inherited from System.Windows.Forms.Control) |
![]() | GetPrintPageCount | Gets the number of pages required to print the specified sheet. |
![]() | GetPrintPreview | Gets the print preview dialog. |
![]() | GetRootWorkbook | Gets the main workbook associated with the Spread component. |
![]() | GetRowHeaderRectangle | Gets the rectangle of the row header. |
![]() | GetRowPageBreaks | Overloaded. Gets the row page breaks for the specified sheet under the current printing conditions. |
![]() | GetRowRangeGroupWidth | Gets the width of the row range group. |
![]() | GetRowSplitBarRectangle | Gets the rectangle of the row split bar. |
![]() | GetRowSplitBoxRectangle | Gets the rectangle of the row split box. |
![]() | GetRowViewportCount | Overloaded. Gets the number of viewport rows. |
![]() | GetRowViewportIndexFromY | Gets the index of the viewport row for the specified coordinate for the active sheet. |
![]() | GetSheetFromTag | Gets a sheet with a specific tag. |
![]() | GetSheetTabRectangle | Gets the rectangle of the tab associated with a sheet. |
![]() | GetTabSplitBoxRectangle | Gets the rectangle of the split box on the tab strip. |
![]() | GetTabStripRectangle | Gets the rectangle of the tab strip. |
![]() | GetVerticalScrollBarRectangle | Gets the rectangle of the vertical scroll bar. |
![]() | GetViewportBottomRow | Overloaded. Gets the bottom row of cells of the specified viewport row for the active sheet. |
![]() | GetViewportLeftColumn | Overloaded. Gets the leftmost column of cells of the specified viewport column for the active sheet. |
![]() | GetViewportPreferredHeight | Overloaded. Gets the maximum height of the viewport row for the active sheet. |
![]() | GetViewportPreferredWidth | Overloaded. Gets the maximum width of the specified viewport column. |
![]() | GetViewportRectangle | Gets the rectangle of the viewport. |
![]() | GetViewportRightColumn | Overloaded. Gets the rightmost column of cells of the specified viewport column for the active sheet. |
![]() | GetViewportTopRow | Overloaded. Gets the top row of cells of the specified viewport row for the specified sheet. |
![]() | GoalSeek | Attempts to find the value for one cell that produces the desired formula result in another cell. |
![]() | Hide | (Inherited from System.Windows.Forms.Control) |
![]() | HideTouchKeyboard | Hides the touch keyboard. |
![]() | HitTest | Performs a hit test. |
![]() | Invalidate | Overloaded. (Inherited from System.Windows.Forms.Control) |
![]() | Invoke | Overloaded. (Inherited from System.Windows.Forms.Control) |
![]() | IsCellInView | Returns whether the cell at the specified location is visible in the specified view. |
![]() | IsExcelFile | Overloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered an Excel file. |
![]() | IsExcelStream | Overloaded. Opens the specified file and determines whether it meets the minimal requirements to be considered a stream that contains an Excel workbook. |
![]() | IsSpreadSSFile | Opens the specified file and determines whether it meets the minimal requirements to be considered a Spread SS file. |
![]() | IsSpreadXmlFile | Opens the specified file and determines whether it meets the minimal requirements to be considered a Spread XML file. |
![]() | LoadFormulas | Loads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized. |
![]() | LoadXmlInputMapFile | Overloaded. Loads the XML input map file using the specified operation mode. |
![]() | LoadXmlInputMapFileWhenChildHasFocus | Overloaded. Loads the XML input map file when the child has the focus. |
![]() | LoadXmlInputMapFileWhenShapeHasFocus | Overloaded. Loads the XML input map file when the shape has the focus. |
![]() | LogicalToDeviceUnits | (Inherited from System.Windows.Forms.Control) |
![]() | OnClipboardChanging | Raises the ClipboardChanging event. |
![]() | Open | Overloaded. Opens a saved XML file. |
![]() | OpenExcel | Overloaded. Opens an Excel Compound Document File and loads it into Spread. |
![]() | OpenSpreadFile | Opens a saved Spread file. |
![]() | OwnerPrintDraw | Overloaded. Prints the specified page of the specified sheet to a specified graphics interface with the specified size. |
![]() | PerformLayout | Overloaded. Forces the Spread component to apply layout logic to its child controls. |
![]() | PointToClient | (Inherited from System.Windows.Forms.Control) |
![]() | PointToScreen | (Inherited from System.Windows.Forms.Control) |
![]() | PreProcessControlMessage | (Inherited from System.Windows.Forms.Control) |
![]() | PrintSheet | Overloaded. Handles the printing of the specified sheet in a separate thread. |
![]() | RectangleToClient | (Inherited from System.Windows.Forms.Control) |
![]() | RectangleToScreen | (Inherited from System.Windows.Forms.Control) |
![]() | Refresh | (Inherited from System.Windows.Forms.Control) |
![]() | RemoveControl | Removes a child control from the specified sheet. |
![]() | RemoveViewport | Overloaded. Removes a row or column of viewports. |
![]() | Reset | Resets the component to its original state. |
![]() | ResetCellNoteIndicatorRenderer | Resets the focus renderer to its original state. |
![]() | ResetFocusRenderer | Resets the focus renderer to its original state. |
![]() | ResetText | (Inherited from System.Windows.Forms.Control) |
![]() | ResumeLayout | Overloaded. Resumes normal layout logic. |
![]() | Save | Overloaded. Saves the content of the Spread component to the specified file. |
![]() | SaveExcel | Overloaded. Saves the content of the Spread component to the specified stream. |
![]() | SaveXmlInputMapFile | Overloaded. Saves the XML input map file. |
![]() | SaveXmlInputMapFileWhenChildHasFocus | Overloaded. Saves the XML input map file when child has focus. |
![]() | SaveXmlInputMapFileWhenShapeHasFocus | Overloaded. Saves the XML input map file when shape has focus. |
![]() | Scale | (Inherited from System.Windows.Forms.Control) |
![]() | ScaleBitmapLogicalToDevice | (Inherited from System.Windows.Forms.Control) |
![]() | Search | Overloaded. Searches the text in the specified range of cells in the specified sheet for the specified string with the specified criteria. |
![]() | SearchHeaders | Overloaded. Searches the text in the header cells in the specified sheet for the specified string. |
![]() | SearchWithDialog | Overloaded. Searches the text in the cells of the active sheet for the search string with the default criteria using a provided search dialog. |
![]() | SearchWithDialogAdvanced | Overloaded. Searches the text in the cells of the sheets for the search string with the default criteria using a provided advanced search dialog. |
![]() | SelectNextControl | (Inherited from System.Windows.Forms.Control) |
![]() | SendToBack | (Inherited from System.Windows.Forms.Control) |
![]() | SetActionMap | Sets the action map, that maps action identifiers (for keystrokes) to particular actions. |
![]() | SetActiveViewport | Overloaded. Sets the active viewport for the active sheet. |
![]() | SetBounds | Overloaded. (Inherited from System.Windows.Forms.Control) |
![]() | SetCursor | Sets the pointer displayed over different areas of the component. |
![]() | SetInputMap | Overloaded. Sets the input map for the specified focus mode. |
![]() | SetInputMapWhenChildHasFocus | Sets the input map when a child control has keyboard focus. |
![]() | SetInputMapWhenShapeHasFocus | Sets the input map when a shape has keyboard focus. |
![]() | SetInsertSheetImage | Sets the custom image displayed on the insert sheet tab. |
![]() | SetMaximumCellOverflowWidth | Sets the maximum cell overflow width in pixels. |
![]() | SetPrintInfo | Sets the PrintInfo object for the specfied sheet. |
![]() | SetPrintPreview | Sets the print preview dialog. |
![]() | SetProtect | Changes the protect structure setting with the password parameter. |
![]() | SetViewportLeftColumn | Overloaded. Sets the leftmost column of cells of the specified viewport column for the active sheet. |
![]() | SetViewportPreferredHeight | Overloaded. Sets the maximum height of the specified viewport row for the active sheet. |
![]() | SetViewportPreferredWidth | Overloaded. Sets the maximum width of the specified viewport column for the active sheet. |
![]() | SetViewportTopRow | Overloaded. Sets the top row of cells of the specified viewport row for the active sheet. |
![]() | Show | (Inherited from System.Windows.Forms.Control) |
![]() | ShowActiveCell | Moves the active cell to the specified position in the component. |
![]() | ShowCell | Moves the specified cell in the specified viewport to the specified position in the component. |
![]() | ShowCellValidatorsForm | Shows the form that is used to edit Cell Validators of selected range |
![]() | ShowCollectionEditor | Shows the collection editor. |
![]() | ShowColumn | Moves a column of cells in the specified viewport to the specified position in the component. |
![]() | ShowDataValidationForm | Shows the form that is used to edit DataValidation of selected range |
![]() | ShowDependents | Shows the dependent cells for a formula cell. |
![]() | ShowEditForm | Displays the form used for editing custom names. |
![]() | ShowInputMapEditor | Displays the input map editor. |
![]() | ShowListCustomNameForm | Displays the form that contains a list of custom names. |
![]() | ShowPageSetup | Overloaded. Shows the page setup dialog with the specified buttons for the specified sheet. |
![]() | ShowPrecedents | Shows the cells that are referred to by formulas in other cells. |
![]() | ShowRow | Moves a row in the specified viewport to the specified position in the component. |
![]() | ShowTouchKeyboard | Displays the touch keyboard. |
![]() | StartAnnotationMode | Overloaded. Starts annotation mode. |
![]() | StartCellEditing | Starts cell editing. |
![]() | StartInkNotation | Overloaded. Starts ink notation in the active viewport if the Microsoft.Ink assembly is found in the GAC. |
![]() | StopAnnotationMode | Stops annotation mode. |
![]() | StopCellEditing | Stops cell editing. |
![]() | SuspendLayout | Temporarily suspends the layout logic for this component. |
![]() | ToString | (Inherited from System.ComponentModel.Component) |
![]() | TriggerVolatileCells | This function will notify all cells, which contains volatile functions or belong to a circuit, to recalculate. |
![]() | Update | (Inherited from System.Windows.Forms.Control) |