Spread for ASP.NET 11 Product Documentation
SheetView Class Methods


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : SheetView Class

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

Public Methods
 NameDescription
Public MethodOverloaded. Adds the chart control.  
Public MethodAdds columns to the data model at the specified index.  
Public MethodOverloaded.   
Public MethodAdds rows to the data model.  
Public MethodAdds the unbound row to the data source.  
Public MethodAdds a span of cells to a sheet.  
Public MethodOverloaded. Adds the sparkline.  
Public MethodAdds the sparkline.  
Public MethodAdds unbound rows to the data model.  
Public MethodAutomatically filters the rows in the specified column according to the specified filter.  
Public MethodResets the filters on the rows in the specified column.  
Public MethodOverloaded. Removes all of the conditional formatting from the cell at the specified row and column.  
Public MethodRemoves all of the conditional formatting from the sheet.  
Public MethodRemoves all of the data, formatting, formulas, and notes from a range of cells on this sheet.  
Public MethodClears the row filter for this sheet.  
Public MethodClears all sparkline groups.  
Public MethodClears all sparklines.  
Public MethodExpands or collapses all the levels of hierarchy  
Public MethodExpands or collapses the specified row in the hierarchical display.  
Public MethodGets the child view in a hierarchical display with the specified row and data relation index.  
Public MethodGets a cell with a specific tag on the sheet.  
Public MethodGets the cell type for a cell at the specified row and column.  
Public MethodGets the name of the child data relation in a hierarchical display at the specified index.  
Public MethodGets a child sheet in a hierarchical display for the specified row and the specified relation index.  
Public MethodGets whether the child view is displayed in a hierarchical display.  
Public MethodOverloaded. Gets a tab-delimited string that contains the formatted text in a specified range.  
Public MethodGets a tab-delimited string that contains the unformatted text in a specified range.  
Public MethodGets whether this column contains a column filter definition.  
Public MethodGets the automatic text displayed in the specified column header.  
Public MethodGets a column on this sheet with a specific tag.  
Public MethodGets the text in the column header cell at the specified row and column.  
Public MethodGets whether or how cells in a column on this sheet that have the same content are joined in a single cell across multiple rows.  
Public MethodGets whether the user can resize a specified column.  
Public MethodGets the sort indicator to display at the specified column.  
Public MethodGets whether a column is displayed.  
Public MethodGets the width of the specified column in pixels.  
Public MethodOverloaded. Gets all the conditional formatting in the specified cell range.  
Public MethodOverloaded. Gets the string value for a custom name on this sheet from the model.  
Public MethodGets the identifier for the specified row if it is visible.  
Public MethodGets the default editor used to edit the cell.  
Public MethodGets the default renderer used to render the cell.  
Public MethodGets the filter items to be displayed in the drop-down list for the specified column.  
Public MethodGets the editor used to edit a cell at the specified row and column.  
Public MethodGets the formula of the specified cell on this sheet.  
Public MethodGets the formatter used to format a cell at the specified row and column.  
Public MethodGets the formula in the cell at the specified row and column.  
Public MethodGets the group footer information for the sheet.  
Public MethodGets the group information for the sheet.  
Public MethodGets the index in the model for the specified column.  
Public MethodGets a row index in a model for a specified row in a sheet.  
Public MethodGets the cell note for a cell at the specified row and column.  
Public MethodGets the renderer used to render a cell at the specified row and column.  
Public MethodGets the automatic text displayed in the specified row header.  
Public MethodGets whether the row on this sheet is expandable in the hierarchical display.  
Public MethodGets a row on this sheet with a specific tag.  
Public MethodGets the height of the specified row.  
Public MethodGets the text in the specified row header cell.  
Public MethodGets whether or how cells in a row on this sheet that have the same content are joined into a single cell across multiple columns.  
Public MethodGets whether the user can resize the specified row.  
Public MethodGets whether a row is displayed.  
Public MethodGets an ordered array of FarPoint.Web.Spread.Model.CellRange objects, from largest to smallest, containing the selected cells on the sheet with minimal overlap between the ranges.  
Public MethodGets the span of cells at a specified cell.  
Public MethodGets the sparkline information.  
Public MethodGets the composite cell style information for a cell at the specified row and column.  
Public MethodGets the application-defined tag value for the specified cell, column, row, or entire sheet.  
Public MethodGets the formatted text in the cell using the IFormatter object for the cell.  
Public MethodGets the unbound value for a cell at the specified row and column.  
Public MethodGets the valid conditional format.  
Public MethodGets unformatted data from a cell at the specified row and column.  
Public MethodGets the sheet column index for a specified model column.  
Public MethodGets a sheet row index for the specified model row.  
Public MethodOverloaded. Groups the sparkline and sets the type of the new group.  
Public MethodGets whether the column is bound to a data source column.  
Public MethodGets whether the specified row is bound to a data source.  
Public MethodGets whether the row is expanded in the hierarchical display.  
Public MethodLoads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.  
Public MethodOverloaded. Loads a text file with the specified name into the sheet.  
Public MethodLoads a saved view state for a sheet.  
Public MethodMoves the column or columns to a specified location.  
Public MethodMoves the row or rows to a specified location.  
Public MethodOverloaded. Opens a sheet saved as XML from the specified file and loads it into the sheet.  
Public MethodOverloaded. Opens an Excel file and loads the specified Excel sheet into this sheet.  
Public MethodEvaluates all the formulas in the sheet that have changed since the last calculation cycle.  
Public MethodEvaluates all the formulas in the sheet (including those that have not changed since the last calculation cycle).  
Public MethodRemoves the columns at the specified index.  
Public MethodRemoves the rows at the specified index.  
Public MethodRemoves the span from a range of cells that contain a specified anchor cell.  
Public MethodSets the sheet to its default values.  
Public MethodResets all column indexes in the sheet to be the same as the column indexes in the corresponding data model.  
Public MethodResets all row indexes in the sheet to be the same as the row indexes in the corresponding data model.  
Public MethodOverloaded. Saves the contents of the sheet to XML in the specified file.  
Public MethodOverloaded. Saves the sheet as HTML content to the stream  
Public MethodOverloaded. Saves the sheet to a text file with the specified name.  
Public MethodOverloaded. Saves the range of cells (and may include headers) to a text file as specified.  
Public MethodSaves the current view state of the sheet.  
Public MethodSets whether to display the child view in a hierarchical display.  
Public MethodSets a tab-delimited string that contains the formatted text in a specified range.  
Public MethodSets a tab-delimited string that contains the unformatted text in a specified range.  
Public MethodSets the value for a specified cell in a column header.  
Public MethodSets whether or how cells in a column on this sheet that have the same content are joined in a single cell across multiple rows.  
Public MethodSets whether users can resize individual columns.  
Public MethodSets the sort indicator to display at the specified column.  
Public MethodSets whether a column is displayed.  
Public MethodSets the width of the specified column in pixels.  
Public MethodOverloaded. Sets conditional formatting for a specified cell on the sheet based on specified rules.  
Public MethodSets a formula in a specified cell on this sheet.  
Public MethodSets the formula for a specified cell.  
Public MethodBinds the model column to the data source column.  
Public MethodSets the cell note for a specified cell.  
Public MethodSets whether the row on this sheet can be expanded to show the child view in the hierarchical display.  
Public Method

