Spread Windows Forms 15.0
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 PropertyGets 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 PropertyGets or sets the row index of the active cell on the sheet.  
    Public PropertyGets or sets the skin for the sheet.  
    Public Property  
    Public PropertyGets or sets whether to allow the user to group rows on the sheet.  
    Public PropertyGets or sets whether notes on this sheet are editable.  
    Public PropertyGets 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 PropertyGets or sets whether the control recalculates each formula when the contents of dependent cells change for a sheet.  
    Public PropertyGets or sets whether the filter will automatically update for any changes.  
    Public PropertyGets or sets the AutoFilterMode.  
    Public PropertyGets or sets whether to automatically generate the columns for a sheet based on the data source.  
    Public PropertyGets or sets whether to allow automatic sorting for a sheet and whether to show the sort indicator.  
    Public PropertyGets or sets whether to use the Spread's enhanced filter menu.  
    Public PropertyGets or sets whether to use the Spread's sorting behavior in enhanced filter context menu.  
    Public PropertyGets or sets a value that indicates whether frozen rows are sorted.  
    Public PropertyGets or sets a value that indicates whether trailing frozen rows are sorted.  
    Public PropertyGets 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 PropertyGets or sets sheetview background image.  
    Public PropertyGets or sets sheetview background image layout.  
    Public PropertyGets a Cells object for the cells in the data area of the sheet.  
    Public PropertyGets the charts.  
    Public PropertyGets the number of child relations (data relation count) for a sheet.  
    Public PropertyInternal use only  
    Public PropertyGets the index of the last column that was automatically sorted for the sheet.  
    Public PropertyGets or sets the number of columns in the sheet.  
    Public PropertyGets the ColumnFooter object for the column footer area of the sheet.  
    Public PropertyGets or sets the horizontal grid line in the column footer for the sheet.  
    Public PropertyGets or sets the number of rows in the column footers for the sheet.  
    Public PropertyGets or sets the horizontal grid line for the column footer sheet corner.  
    Public PropertyGets or sets the style information for the sheet corner for the column footer.  
    Public PropertyGets or sets the name of the style for the sheet corner of the column footer.  
    Public PropertyGets or sets the vertical grid line for the column footer sheet corner.  
    Public PropertyGets or sets the vertical grid line in the column footer for the sheet.  
    Public PropertyGets 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 PropertyGets or sets which column header row in the sheet displays the filter indicator when there are multiple column header rows.  
    Public PropertyGets or sets which column header row in the sheet displays the sort indicator when there are multiple column header rows.  
    Public PropertyGets or sets whether column headers for the sheet display letters or numbers or are blank.  
    Public PropertyGets or sets which column header row for the sheet displays the automatic text when there are multiple column header rows.  
    Public PropertyGets or sets the horizontal grid line for the sheet.  
    Public PropertyGets or sets the number of rows in the column headers for the sheet.  
    Public PropertyGets or sets the vertical grid line in the column header for the sheet.  
    Public PropertyGets 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 (Inherited from System.ComponentModel.Component)
    Public PropertyGets the containing views.  
    Public PropertyGets or sets whether to allow the user to add a new row when the sheet is bound.  
    Public PropertyGets or sets whether a bound sheet automatically sets the cell type for the cells in a column.  
    Public PropertyGets or sets whether a bound sheet automatically assigns the data field names to be the text in the column headers.  
    Public PropertyGets or sets whether a bound sheet automatically sizes its columns based on the data in the associated database fields.  
    Public PropertyGets or sets the name of the data member that populates the sheet.  
    Public PropertyGets or sets the name of the data source that populates the sheet.  
    Public PropertyDefault setting for group footers.  
    Public PropertyGets or sets a StyleInfo object for the default style of the sheet.  
    Public PropertyGets or sets the name of the default style for the sheet.  
    Public PropertyGets or sets whether zero values are displayed in cells.  
    Public PropertyGets or sets a drawing container for the sheet for a drawing object in the drawing space.  
    Public PropertySets or gets whether cell diagonal line is enable.  
    Public PropertyGets or sets whether the enhanced filter shows items in the tree by default or alphabetic order.  
    Public PropertyGets or sets whether the rows are expandable.  
    Public PropertyGets the FilterBar object of the sheet.  
    Public PropertyGets or sets the horizontal grid line for the filter bar header.  
    Public PropertyGets or sets the style information for the filter bar header.  
    Public PropertyGets or sets the name of the style for the filter bar header.  
    Public PropertyGets or sets the vertical grid line for the filter bar.  
    Public PropertyGets or sets the horizontal grid line for the filter bar.  
    Public PropertyGets or sets the vertical grid line for the filter bar.  
    Public PropertyGets Fpspread from sheet view.  
    Public PropertyGets or sets the number of non-scrolling columns on the leading edge of this sheet.  
    Public PropertyGets or sets the number of non-scrolling rows on the leading edge of this sheet.  
    Public PropertyGets or sets the number of non-scrolling columns on the trailing edge of this sheet.  
    Public PropertyGets or sets the number of non-scrolling rows on the trailing edge of this sheet.  
    Public PropertyGets or sets whether the frozen trailing row(s) or column(s) stick to the edge of viewport area.  
    Public PropertyGets or sets the color in the area between the sheet and the edge of the control.  
    Public PropertyObsolete. Use GroupBarInfo.BackColor instead. Gets or sets the background color for the grouping bar of the sheet.  
    Public PropertyObsolete. Use GroupBarInfo.Height instead. Gets or sets the height of the grouping bar for the sheet.  
    Public PropertyGets or sets the information of the grouping bar for the sheet.  
    Public PropertyObsolete. Use GroupBarInfo.Visible instead. Gets or sets whether the grouping bar for the sheet is displayed.  
    Public PropertyGets or sets whether the group footer is displayed.  
    Public PropertyGets or sets the collection of grouping information objects for the sheet.  
    Public PropertyGets or sets grouping policy to collapse or expand rows when grouping occurs.  
    Public PropertyGets or sets the maximum number of levels of grouping for the sheet.  
    Public PropertyObsolete. Use GroupBarInfo.GroupVerticalIndent instead. Gets or sets the separation of grouping levels for the sheet.  
    Public PropertyGets or sets the horizontal grid line for this sheet.  
    Public Property  
    Public PropertyGets whether a block of cells on this sheet is currently selected.  
    Public PropertyGets or sets whether circular references are evaluated on this sheet.  
    Public PropertyGets or sets the background color of locked cells on this sheet.  
    Public PropertyGets or sets the default font for locked items on this sheet.  
    Public PropertyGets or sets the foreground color of locked cells on this sheet.  
    Public PropertyGets or sets the maximum amount of change below which iterations stop when circular references are evaluated on this sheet.  
    Public PropertyGets or sets the maximum number of iterations for calculating circular references on this sheet.  
    Public PropertyGets 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 PropertyGets a value that is one more than the index of the last column on this sheet containing data.  
    Public PropertyGets a value that is one more than the index of the last row on this sheet containing data.  
    Public PropertyInternal use only. Gets or sets the drawing container for cell notes in the drawing space.  
    Public PropertyGets or sets the background color of null items on this sheet.  
    Public PropertyGets or sets the default font for null items on this sheet.  
    Public PropertyGets or sets the foreground color of null items on this sheet.  
    Public PropertyGets 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 PropertyGets the data relation name for this sheet.  
    Public PropertyGets the index of the parent row on this sheet.  
    Public PropertyGets or sets preview row information for the sheet.  
    Public PropertyGets or sets a PrintInfo object that determines printing behavior for the sheet.  
    Public PropertyInternal use only  
    Public PropertyGets or sets whether cells on this sheet that are marked as locked are not editable.  
    Public PropertyGets or sets the background color of the outline (range group) region.  
    Public PropertyGets or sets the style of the outline (range group) button.  
    Public PropertyGets or sets whether the direction of the summary column is to the right of the detail.  
    Public PropertyGets or sets whether the direction of the summary row is below the detail.  
    Public PropertyGets or sets the style for cell and range references in formulas in cells on this sheet.  
    Public Property  
    Public PropertyGets 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 PropertyGets 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 PropertyGets or sets the number of rows on this sheet.  
    Public PropertyGets or sets the row filter for the sheet.  
    Public PropertyGets the RowHeader object for the row header area of the sheet.  
    Public PropertyGets or sets whether row headers on this sheet display letters or numbers or are blank.  
    Public PropertyGets or sets which row header column on this sheet displays the automatic text when there are multiple row header columns.  
    Public PropertyGets or sets the number of columns in the row header on this sheet.  
    Public PropertyGets or sets the horizontal grid line in the row header on this sheet.  
    Public PropertyGets or sets which row header column in the sheet displays the row selector when there are multiple row header columns.  
    Public PropertyGets or sets the vertical grid line in the row header on this sheet.  
    Public PropertyGets 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 PropertyInternal use only.  
    Public PropertyGets or sets the information of the vertical scrolling tip for the sheet.  
    Public PropertyGets or sets the background color of selections on this sheet.  
    Public PropertyGets the number of selections on this sheet.  
    Public PropertyGets or sets the default font for selected items on this sheet.  
    Public PropertyGets or sets the foreground color of selections on this sheet.  
    Public PropertyGets the selection policy for the sheet for normal operation mode.  
    Public PropertyGets or sets how selections on this sheet are drawn.  
    Public PropertyGets or sets the smallest unit users or the application can select on this sheet.  
    Public PropertyGets 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 PropertyGets the sheet corner of the sheet.  
    Public PropertyGets or sets the horizontal grid line for the sheet corner.  
    Public PropertyGets or sets the style information for the sheet corner.  
    Public PropertyGets or sets the name of the style for the sheet corner.  
    Public PropertyGets or sets the vertical grid line for the sheet corner.  
    Public PropertyGets or sets the name of the sheet.  
    Public PropertyGets 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  
    Public PropertyGets or sets a value that indicates whether to display a row selector in the row header of the selected row for the sheet.  
    Public PropertyOverridden. Gets or sets the site.  
    Public PropertyGets or sets a sparkline container for the sheet for maintaining sparklines.  
    Public PropertyGets or sets the number or letter displayed in the first column header on this sheet.  
    Public PropertyGets or sets the number or letter displayed in the first row header on this sheet.  
    Public Property  
    Public PropertyGets or sets an application-defined tag value associated with the cells in this sheet.  
    Public PropertySheet title  
    Public PropertyGets the object which manages all DataValidtions.  
    Public PropertyGets or sets the vertical grid line on this sheet.  
    Public PropertyGet or set the view type of a SheetView.  
    Public PropertyGets or sets whether to display the sheet.  
    Public PropertyGets or sets whether to use visual styles when rendering objects in the sheet.  
    Public PropertyGets or sets the scaling factor for displaying this sheet.  
    Top
    Protected Properties
     NameDescription
    Protected Property (Inherited from System.ComponentModel.Component)
    Protected Property (Inherited from System.ComponentModel.Component)
    Protected PropertyGets or sets a value that indicates whether to ignore applying Spread skin.  
    Protected PropertyGets a value that indicates whether SheetView is initialized.  
    Top
    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 Method  
    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 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 sheet.  
    Public MethodOverloaded. Pastes the shape from the Clipboard.  
    Public MethodCreates a copy of the sheet.  
    Public MethodChecks whether a specified range contains multi-cells array formula  
    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 MethodCopy SC's tablestyle of this SheetView to target SheetView. Intended to be use when creata a new SheetView from another SheetView in designer only Internal use only.  
    Public Method (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Overridden. Cleans up any resources being used.  
    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 Method  
    Public MethodGets all formula array. Internal use only.  
    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 MethodInternal use only. Gets the cell note object of a specified cell on this sheet.  
    Public MethodGets the CellType.  
    Public MethodGet chart at index.  
    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 MethodGets composited style and return its properties. Support feature exporting to html  
    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 filter items to be displayed in the drop-down list for the specified column.  
    Public MethodGets the editor used to edit a specified cell on this sheet.  
    Public Method  
    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 formula array at the specified row and column index. Internal use only.  
    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 Method (Inherited from System.MarshalByRefObject)
    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 of a specified cell on this sheet.  
    Public MethodGets the rectangle for the cell note for the specified cell if its NoteStyle is StickyNote.  
    Public Method  
    Public Method  
    Public MethodGets the composited style of notes of a specified cell on this sheet.  
    Public Method  
    Public MethodSerializes the object to the SerializationInfo object.  
    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 validators which associates to the specified cell range.  
    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 Method (Inherited from System.MarshalByRefObject)
    Public Method  
    Public MethodResets all the temporary filter settings and filters the rows again based on the filter settings of each column. (Internal use only.)  
    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 MethodReload the expressions of all Conditional Formatting in current sheet, when we have fully data.  
    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 data model for this sheet in synchronization with the data source.  
    Public MethodChanges the sheet column axis model in synchronization with the data source.  
    Public MethodChanges the sheet row axis model in synchronization with the data source.  
    Public MethodChanges the sheet row axis model in synchronization with the data source.  
    Public MethodChanges the span model in sync with the data source for this sheet.  
    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 MethodInternal Use: Resets the display of rows based on the "(All)" filter item in the drop-down list. (Internal use only.)  
    Public MethodResumes updates of values to the chart immediately.  
    Public MethodResumes parsing of formulas and parses all formulas set while parsing was suspended.  
    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 on this sheet should display 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 MethodOverloaded. Internal Use: Applies the row filtering to the specified column when the specified filter item is selected from the drop-down list. (Internal use only.)  
    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 horizontal grid line for the data area should be serialized.  
    Public MethodGets whether the tiled background image should be serialized.  
    Public MethodGets whether the document models for the sheet should be persisted.  
    Public MethodInternal use only.  
    Public MethodGets whether the horizontal grid line for the corner should be serialized.  
    Public MethodGets whether the vertical grid line for the corner should be serialized.  
    Public MethodGets whether the vertical grid line for the data area should be serialized.  
    Public MethodGets whether the zoom factor should be serialized.  
    Public MethodShows or hides all cell notes on the sheet.  
    Public MethodOverloaded. Sorts all the columns on the sheet by the specified row.  
    Public MethodSorts a range of cells on this sheet in the data model.  
    Public MethodOverloaded. Sorts all the rows on this sheet by the specified column.  
    Public MethodSuspends updates of values to the chart immediately.  
    Public MethodSuspends parsing of formulas.  
    Public MethodSwaps the data and formatting in a block of cells on this sheet with another block of cells on this sheet.  
    Public Method (Inherited from System.ComponentModel.Component)
    Public MethodOverloaded. Ungroups the sparkline.  
    Public Method  
    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 MethodOverridden. The destructor method  
    Protected MethodGets the number of the visible columns.  
    Protected MethodGets the number of the visible rows.  
    Protected Method (Inherited from System.ComponentModel.Component)
    Protected MethodProperty names.  
    Protected MethodOverloaded.  (Inherited from System.MarshalByRefObject)
    Protected MethodOccurs when footer rows are added.  
    Protected MethodOccurs when column header rows are added.  
    Protected MethodOccurs when columns are added.  
    Protected MethodOccurs when row header columns are added.  
    Protected MethodOccurs when rows are added.  
    Protected MethodOccurs when the cell is changed.  
    Protected MethodOccurs when the cells are copied.  
    Protected MethodOccurs when the columns are copied.  
    Protected MethodOccurs when rows are copied.  
    Protected MethodRaises the Disposing event  
    Protected MethodOccurs when the cells are moved.  
    Protected MethodOccurs when columns are moved.  
    Protected MethodOccurs when rows are moved.  
    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 MethodOccurs when column header rows are removed.  
    Protected MethodOccurs when columns are removed.  
    Protected MethodOccurs when row header columns are removed.  
    Protected MethodOccurs when rows are removed.  
    Protected MethodObsolete. Use OnNoteCreated(object sender, EventArgs e) instead. Occurs when a note is created in the sheet's notes container.  
    Protected MethodObsolete. Use OnNoteMoved(object sender, EventArgs e) instead. Occurs when a note is moved in the sheet's notes container.  
    Protected MethodObsolete. Use OnNoteSized(object sender, EventArgs e) instead. Occurs when a note is sized in the sheet's notes container.  
    Protected MethodOccurs when the style model is changed.  
    Protected MethodOccurs when the cells are swapped.  
    Protected MethodOccurs when columns are swapped.  
    Protected MethodOccurs when rows are swapped.  
    Protected MethodDetermines whether the alternating rows should be serialized.  
    Protected MethodDetermines whether the cells should be serialized.  
    Protected MethodGets whether the style for the sheet corner should be serialized.  
    Protected MethodDetermines whether the columns should be serialized.  
    Protected MethodGets whether the DefaultStyle property should be serialized.  
    Protected MethodGets whether the style for the filter bar header should be serialized.  
    Protected MethodGets whether the GrayAreaBackColor property 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 print information should be serialized.  
    Protected MethodDetermines whether the rows should be serialized.  
    Protected MethodDetermines whether the named styles should be serialized.  
    Protected MethodDetermines whether selection background color should be serialized.  
    Protected MethodDetermines whether selection font should be serialized.  
    Protected MethodDetermines whether selection text color should be serialized.  
    Protected MethodGets whether the style for the sheet corner should be serialized.  
    Top
    Public Events
     NameDescription
    Public EventOccurs 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 EventOccurs when a change is made to the sheet that may require the entire sheet to be repainted (as with DefaultStyle or AlternatingRows).  
    Public EventOccurs 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 (Inherited from System.ComponentModel.Component)
    Public EventFires when the SheetView is being disposed.  
    Public EventOccurs when a note for the viewport area is created on the sheet.  
    Public EventOccurs when a note for the viewport area is moved on the sheet.  
    Public EventOccurs when a note for the viewport area is sized on the sheet.  
    Public EventOccurs when the user changes a property of the sheet.  
    Public EventOccurs when the reference style changes.  
    Public EventOccurs 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 EventObsolete. Use NoteCreated instead. Occurs when a sticky note is created on the sheet.  
    Public EventObsolete. Use NoteMoved instead. Occurs when a sticky note is moved on the sheet.  
    Public EventObsolete. Use NoteSized instead. Occurs when a sticky note is sized on the sheet.  
    Top
    See Also