GrapeCity.Xaml.SpreadSheet.Data
Worksheet Class Methods


GrapeCity.Xaml.SpreadSheet.Data Namespace : Worksheet Class

For a list of all members of this type, see Worksheet members.

Public Methods
 NameDescription
Public MethodOverloaded.  Adds the chart in the sheet.  
Public MethodOverloaded.  Adds the column or columns to the data model at the specified index.  
Public Method Adds the column viewport.  
Public Method Adds the specified user-defined custom function to the collection.  
Public MethodOverloaded.  Adds the picture.  
Public MethodOverloaded.  Adds rows in this sheet.  
Public Method Adds the row viewport.  
Public MethodOverloaded.  Adds a cell range to the selection.  
Public MethodOverloaded.  Adds a span of cells in this sheet in the specified sheet area.  
Public MethodOverloaded.  Adds a range table with a specified size to the sheet.  
Public Method Binds the column to the data source column for a sheet.  
Public MethodOverloaded.  Clears the specified area.  
Public Method Removes all user-defined custom functions (FunctionInfo object) on this sheet.  
Public Method Clears the specified name in the name collection.  
Public Method Removes all custom names on this sheet.  
Public MethodOverloaded.  Clears the specified selection range from the selection list, if one exists.  
Public Method Clears the selections.  
Public Method Clears the span that contains a specified anchor cell from a range of cells in the specified sheet area.  
Public Method Copies data from one range to another.  
Public Method Specifies the last cell in the selection of cells.  
Public MethodOverloaded.  Fills the specified range in the specified direction.  
Public MethodOverloaded.  Fills the specified range when the source value type is date.  
Public MethodOverloaded.  Fills the specified range growth trend when the source value type is number.  
Public MethodOverloaded.  Fills the specified range linear trend when the source value type is number.  
Public Method Finds the chart with specified name.  
Public Method Finds the floating object with specified name.  
Public Method Gets formulas in the specified area.  
Public Method Finds the picture with specified name.  
Public MethodOverloaded.  Gets the table of the specified cell.  
Public Method Gets the index of the active column viewport.  
Public Method Gets the index of the active row viewport.  
Public Method Gets whether a column in the specified sheet area is displayed.  
Public MethodOverloaded.  Gets the width in pixels for the specified column in the specified sheet area.  
Public MethodOverloaded.  Gets the height in pixels for the specified row in the specified sheet area.  
Public Method Gets whether the control displays the specified row in the specified sheet area.  
Public MethodOverloaded.  Gets the actual style information for a specified cell in the specified sheet area.  
Public MethodOverloaded.  Gets an object array from a specified range of cells.  
Public Method Gets the formula in the specified area in this sheet.  
Public Method Gets the automatic text displayed in the column header for the specified column.  
Public Method Gets the column data type at the specified position.  
Public MethodOverloaded.  Gets the text in the specified column header cell.  
Public MethodOverloaded.  Gets a value that indicates whether the user can resize a specified column in the specified sheet area.  
Public Method Gets the column viewport count.  
Public MethodOverloaded.  Gets whether a column in this sheet is displayed.  
Public MethodOverloaded.  Gets the width in pixels for the specified column in the specified sheet area.  
Public MethodOverloaded.  Gets the CSV text from a range.  
Public Method Gets the specified user-defined custom function.  
Public Method Finds the specified custom name.  
Public Method Gets the column name at the specified position.  
Public Method Gets the data bar object or icon object of the current sheet in the specified range.  
Public Method  
Public Method Gets the formula in the specified cell in this sheet.  
Public Method Gets the control gridline; the gridline color is based on the ShowGridLine property.  
Public Method Gets the last dirty column index.  
Public Method Gets the last dirty row index.  
Public Method Returns a list of nonempty column indexes.  
Public Method Returns a list of nonempty row indexes.  
Public Method Gets the automatic text displayed in the row header for the specified row.  
Public MethodOverloaded.  Gets the height using the specified unit type for the specified row in the specified sheet area.  
Public MethodOverloaded.  Gets the text in the specified row header cell.  
Public MethodOverloaded.  Gets a value that indicates whether users can resize the specified row in the specified sheet area.  
Public Method Gets the row viewport count.  
Public MethodOverloaded.  Gets whether the control displays the specified row.  
Public MethodOverloaded.  Gets the range of cells that are spanned at a specified cell in this sheet.  
Public Method Gets the sparkline for the specified cell.  
Public MethodOverloaded.  Gets the style information of the specified cell, row, or column.  
Public MethodOverloaded.  Gets the name of the style assigned to a cell, column, row, or default model in the specified sheet area.  
Public Method Gets the sheet tables.  
Public MethodOverloaded.  Gets the application-defined tag value for the specified cell, column, row, or entire sheet in the specified sheet area.  
Public MethodOverloaded. Gets the formatted text in the cell in the specified sheet area using the IFormatter object for the cell.  
Public MethodOverloaded.  Gets unformatted data from the specified cell.  
Public Method Gets the height of the viewport.  
Public Method Gets the viewport information of the current sheet.  
Public Method Gets the viewport left column.  
Public Method Gets the viewport top row.  
Public Method Gets the width of the viewport.  
Public Method Groups the sparklines.  
Public Method Invalidates all formulas that are intersected with a specified range.  
Public Method Determines whether any cell in the specified column is in the selection.  
Public Method Determines whether any cell in the specified row is in the selection.  
Public Method Gets whether the specified column is bound to a data source.  
Public Method Gets whether the specified row is bound to a data source.  
Public Method Determines whether the specified cell is in the selection.  
Public Method Determines whether the specified cell value is valid.  
Public MethodOverloaded.  Changes the table location.  
Public Method Moves data from one range to another.  
Public Method Gets the index of the next visible column from the current column.  
Public Method Gets the index of the next visible row from the current row.  
Public MethodOverloaded.  Returns the next nonempty column index for the specified column.  
Public MethodOverloaded.  Returns the next nonempty row index for the specified column.  
Public MethodOverloaded.  Loads the CSV (comma-separated values) file asynchronously.  
Public MethodOverloaded.  Loads the CSV file with the specified separator asynchronously.  
Public Method Loads the XML stream to build a new worksheet.  
Public MethodOverloaded.  Loads the XML stream to build a new worksheet asynchronously.  
Public Methodstatic (Shared in Visual Basic) Parses the string to a two dimensional array.  
Public Method Gets the index of the previous visible column from the current column.  
Public Method Gets the index of the previous visible row from the current row.  
Public MethodOverloaded.  Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle.  
Public Method Reloads the binding data.  
Public Method Removes the chart with specified name.  
Public MethodOverloaded.  Removes the column or columns on this sheet at the specified index.  
Public Method Removes the column viewport.  
Public Method Removes the specified user-defined custom function.  
Public Method Removes the floating object with the specified name.  
Public Method Removes the picture with the specified name.  
Public MethodOverloaded.  Removes the row or rows on this sheet at the specified index.  
Public Method Removes the row viewport.  
Public MethodOverloaded.  Removes the span that contains a specified anchor cell from a range of cells in the specified sheet area.  
Public Method Removes the sparkline of the specified cell.  
Public MethodOverloaded.  Removes a specified table.  
Public Method Resets the color of the touch selection gripper background.  
Public Method Resets the theme color of the touch selection gripper background.  
Public MethodOverloaded.  Changes the table size.  
Public Method Resumes the calculation service.  
Public Method Resumes the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events.  
Public MethodOverloaded.  Saves the CSV (comma-separated values) file asynchronously.  
Public Method Saves the data on the sheet to the specified stream asynchronously.  
Public MethodOverloaded.  Saves the sheet to the specified stream asynchronously.  
Public MethodOverloaded.  Saves the range of cells in the sheet as delimited text and saves to a stream with the specified delimiters asynchronously.  
Public MethodOverloaded.  Saves the worksheet to an XML stream asynchronously.  
Public MethodOverloaded.  Searches the text in the cells in the specified sheet for the specified string with the specified criteria and start and end location, and whether to search notes and tags as well.  
Public MethodOverloaded.  Sets the active cell on this sheet.  
Public Method Sets the active viewport.  
Public MethodOverloaded.  Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet.  
Public Method Sets an array formula in a specified cell area in the specified sheet area.  
Public MethodOverloaded.  Sets the border for the specified area.  
Public Method Sets the value for a specified cell in a column header on this sheet.  
Public MethodOverloaded.  Sets whether users can resize individual columns in the specified sheet area.  
Public Method Sets whether a column in the specified sheet area is displayed.  
Public Method Sets the width using the specified unit type for the specified columns in this sheet.  
Public MethodOverloaded.  Sets CSV text in the sheet.  
Public MethodOverloaded.  Sets a custom name using the specified formula.  
Public Method Sets the data source that populates the sheet.  
Public Method  
Public MethodOverloaded.  Sets a formula in a specified cell in the specified sheet area.  
Public Method Sets the height using the specified unit type for the specified row in the specified sheet area.  
Public Method Sets the value for a specified cell in a row header on this sheet.  
Public MethodOverloaded.  Sets whether users can resize the specified row in the specified sheet area.  
Public Method Sets whether the control displays the specified row in the specified sheet area.  
Public MethodOverloaded.  Selects the specified cells.  
Public MethodOverloaded.  Sets the sparkline to a cell.  
Public MethodOverloaded.  Sets the style for the specified cell, row, or column.  
Public MethodOverloaded.  Sets the style for the specified cell, column, row, or default model to the specified style name.  
Public MethodOverloaded.  Sets the application-defined tag value for the specified cell, column, row, or entire sheet for the specified sheet area.  
Public MethodOverloaded. Sets the formatted text in the cell in the specified sheet area using the IFormatter object for the cell.  
Public MethodOverloaded.  Sets the value for the specified cell in the specified sheet area.  
Public Method Sets the height of the viewport.  
Public Method Sets the viewport information to the current sheet.  
Public Method Sets the width of the viewport.  
Public Method Sorts a range of cells in this sheet in the data model.  
Public Method Suspends the calculation service.  
Public Method Suspends the SpanModel, RowHeaderSpanModel, and ColumnHeaderSpanModel events.  
Public Method Ungroups the sparklines in the group.  
Top
See Also

Reference

Worksheet Class
GrapeCity.Xaml.SpreadSheet.Data Namespace