Sets the height of the specified row in pixels.

 
Public MethodSets the value for a specified cell in the row header.  
Public MethodSets whether or how cells in a row on this sheet that have the same content are joined into a single cell across multiple columns.  
Public MethodSets whether users can resize individual rows.  
Public MethodSets whether a row is displayed.  
Public MethodSets the style for a cell, a column, a row, or an entire sheet.  
Public MethodSets the application-defined tag value for the specified cell, column, row, or entire sheet.  
Public MethodSets the formatted text in the cell using the IFormatter object for the cell.  
Public MethodSets the value for a cell at the specified row and column.  
Public MethodSorts a range of cells in the data model.  
Public MethodOverloaded. Sorts all the columns in the sheet according to the specified parameters.  
Public MethodOverloaded. Sorts all the rows in the sheet according to the specified parameters.  
Public MethodReturns the name of the sheet.  
Public MethodOverloaded. Ungroups the sparkline.  
Top
Protected Methods
 NameDescription
Protected MethodCreates the column axis model.  
Protected MethodCreates the data model.  
Protected MethodCreates the row axis model.  
Protected MethodCreates the selection model.  
Protected MethodCreates the span model.  
Protected MethodCreates the style model.  
Protected MethodCalls GetPagingSupport of the DataModel, selects data to data source view.  
Protected MethodGets a name for the child view in a hierarchical display based on the row index and the relation index.  
Protected MethodProcesses the addition of the specified rows to the column footer in the data model.  
Protected MethodProcesses the addition of the specified rows to the column header in the data model.  
Protected MethodProcesses the addition of columns to the data model and updates the other models and internal variables of the fpSpread component.  
Protected MethodProcesses the addition of columns to the row header of the sheet.  
Protected MethodProcesses the addition of rows to the data model.  
Protected MethodProcesses the change to the sheet data model and synchronizes the models.  
Protected MethodProcesses the removal of rows from the column header.  
Protected MethodProcesses the removal of rows from the column header.  
Protected MethodProcesses the removal of the specified columns from the data model.  
Protected MethodProcesses the removal of columns from the row header.  
Protected MethodProcesses the removal of the specified rows from the data model.  
Protected MethodDetermines whether the print information should be serialized.  
Top
See Also

Reference

SheetView Class
FarPoint.Web.Spread Namespace
FpSheetViewCollection class
Sheets Property
SheetViewCollection Class

User-Task Documentation

Customizing the Appearance of a Sheet