Spread Windows Forms 11.0 Product Documentation
SheetView Class Methods


FarPoint.Win.Spread Assembly > FarPoint.Win.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 a span of cells to a column footer for a sheet.  
Public MethodAdds a span of cells to a column header for a sheet.  
Public MethodAdds the column or columns to the data model at the specified index.  
Public MethodOverloaded. Adds a child control to the control container for the sheet.  
Public MethodOverloaded. Adds a custom name to the model using the specified string value.  
Public MethodGroups all the rows or columns from the specified start index by the specified amount to an outline (range group).  
Public MethodAdds a span of cells to a row header for a sheet.  
Public MethodAdds a row or rows to the data model for a sheet.  
Public MethodAdds the unbound row to the data source for a sheet.  
Public MethodAdds a selection on this sheet.  
Public MethodOverloaded. Adds a shape to the drawing container for the sheet.  
Public MethodAdds a span of cells on this sheet.  
Public MethodOverloaded. Adds the sparkline.  
Public MethodAdds the sparkline.  
Public MethodOverloaded. Adds a table with the specified name to the specified cell range of the sheet view with the specified style.  
Public MethodAdds unbound rows to the data model for a sheet.  
Public MethodOverloaded. Adds validators to a cell range.  
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. Automatically sorts the rows of a sheet according to the specified column.  
Public MethodBinds the column to the data source column for a sheet.  
Public MethodRemoves all spans from the column footers.  
Public MethodRemoves all spans from the column headers.  
Public MethodOverloaded. Removes all the conditional formatting from the specified cell.  
Public MethodRemoves all the conditional formatting from the sheet.  
Public MethodRemoves all child controls from the control container for the sheet.  
Public MethodRemoves all user-defined custom functions (FunctionInfo object) on this sheet from the model.  
Public MethodOverloaded. Removes all custom names on this sheet from the model.  
Public MethodOverloaded. Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.  
Public MethodRemoves all the outlines (range grouping) from all rows or columns.  
Public MethodOverloaded. Removes all of the row filters from this sheet.  
Public MethodRemoves all spans from the row headers.  
Public MethodRemoves all selections from this sheet.  
Public MethodRemoves all shapes from the drawing container for the sheet.  
Public MethodRemoves all spans from this sheet.  
Public MethodClears all sparkline groups.  
Public MethodClears all sparklines.  
Public MethodClears validators.  
Public MethodOverloaded. Copies the contents from the sheet to the Clipboard.  
Public MethodCopies the active shape to the Clipboard.  
Public MethodOverloaded. Cuts the contents from the sheet to the Clipboard.  
Public MethodCuts the active shape to the Clipboard.  
Public MethodOverloaded. Pastes the contents from the Clipboard to the active sheet.  
Public MethodOverloaded. Pastes the shape from the Clipboard.  
Public MethodConverts the specified table to a range.  
Public MethodCopies the data, formatting, formulas, and notes from a block of cells on the sheet to a new location.  
Public MethodOverloaded. Evaluates the expression and returns the resulting object for the cell at the specified row and column.  
Public MethodOverloaded. Expands or collapses a specified outline (range group) of rows or columns.  
Public MethodExpands or collapses the specified parent row, which shows or hides the child view in a hierarchical display.  
Public MethodOverloaded. Fills a range of cells on this sheet by copying a specified range in the specified direction.  
Public MethodGets the child view for this sheet with the specified name.  
Public MethodGets a two-dimensional array of objects that contain the data for the specified range of cells on the sheet.  
Public MethodGets the error text of a specified cell.  
Public MethodGets a cell with a specific tag on the sheet.  
Public MethodGets the CellType.  
Public MethodGets the name of the child data relation at the specified index on the sheet.  
Public MethodGets a list of child sheet views that have been created.  
Public MethodCreates the sheet (SheetView object) for the specified row and the specified relation index.  
Public MethodGets whether to show the child view on this sheet when the parent row is expanded.  
Public MethodGets a tab-delimited string that contains the formatted data in a specified range of cells on this sheet.  
Public MethodGets a data object with the necessary formats for Clipboard usage: CellInfoRange, ColumnInfoRange, and RowInfoRange.  
Public MethodGets a tab-delimited string that contains the unformatted data in a range of cells on this sheet.  
Public MethodGets whether the specified column on this sheet allows automatic sorting.  
Public MethodGets whether this column contains a column filter definition.  
Public MethodGets the automatic filter index for the specified column.  
Public MethodGets the automatic sort index for the specified column.  
Public MethodGets the automatic text displayed in the column header for the specified column on this sheet.  
Public MethodGets the text in the specified column footer cell on this sheet.  
Public MethodGets a column on this sheet with a specific tag.  
Public MethodGets the range of cells that are spanned at a specified cell on the column header of this sheet.  
Public MethodGets the text in the specified column header cell on this sheet.  
Public MethodGets whether or how cells in a column on this sheet that have the same content are joined into a single cell across multiple rows.  
Public MethodGets whether a forced page break is inserted before the specified column on this sheet when printing.  
Public MethodGets whether the specified column on this sheet should display a sort indicator when automatically sorted.  
Public MethodGets whether the user can resize a specified column on this sheet.  
Public MethodGets the sort indicator for the specified column on this sheet.  
Public MethodGets whether a column on this sheet is displayed.  
Public MethodGets the width in pixels for the specified column on this sheet.  
Public MethodOverloaded. Gets all conditional formatting in the specified cell range.  
Public MethodGets a child control.  
Public MethodGets the control container for a sheet.  
Public MethodGets an IEnumerator for this sheet that enumerates through the names of the user-defined custom functions (FunctionInfo objects) in the model.  
Public MethodOverloaded. Gets the string value for a custom name on this sheet from the model.  
Public MethodGets the comment of the custom name.  
Public MethodOverloaded. Gets an IEnumerator on this sheet that enumerates through the custom names defined in the model.  
Public MethodGets the DataView object on this sheet.  
Public MethodGets the editor used to edit a specified cell on this sheet.  
Public MethodGets the composited (inherited) cell type for a specified cell on the filter bar.  
Public MethodGets the formula of the specified cell on this sheet.  
Public MethodGets the index of the last column that contains data or formatting on this sheet.  
Public MethodGets the row index of the last row that contains data or formatting on this sheet.  
Public MethodGets the column index in the data model that corresponds to the specified column index in the sheet.  
Public MethodGets the row index in the data model that corresponds to the specified row index in the sheet.  
Public MethodGets the note (comments) from a specified cell.  
Public MethodGets the rectangle for the cell note for the specified cell if its NoteStyle is StickyNote.  
Public MethodGets the desired size of the given cell on this sheet.  
Public MethodOverloaded. Gets the width of the widest cell (based on text content) in the specified column on this sheet.  
Public MethodGets the width of the widest cell (based on text content) in the specified column on this sheet for printing to the specified graphics device.  
Public MethodGets the height in pixels of the tallest cell (based on text content) in the specified row on this sheet.  
Public MethodOverloaded. Gets the height in pixels of the tallest cell (based on text content) in the specified row on this sheet.  
Public MethodGets range groups of rows or columns by level.  
Public MethodGets the number of levels of rows or columns in the outline (range group).  
Public MethodGets the renderer used to render a specified cell on this sheet.  
Public MethodGets the top SheetView object.  
Public MethodGets the automatic text displayed in the row header for the specified row on this sheet.  
Public MethodGets the row error text.  
Public MethodGets whether the row on this sheet can be expanded to show a child view in a hierarchical display.  
Public MethodGets a row on this sheet with a specific tag.  
Public MethodGets the range of cells that are spanned at a specified cell on the row header of this sheet.  
Public MethodGets the height in pixels for the specified row on this sheet.  
Public MethodGets the text in the specified row header cell on this sheet.  
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 a forced page break is inserted before the specified row on this sheet when printing.  
Public MethodGets whether users can resize the specified row on this sheet.  
Public MethodGets whether a row on this sheet is displayed.  
Public MethodGets the selection on this sheet with the specified index.  
Public MethodGets an ordered array of FarPoint.Win.Spread.Model.CellRange objects, from largest to smallest, that contain the selected cells on the sheet with minimal overlap between the ranges.  
Public MethodGets a shape.  
Public MethodGets the range of cells that are spanned at a specified cell on this sheet.  
Public MethodGets the sparkline information.  
Public MethodGets the style information for the cell notes on this sheet that stay visible.  
Public MethodOverloaded. Gets the style information for a specified cell on this sheet.  
Public MethodOverloaded. Gets a TableView by name.  
Public MethodGets the FarPoint.Win.Spread.Model.ITableRange enumerator.  
Public MethodGets the application-defined tag value for the specified cell, column, row, or entire sheet.  
Public MethodGets the formatted text in the cell on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell.  
Public MethodGets the unbound value for the cell on this sheet.  
Public MethodGets the valid conditional format.  
Public MethodGets unformatted data from the specified cell on this sheet.  
Public MethodGets the column on the sheet that corresponds to the specified column index in the model.  
Public MethodGets the row on the sheet that corresponds to the specified row index in the model.  
Public MethodOverloaded. Groups the sparkline and sets the type of new group.  
Public MethodGets whether any cells in the specified column on this sheet are selected.  
Public MethodGets whether any cells in the specified row on this sheet are selected.  
Public MethodGets whether the specified column on this sheet is bound to a data source.  
Public MethodGets whether the specified row on this sheet is bound to a data source.  
Public MethodGets whether the row on this sheet displays a child view in a hierarchical display.  
Public MethodGets whether the specified cell on this sheet is selected.  
Public MethodJoins two shapes in the drawing container for the sheet.  
Public MethodLoads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized.  
Public MethodOverloaded. Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.  
Public MethodOverloaded. Loads delimited text from a specified file into the sheet.  
Public MethodModifies the name of a custom name.  
Public MethodOverloaded. Moves the specified column from its current index to the specified index, and shifts each column in between and the destination column one column in the direction of the specified column.  
Public MethodMoves the data, formatting, formulas, and notes from a block of cells on this sheet to a new location.  
Public MethodOverloaded. Moves the specified row from its current index to the specified index, and shifts each row in between and the destination row one row in the direction of the specified row.  
Public MethodChanges the sheet row axis model in synchronization with the data source.  
Public MethodOverloaded. Opens a saved XML file into a sheet view.  
Public MethodOverloaded. Opens an Excel stream and loads the specified sheet (by name) from that file into this sheet.  
Public MethodOpens a saved Spread file into this sheet.  
Public MethodOverloaded. Raises the CellChanged event (that a change has been made to a cell on this sheet).  
Public MethodRaises the PropertyChanged event for this sheet.  
Public MethodEvaluates all the formulas in cells on the sheet that have changed since the last calculation cycle.  
Public MethodEvaluates all the formulas in cells on the sheet (including those that have not changed since the last calculation cycle).  
Public MethodRemoves the span that contains a specified anchor cell from a range of cells in the column footers.  
Public MethodRemoves the span that contains a specified anchor cell from a range of cells in the column headers.  
Public MethodRemoves the column or columns on this sheet at the specified index.  
Public MethodOverloaded. Removes the child control from the control container for the sheet.  
Public MethodRemoves a user-defined custom function (FunctionInfo object) on this sheet from the model.  
Public MethodOverloaded. Removes a custom name on this sheet from the model.  
Public MethodRemoves rows or columns from an outline (range group) from a specified start index by a specified amount, and returns them to individual rows or columns.  
Public MethodRemoves the span that contains a specified anchor cell from a range of cells in the row headers.  
Public MethodRemoves the row or rows on this sheet at the specified index.  
Public MethodRemoves the specified selection from this sheet.  
Public MethodRemoves the shape from the drawing container for the sheet.  
Public MethodRemoves the span that contains a specified anchor cell from a range of cells on this sheet.  
Public MethodRemoves a TableView.  
Public MethodResets the view on this sheet to its original state.  
Public MethodResumes updates of values to the chart immediately.  
Public MethodOverloaded. Saves the contents of the sheet view to the specified file.  
Public MethodOverloaded. Saves the sheet to the specified file in HTML.  
Public MethodOverloaded. Saves the specified range in the sheet to the specified file in HTML.  
Public MethodOverloaded. Saves the sheet as delimited text to a file with specific delimiters.  
Public MethodOverloaded. Saves the range of cells in a sheet to a text file with the specified name, formatting settings, and delimiters.  
Public MethodOverloaded. Saves the data on the sheet to the specified XML stream and the schema to the specified schema stream.  
Public MethodOverloaded. Sets the active cell on this sheet.  
Public MethodSets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet.  
Public MethodSets the error text for a specified cell.  
Public MethodSets whether to make the child view on this sheet visible when the parent row is expanded.  
Public MethodSets a tab-delimited string of formatted text in a specified range of cells on this sheet.  
Public MethodOverloaded. Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.  
Public MethodSets a tab-delimited string of unformatted data in a specified range of cells on this sheet.  
Public MethodOverloaded. Sets whether the specified column on this sheet allows automatic sorting.  
Public MethodOverloaded. Sets whether the specified column on this sheet allows filtering.  
Public MethodSets the automatic filter index for the specified column.  
Public MethodSets the automatic sort index for the specified column.  
Public MethodSets the value for a specified cell in a column header on this sheet.  
Public MethodSets whether or how cells in a column on this sheet that have the same content are joined into a single cell across multiple rows.  
Public MethodSets whether a forced page break is inserted before the specified column on this sheet when printing.  
Public MethodOverloaded. Sets whether the specified column or columns should show a sort indicator when automatically sorted.  
Public MethodSets whether the user can resize a specified column on this sheet.  
Public MethodSets the sort indicator for the specified column on this sheet.  
Public MethodSets whether a column on this sheet is displayed.  
Public MethodSets the width in pixels for the specified column on this sheet.  
Public MethodOverloaded. Sets conditional formatting for a specified cell on the sheet based on specified rules.  
Public MethodAdds a comment to the specified custom name.  
Public MethodSets the value for the specified cell on this sheet.  
Public MethodSets a formula in a specified cell on this sheet.  
Public MethodSets borders on the inside of a range of cells.  
Public MethodSets the column index in the data model that corresponds to the specified column index in the sheet.  
Public MethodSets the row index in the data model that corresponds to the specified row index in the sheet.  
Public MethodSets the width in pixels for the specified columns on this sheet.  
Public MethodSets the height in pixels for the specified rows on this sheet.  
Public MethodSets a note in a specified cell on this sheet.  
Public MethodSets the location and dimensions for a cell note when the style sets the note to always be shown.  
Public MethodSets border outlines for a range of cells.  
Public MethodSets error text for row.  
Public MethodSets whether the row on this sheet can be expanded to show a child view in a hierarchical display.  
Public MethodSets the height in pixels for the specified row on this sheet.  
Public MethodSets the value for a specified cell in the row header on this sheet.  
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 a forced page break is inserted before the specified row on this sheet when printing.  
Public MethodSets whether users can resize the specified row on this sheet.  
Public MethodSets whether a row on this sheet is displayed.  
Public MethodSets the style information for the cell notes on this sheet that stay visible.  
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 on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell.  
Public MethodOverloaded. Sets the value for the specified cell on this sheet.  
Public MethodGets whether the background image should be serialized.  
Public MethodGets whether the horizontal grid line for the footer corner should be serialized.  
Public MethodGets whether the vertical grid line for the footer corner should be serialized.  
Public MethodGets whether the tiled background image should be serialized.  
Public MethodShows or hides all cell notes on the sheet.  
Public MethodOverloaded. Sorts a range of columns in the sheet.  
Public MethodSorts a range of cells on this sheet in the data model.  
Public MethodOverloaded. Sorts a range of rows in the sheet.  
Public MethodSuspends updates of values to the chart immediately.  
Public MethodSwaps the data and formatting in a block of cells on this sheet with another block of cells on this sheet.  
Public MethodOverloaded. Ungroups the sparkline.  
Public MethodOverloaded. Updates cell note appearances based on style being set or on changes to note text.  
Public MethodValidates a cell.  
Top
Protected Methods
 NameDescription
Protected MethodGets the number of the visible columns.  
Protected MethodGets the number of the visible rows.  
Protected MethodOccurs when footer rows are added.  
Protected MethodRaises the Disposing event  
Protected MethodOccurs when a note for the viewport area is created in the sheet's notes container.  
Protected MethodOccurs when a note for the viewport area is moved in the sheet's notes container.  
Protected MethodOccurs when a note for the viewport area is sized in the sheet's notes container.  
Protected MethodOccurs when column footer rows are removed.  
Protected MethodGets whether the style for the sheet corner should be serialized.  
Protected MethodGets whether the style for the filter bar header should be serialized.  
Protected MethodDetermines whether lock font should be serialized.  
Protected MethodDetermines whether null background color should be serialized.  
Protected MethodDetermines whether null font should be serialized.  
Protected MethodDetermines whether null text color should be serialized.  
Protected MethodDetermines whether selection font should be serialized.  
Top
See Also

Reference

SheetView Class
FarPoint.Win.Spread Namespace

User-Task Documentation

Adding a Sheet
Customizing the Appearance of a Sheet
Customizing Interaction with a Sheet