Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class
Fields Properties Methods Events

In This Topic
    SheetView Class Members
    In This Topic

    The following tables list the members exposed by SheetView.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded.   
    Top
    Public Fields
     NameDescription
    Public Field  
    Top
    Public Properties
     NameDescription
    Public PropertyGets a Cell object for the active cell on the sheet.  
    Public PropertyGets a Column object for the active column on the sheet.  
    Public Property Gets or sets the column index of the active cell on the sheet.  
    Public PropertyGets a Row object for the active row on the sheet.  
    Public Property Gets or sets the row index of the active cell on the sheet.  
    Public Property Gets or sets the skin for the sheet.  
    Public Property Gets or sets whether to allow the user to group rows on the sheet.  
    Public Property Gets or sets whether notes on this sheet are editable.  
    Public Property Gets or sets whether the sheet corner can have a grid structure (table).  
    Public PropertyGets an AlternatingRows object for the alternating rows in the data area of the sheet.  
    Public Property Gets or sets whether the control recalculates each formula when the contents of dependent cells change for a sheet.  
    Public Property Gets or sets whether the filter will automatically update for any changes.  
    Public PropertyGets or sets the AutoFilterMode.  
    Public Property Gets or sets whether to automatically generate the columns for a sheet based on the data source.  
    Public Property Gets or sets whether to allow automatic sorting for a sheet and whether to show the sort indicator.  
    Public Property Gets or sets whether to use the Spread's enhanced filter menu.  
    Public Property Gets or sets whether to use the Spread's sorting behavior in enhanced filter context menu.  
    Public Property Gets or sets a value that indicates whether frozen rows are sorted.  
    Public Property Gets or sets a value that indicates whether trailing frozen rows are sorted.  
    Public Property Gets or sets whether cell notes are automatically updated when changes are made to the note style or to the text, or notes are added, removed, or moved.  
    Public Property Gets or sets sheetview background image.  
    Public Property Gets or sets sheetview background image layout.  
    Public PropertyGets a Cells object for the cells in the data area of the sheet.  
    Public Property Gets the charts.  
    Public Property Gets the number of child relations (data relation count) for a sheet.  
    Public Property Gets the index of the last column that was automatically sorted for the sheet.  
    Public Property Gets or sets the number of columns in the sheet.  
    Public PropertyGets the ColumnFooter object for the column footer area of the sheet.  
    Public Property Gets or sets the horizontal grid line in the column footer for the sheet.  
    Public Property Gets or sets the number of rows in the column footers for the sheet.  
    Public Property Gets or sets the horizontal grid line for the column footer sheet corner.  
    Public Property Gets or sets the style information for the sheet corner for the column footer.  
    Public Property Gets or sets the name of the style for the sheet corner of the column footer.  
    Public Property Gets or sets the vertical grid line for the column footer sheet corner.  
    Public Property Gets or sets the vertical grid line in the column footer for the sheet.  
    Public Property Gets or sets whether the column footers for this sheet are visible.  
    Public PropertyGets the ColumnHeader object for the column header area of the sheet.  
    Public Property Gets or sets which column header row in the sheet displays the filter indicator when there are multiple column header rows.  
    Public Property Gets or sets which column header row in the sheet displays the sort indicator when there are multiple column header rows.  
    Public Property Gets or sets whether column headers for the sheet display letters or numbers or are blank.  
    Public Property Gets or sets which column header row for the sheet displays the automatic text when there are multiple column header rows.  
    Public Property Gets or sets the horizontal grid line for the sheet.  
    Public Property Gets or sets the number of rows in the column headers for the sheet.  
    Public Property Gets or sets the vertical grid line in the column header for the sheet.  
    Public Property Gets or sets whether the column headers for this sheet are visible.  
    Public PropertyGets a Columns object for the columns in the data area of the sheet.  
    Public Property Gets the containing views.  
    Public Property Gets or sets whether to allow the user to add a new row when the sheet is bound.  
    Public Property Gets or sets whether a bound sheet automatically sets the cell type for the cells in a column.  
    Public Property Gets or sets whether a bound sheet automatically assigns the data field names to be the text in the column headers.  
    Public Property Gets or sets whether a bound sheet automatically sizes its columns based on the data in the associated database fields.  
    Public Property Gets or sets the name of the data member that populates the sheet.  
    Public Property Gets or sets the name of the data source that populates the sheet.  
    Public Property Default setting for group footers.  
    Public PropertyGets or sets a StyleInfo object for the default style of the sheet.  
    Public Property Gets or sets the name of the default style for the sheet.  
    Public Property Gets or sets whether zero values are displayed in cells.  
    Public Property Sets or gets whether cell diagonal line is enable.  
    Public Property Gets or sets whether the enhanced filter shows items in the tree by default or alphabetic order.  
    Public Property Gets or sets whether the rows are expandable.  
    Public PropertyGets the FilterBar object of the sheet.  
    Public Property Gets or sets the horizontal grid line for the filter bar header.  
    Public Property Gets or sets the style information for the filter bar header.  
    Public Property Gets or sets the name of the style for the filter bar header.  
    Public Property Gets or sets the vertical grid line for the filter bar.  
    Public Property Gets or sets the horizontal grid line for the filter bar.  
    Public Property Gets or sets the vertical grid line for the filter bar.  
    Public Property Gets Fpspread from sheet view.  
    Public Property Gets or sets the number of non-scrolling columns on the leading edge of this sheet.  
    Public Property Gets or sets the number of non-scrolling rows on the leading edge of this sheet.  
    Public Property Gets or sets the number of non-scrolling columns on the trailing edge of this sheet.  
    Public Property Gets or sets the number of non-scrolling rows on the trailing edge of this sheet.  
    Public Property Gets or sets the color in the area between the sheet and the edge of the control.  
    Public Property Gets or sets the information of the grouping bar for the sheet.  
    Public Property Gets or sets whether the group footer is displayed.  
    Public Property Gets or sets the collection of grouping information objects for the sheet.  
    Public Property Gets or sets grouping policy to collapse or expand rows when grouping occurs.  
    Public Property Gets or sets the maximum number of levels of grouping for the sheet.  
    Public Property Gets or sets the horizontal grid line for this sheet.  
    Public Property Gets whether a block of cells on this sheet is currently selected.  
    Public Property Gets or sets whether circular references are evaluated on this sheet.  
    Public Property Gets or sets the background color of locked cells on this sheet.  
    Public Property Gets or sets the default font for locked items on this sheet.  
    Public Property Gets or sets the foreground color of locked cells on this sheet.  
    Public Property Gets or sets the maximum amount of change below which iterations stop when circular references are evaluated on this sheet.  
    Public Property Gets or sets the maximum number of iterations for calculating circular references on this sheet.  
    Public Property Gets or sets a value that indicates the minimum zoom factor for this sheet.  
    Public PropertyGets or sets a SheetView.DocumentModels object that contains all the models for the sheet.  
    Public PropertyGets or sets a NamedStyleCollection of NamedStyle objects for this sheet.  
    Public Property Gets a value that is one more than the index of the last column on this sheet containing data.  
    Public Property Gets a value that is one more than the index of the last row on this sheet containing data.  
    Public Property Gets or sets the background color of null items on this sheet.  
    Public Property Gets or sets the default font for null items on this sheet.  
    Public Property Gets or sets the foreground color of null items on this sheet.  
    Public Property Gets or sets the mode that determines mouse, keyboard, and selection behavior for this sheet.  
    Public PropertyGets or sets the name of the parent sheet (SheetView object) of this sheet.  
    Public Property Gets the data relation name for this sheet.  
    Public Property Gets the index of the parent row on this sheet.  
    Public Property Gets or sets preview row information for the sheet.  
    Public PropertyGets or sets a PrintInfo object that determines printing behavior for the sheet.  
    Public Property Gets or sets whether cells on this sheet that are marked as locked are not editable.  
    Public Property Gets or sets the background color of the outline (range group) region.  
    Public Property Gets or sets the style of the outline (range group) button.  
    Public Property Gets or sets whether the direction of the summary column is to the right of the detail.  
    Public Property Gets or sets whether the direction of the summary row is below the detail.  
    Public Property Gets or sets the style for cell and range references in formulas in cells on this sheet.  
    Public Property Gets or sets whether users are restricted from typing data in a column on this sheet that is more than one column beyond the last column that contains data.  
    Public Property Gets or sets whether users are restricted from typing data in a row on this sheet that is more than one row beyond the last row that contains data.  
    Public Property Gets or sets the number of rows on this sheet.  
    Public Property Gets or sets the row filter for the sheet.  
    Public PropertyGets the RowHeader object for the row header area of the sheet.  
    Public Property Gets or sets whether row headers on this sheet display letters or numbers or are blank.  
    Public Property Gets or sets which row header column on this sheet displays the automatic text when there are multiple row header columns.  
    Public Property Gets or sets the number of columns in the row header on this sheet.  
    Public Property Gets or sets the horizontal grid line in the row header on this sheet.  
    Public Property Gets or sets which row header column in the sheet displays the row selector when there are multiple row header columns.  
    Public Property Gets or sets the vertical grid line in the row header on this sheet.  
    Public Property Gets or sets whether the row headers for this sheet are visible.  
    Public PropertyGets a Rows object for the rows in the data area of the sheet.  
    Public Property Gets or sets the information of the vertical scrolling tip for the sheet.  
    Public Property Gets or sets the background color of selections on this sheet.  
    Public Property Gets the number of selections on this sheet.  
    Public Property Gets or sets the default font for selected items on this sheet.  
    Public Property Gets or sets the foreground color of selections on this sheet.  
    Public Property Gets the selection policy for the sheet for normal operation mode.  
    Public Property Gets or sets how selections on this sheet are drawn.  
    Public Property Gets or sets the smallest unit users or the application can select on this sheet.  
    Public Property Gets or sets whether the DocumentModels for this sheet should be serialized to the form resources, rather than generating code that initializes the Cells, Columns, Rows, and AlternatingRows.  
    Public Property Gets the sheet corner of the sheet.  
    Public Property Gets or sets the horizontal grid line for the sheet corner.  
    Public Property Gets or sets the style information for the sheet corner.  
    Public Property Gets or sets the name of the style for the sheet corner.  
    Public Property Gets or sets the vertical grid line for the sheet corner.  
    Public Property Gets or sets the name of the sheet.  
    Public Property Gets or sets a value that indicates whether to display a row selector in the editing row header of the selected row for the sheet.  
    Public Property Gets or sets a value that indicates whether to display a row selector in the row header of the selected row for the sheet.  
    Public Property Gets or sets a sparkline container for the sheet for maintaining sparklines.  
    Public Property Gets or sets the number or letter displayed in the first column header on this sheet.  
    Public Property Gets or sets the number or letter displayed in the first row header on this sheet.  
    Public Property Gets or sets an application-defined tag value associated with the cells in this sheet.  
    Public Property Sheet title  
    Public Property Gets the object which manages all DataValidtions.  
    Public Property Gets or sets the vertical grid line on this sheet.  
    Public Property Get or set the view type of a SheetView.  
    Public Property Gets or sets whether to display the sheet.  
    Public Property Gets or sets whether to use visual styles when rendering objects in the sheet.  
    Public Property Gets or sets the scaling factor for displaying this sheet.  
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded.  Adds the chart control.  
    Public Method Adds a span of cells to a column footer for a sheet.  
    Public Method Adds a span of cells to a column header for a sheet.  
    Public Method Adds 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 Method Groups all the rows or columns from the specified start index by the specified amount to an outline (range group).  
    Public Method Adds a span of cells to a row header for a sheet.  
    Public Method Adds a row or rows to the data model for a sheet.  
    Public Method Adds the unbound row to the data source for a sheet.  
    Public Method Adds a selection on this sheet.  
    Public MethodOverloaded.  Adds a shape to the drawing container for the sheet.  
    Public Method Adds a span of cells on this sheet.  
    Public MethodOverloaded.  Adds the sparkline.  
    Public Method Adds 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 Method Adds unbound rows to the data model for a sheet.  
    Public MethodOverloaded.  Adds validators to a cell range.  
    Public MethodGets the coressponding GrapeCity.Spreadsheet.IWorksheet object that allows accessing to new object model and API set.  
    Public Method Automatically filters the rows in the specified column according to the specified filter.  
    Public Method Resets the filters on the rows in the specified column.  
    Public MethodOverloaded.  Automatically sorts the rows of a sheet according to the specified column.  
    Public Method Binds the column to the data source column for a sheet.  
    Public Method Removes all spans from the column footers.  
    Public Method Removes all spans from the column headers.  
    Public MethodOverloaded.  Removes all the conditional formatting from the specified cell.  
    Public Method Removes all the conditional formatting from the sheet.  
    Public Method Removes all child controls from the control container for the sheet.  
    Public Method Removes 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 Method Removes all the outlines (range grouping) from all rows or columns.  
    Public MethodOverloaded.  Removes all of the row filters from this sheet.  
    Public Method Removes all spans from the row headers.  
    Public Method Removes all selections from this sheet.  
    Public Method Removes all shapes from the drawing container for the sheet.  
    Public Method Removes all spans from this sheet.  
    Public Method Clears all sparkline groups.  
    Public Method Clears all sparklines.  
    Public Method Clears validators.  
    Public MethodOverloaded. Copies the contents from the sheet to the Clipboard.  
    Public Method Copies the active shape to the Clipboard.  
    Public MethodOverloaded.  Cuts the contents from the sheet to the Clipboard.  
    Public Method Cuts 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 Method Converts the specified table to a range.  
    Public Method Copies 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 Method Expands 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 Method Gets the child view for this sheet with the specified name.  
    Public Method Gets a two-dimensional array of objects that contain the data for the specified range of cells on the sheet.  
    Public Method Gets the error text of a specified cell.  
    Public Method Gets a cell with a specific tag on the sheet.  
    Public Method Gets the CellType.  
    Public Method Gets the name of the child data relation at the specified index on the sheet.  
    Public Method Gets a list of child sheet views that have been created.  
    Public Method Creates the sheet (SheetView object) for the specified row and the specified relation index.  
    Public Method Gets whether to show the child view on this sheet when the parent row is expanded.  
    Public Method Gets a tab-delimited string that contains the formatted data in a specified range of cells on this sheet.  
    Public Method Gets a data object with the necessary formats for Clipboard usage: CellInfoRange, ColumnInfoRange, and RowInfoRange.  
    Public Method Gets a tab-delimited string that contains the unformatted data in a range of cells on this sheet.  
    Public Method Gets whether the specified column on this sheet allows automatic sorting.  
    Public Method Gets whether this column contains a column filter definition.  
    Public Method Gets the automatic filter index for the specified column.  
    Public Method Gets the automatic sort index for the specified column.  
    Public Method Gets the automatic text displayed in the column header for the specified column on this sheet.  
    Public Method Gets the text in the specified column footer cell on this sheet.  
    Public Method Gets a column on this sheet with a specific tag.  
    Public Method Gets the range of cells that are spanned at a specified cell on the column header of this sheet.  
    Public Method Gets the text in the specified column header cell on this sheet.  
    Public Method Gets 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 Method Gets whether a forced page break is inserted before the specified column on this sheet when printing.  
    Public Method Gets whether the specified column on this sheet should display a sort indicator when automatically sorted.  
    Public Method Gets whether the user can resize a specified column on this sheet.  
    Public Method Gets the sort indicator for the specified column on this sheet.  
    Public Method Gets whether a column on this sheet is displayed.  
    Public Method Gets the width in pixels for the specified column on this sheet.  
    Public MethodOverloaded.  Gets all conditional formatting in the specified cell range.  
    Public Method Gets a child control.  
    Public Method Gets the control container for a sheet.  
    Public Method Gets 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 Method Gets 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 Method Gets the DataView object on this sheet.  
    Public Method Gets the editor used to edit a specified cell on this sheet.  
    Public Method Gets the composited (inherited) cell type for a specified cell on the filter bar.  
    Public Method Gets the formula of the specified cell on this sheet.  
    Public Method Gets the index of the last column that contains data or formatting on this sheet.  
    Public Method Gets the row index of the last row that contains data or formatting on this sheet.  
    Public Method Gets the column index in the data model that corresponds to the specified column index in the sheet.  
    Public Method Gets 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 Method Gets the rectangle for the cell note for the specified cell if its NoteStyle is StickyNote.  
    Public Method Gets 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 Method Gets 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 Method Gets 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 Method Gets range groups of rows or columns by level.  
    Public Method Gets the number of levels of rows or columns in the outline (range group).  
    Public Method Gets the renderer used to render a specified cell on this sheet.  
    Public MethodGets the top SheetView object.  
    Public Method Gets the automatic text displayed in the row header for the specified row on this sheet.  
    Public Method Gets the row error text.  
    Public Method Gets whether the row on this sheet can be expanded to show a child view in a hierarchical display.  
    Public Method Gets a row on this sheet with a specific tag.  
    Public Method Gets the range of cells that are spanned at a specified cell on the row header of this sheet.  
    Public Method Gets the height in pixels for the specified row on this sheet.  
    Public Method Gets the text in the specified row header cell on this sheet.  
    Public Method Gets 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 Method Gets whether a forced page break is inserted before the specified row on this sheet when printing.  
    Public Method Gets whether users can resize the specified row on this sheet.  
    Public Method Gets whether a row on this sheet is displayed.  
    Public Method Gets 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 Method Gets a shape.  
    Public Method Gets the range of cells that are spanned at a specified cell on this sheet.  
    Public Method Gets the sparkline information.  
    Public Method Gets 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 Method Gets 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 Method Gets the unbound value for the cell on this sheet.  
    Public Method Gets validators which associates to the specified cell range.  
    Public Method Gets the valid conditional format.  
    Public Method Gets unformatted data from the specified cell on this sheet.  
    Public Method Gets the column on the sheet that corresponds to the specified column index in the model.  
    Public Method Gets 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 Method Gets whether any cells in the specified column on this sheet are selected.  
    Public Method Gets whether any cells in the specified row on this sheet are selected.  
    Public Method Gets whether the specified column on this sheet is bound to a data source.  
    Public Method Gets whether the specified row on this sheet is bound to a data source.  
    Public Method Gets whether the row on this sheet displays a child view in a hierarchical display.  
    Public Method Gets whether the specified cell on this sheet is selected.  
    Public Method Joins two shapes in the drawing container for the sheet.  
    Public Method Loads 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 Method Modifies 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 Method Moves 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 Method Changes 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 Method Opens 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 Method Evaluates all the formulas in cells on the sheet that have changed since the last calculation cycle.  
    Public Method Evaluates all the formulas in cells on the sheet (including those that have not changed since the last calculation cycle).  
    Public Method Removes the span that contains a specified anchor cell from a range of cells in the column footers.  
    Public Method Removes the span that contains a specified anchor cell from a range of cells in the column headers.  
    Public Method Removes 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 Method Removes 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 Method Removes 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 Method Removes the span that contains a specified anchor cell from a range of cells in the row headers.  
    Public Method Removes the row or rows on this sheet at the specified index.  
    Public Method Removes the specified selection from this sheet.  
    Public Method Removes the shape from the drawing container for the sheet.  
    Public Method Removes the span that contains a specified anchor cell from a range of cells on this sheet.  
    Public MethodRemoves a TableView.  
    Public Method Resets the view on this sheet to its original state.  
    Public Method Resumes 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 Method Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet.  
    Public Method Sets the error text for a specified cell.  
    Public Method Sets whether to make the child view on this sheet visible when the parent row is expanded.  
    Public Method Sets 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 Method Sets 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 Method Sets the automatic filter index for the specified column.  
    Public Method Sets the automatic sort index for the specified column.  
    Public Method Sets the value for a specified cell in a column header on this sheet.  
    Public Method Sets 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 Method Sets 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 Method Sets whether the user can resize a specified column on this sheet.  
    Public Method Sets the sort indicator for the specified column on this sheet.  
    Public Method Sets whether a column on this sheet is displayed.  
    Public Method Sets 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 Method Adds a comment to the specified custom name.  
    Public Method Sets the value for the specified cell on this sheet.  
    Public Method Sets a formula in a specified cell on this sheet.  
    Public Method Sets borders on the inside of a range of cells.  
    Public Method Sets the column index in the data model that corresponds to the specified column index in the sheet.  
    Public Method Sets the row index in the data model that corresponds to the specified row index in the sheet.  
    Public Method Sets the width in pixels for the specified columns on this sheet.  
    Public Method Sets the height in pixels for the specified rows on this sheet.  
    Public Method Sets a note in a specified cell on this sheet.  
    Public Method Sets the location and dimensions for a cell note when the style sets the note to always be shown.  
    Public Method Sets border outlines for a range of cells.  
    Public Method Sets error text for row.  
    Public Method Sets whether the row on this sheet can be expanded to show a child view in a hierarchical display.  
    Public Method Sets the height in pixels for the specified row on this sheet.  
    Public Method Sets the value for a specified cell in the row header on this sheet.  
    Public Method Sets 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 Method Sets whether a forced page break is inserted before the specified row on this sheet when printing.  
    Public Method Sets whether users can resize the specified row on this sheet.  
    Public Method Sets whether a row on this sheet is displayed.  
    Public Method Sets the style information for the cell notes on this sheet that stay visible.  
    Public Method Sets the style for a cell, a column, a row, or an entire sheet.  
    Public Method Sets 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 Method Gets whether the background image should be serialized.  
    Public Method Gets whether the horizontal grid line for the footer corner should be serialized.  
    Public Method Gets whether the vertical grid line for the footer corner should be serialized.  
    Public Method Gets whether the tiled background image should be serialized.  
    Public Method Shows or hides all cell notes on the sheet.  
    Public MethodOverloaded. Sorts a range of columns in the sheet.  
    Public Method Sorts a range of cells on this sheet in the data model.  
    Public MethodOverloaded. Sorts a range of rows in the sheet.  
    Public Method Suspends updates of values to the chart immediately.  
    Public Method Swaps 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 Method Validates a cell.  
    Top
    Public Events
     NameDescription
    Public Event Occurs when a change is made to a cell or range of cells on this sheet that may require the cell or range of cells be repainted.  
    Public Event Occurs when a change is made to the sheet that may require the entire sheet to be repainted (as with DefaultStyle or AlternatingRows).  
    Public Event Occurs when a change is made to a column or range of columns that may require the column or range of columns be repainted.  
    Public Event Fires when the SheetView is being disposed.  
    Public Event Occurs when a note for the viewport area is created on the sheet.  
    Public Event Occurs when a note for the viewport area is moved on the sheet.  
    Public Event Occurs when a note for the viewport area is sized on the sheet.  
    Public Event Occurs when the user changes a property of the sheet.  
    Public Event Occurs when the reference style changes.  
    Public Event Occurs when a change is made to a row or range of rows on this sheet that may require the row or range of rows be repainted.  
    Public Event Obsolete. Use NoteCreated instead. Occurs when a sticky note is created on the sheet.  
    Public Event Obsolete. Use NoteMoved instead. Occurs when a sticky note is moved on the sheet.  
    Public Event Obsolete. Use NoteSized instead. Occurs when a sticky note is sized on the sheet.  
    Top
    See Also