Spread Windows Forms 6.0 Product Documentation
SheetView Class Members
See Also Properties Methods Events Support Options

	Name	Description
	ActiveCell	Gets a Cell object for the active cell on the sheet.
	ActiveColumn	Gets a Column object for the active column on the sheet.
	ActiveColumnIndex	Gets or sets the column index of the active cell on the sheet.
	ActiveRow	Gets a Row object for the active row on the sheet.
	ActiveRowIndex	Gets or sets the row index of the active cell on the sheet.
	ActiveSkin	Gets or sets the skin for the sheet.
	AllowGroup	Gets or sets whether to allow the user to group rows on the sheet.
	AllowNoteEdit	Gets or sets whether notes on this sheet are editable.
	AllowTableCorner	Gets or sets whether the sheet corner can have a grid structure (table).
	AlternatingRows	Gets an AlternatingRows object for the alternating rows in the data area of the sheet.
	AutoCalculation	Gets or sets whether the control recalculates each formula when the contents of dependent cells change for a sheet.
	AutoGenerateColumns	Gets or sets whether to automatically generate the columns for a sheet based on the data source.
	AutoSortColumns	Gets or sets whether to allow automatic sorting for a sheet and whether to show the sort indicator.
	AutoSortFrozenRows	Gets or sets a value indicates whether frozen rows are sorted.
	AutoSortTrailingFrozenRows	Gets or sets a value indicates whether trailing frozen rows are sorted.
	AutoUpdateNotes	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.
	Cells	Gets a Cells object for the cells in the data area of the sheet.
	Charts	Gets the charts.
	ChildRelationCount	Gets the number of child relations (data relation count) for a sheet.
	ColumnAutoSorted	Gets the index of the last column that was automatically sorted for the sheet.
	ColumnCount	Gets or sets the number of columns in the sheet.
	ColumnFooter	Gets the ColumnHeader object for the column footer area of the sheet.
	ColumnFooterHorizontalGridLine	Gets or sets the horizontal grid line for the columnFooter.
	ColumnFooterRowCount	Gets or sets the number of rows in the column footers for the sheet.
	ColumnFooterSheetCornerHorizontalGridLine	Gets or sets the horizontal grid line for the column footer sheet corner.
	ColumnFooterSheetCornerStyle	Gets or sets the style information for the sheet corner for columnFooter.
	ColumnFooterSheetCornerStyleName	Gets or sets the name of the style for the sheet corner of column Footer.
	ColumnFooterSheetCornerVerticalGridLine	Gets or sets the vertical grid line for the column footer sheet corner.
	ColumnFooterVerticalGridLine	Gets or sets the vertical grid line in the column footer for the sheet.
	ColumnFooterVisible	Gets or sets whether the column Footers for this sheet are visible.
	ColumnHeader	Gets the ColumnHeader object for the column header area of the sheet.
	ColumnHeaderAutoFilterIndex	Gets or sets which column header row in the sheet displays the filter indicator when there are multiple column header rows.
	ColumnHeaderAutoSortIndex	Gets or sets which column header row in the sheet displays the sort indicator when there are multiple column header rows.
	ColumnHeaderAutoText	Gets or sets whether column headers for the sheet display letters or numbers or are blank.
	ColumnHeaderAutoTextIndex	Gets or sets which column header row for the sheet displays the automatic text when there are multiple column header rows.
	ColumnHeaderHorizontalGridLine	Gets or sets the horizontal grid line for the sheet.
	ColumnHeaderRowCount	Gets or sets the number of rows in the column headers for the sheet.
	ColumnHeaderVerticalGridLine	Gets or sets the vertical grid line in the column header for the sheet.
	ColumnHeaderVisible	Gets or sets whether the column headers for this sheet are visible.
	Columns	Gets a Columns object for the columns in the data area of the sheet.
	ContainingViews	Gets the containing views.
	DataAllowAddNew	Gets or sets whether to allow the user to add a new row when the sheet is bound.
	DataAutoCellTypes	Gets or sets whether a bound sheet automatically sets the cell type for the cells in a column.
	DataAutoHeadings	Gets or sets whether a bound sheet automatically assigns the data field names to be the text in the column headers.
	DataAutoSizeColumns	Gets or sets whether a bound sheet automatically sizes its columns based on the data in the associated database fields.
	DataMember	Gets or sets the name of the data member that populates the sheet.
	DataSource	Gets or sets the name of the data source that populates the sheet.
	DefaultGroupFooter	Default setting for group footers
	DefaultStyle	Gets or sets a StyleInfo object for the default style of the sheet.
	DefaultStyleName	Gets or sets the name of the default style for the sheet.
	DisplayZero	Gets or sets whether zero values are displayed in cells.
	Expandable	Gets or sets whether the rows are expandable.
	FpSpread	Get Fpspread form sheet view
	FrozenColumnCount	Gets or sets the number of non-scrolling columns on the leading edge of this sheet.
	FrozenRowCount	Gets or sets the number of non-scrolling rows on the leading edge of this sheet.
	FrozenTrailingColumnCount	Gets or sets the number of non-scrolling columns on the trailing edge of this sheet.
	FrozenTrailingRowCount	Gets or sets the number of non-scrolling rows on the trailing edge of this sheet.
	GrayAreaBackColor	Gets or sets the color in the area between the sheet and the edge of the control.
	GroupBarInfo	Gets or sets the info of the grouping bar for the sheet.
	GroupFooterVisible	Gets or sets whether the group footer is displayed.
	GroupInfos	Gets or sets the collection of grouping information objects for the sheet.
	GroupingPolicy	Gets or sets grouping policy to collapse or expand rows when grouping occurs.
	GroupMaximumLevel	Gets or sets the maximum number of levels of grouping for the sheet.
	HorizontalGridLine	Gets or sets the horizontal grid line for this sheet.
	IsBlockSelected	Gets whether a block of cells on this sheet is currently selected.
	Iteration	Gets or sets whether circular references are evaluated on this sheet.
	LockBackColor	Gets or sets the background color of locked cells on this sheet.
	LockFont	Gets or sets the default font for locked items on this sheet.
	LockForeColor	Gets or sets the foreground color of locked cells on this sheet.
	MaximumChange	Gets or sets the maximum amount of change below which iterations stop when circular references are evaluated on this sheet.
	MaximumIterations	Gets or sets the maximum number of iterations for calculating circular references on this sheet.
	Models	Gets or sets a SheetView.DocumentModels object that contains all the models for the sheet.
	NamedStyles	Gets or sets a NamedStyleCollection of NamedStyle objects for this sheet.
	NonEmptyColumnCount	Gets a value that is one more than the index of the last column on this sheet containing data.
	NonEmptyRowCount	Gets a value that is one more than the index of the last row on this sheet containing data.
	NullBackColor	Gets or sets the background color of null items on this sheet.
	NullFont	Gets or sets the default font for null items on this sheet.
	NullForeColor	Gets or sets the foreground color of null items on this sheet.
	OperationMode	Gets or sets the mode that determines mouse, keyboard, and selection behavior for this sheet.
	Parent	Gets or sets the name of the parent sheet (SheetView object) of this sheet.
	ParentRelationName	Gets the data relation name for this sheet.
	ParentRowIndex	Gets the index of the parent row on this sheet.
	PreviewRowInfo	Gets or sets preview row information for the sheet.
	PrintInfo	Gets or sets a PrintInfo object that determines printing behavior for the sheet.
	Protect	Gets or sets whether cells on this sheet that are marked as locked are uneditable.
	RangeGroupBackgroundColor	Gets or sets the background color of the outline (range group) region.
	RangeGroupButtonStyle	Gets or sets the style of the outline (range group) button.
	ReferenceStyle	Gets or sets the style for cell and range references in formulas in cells on this sheet.
	RestrictColumns	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.
	RestrictRows	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.
	RowCount	Gets or sets the number of rows on this sheet.
	RowFilter	Gets or sets the row filter for the sheet.
	RowHeader	Gets the RowHeader object for the row header area of the sheet.
	RowHeaderAutoText	Gets or sets whether row headers on this sheet display letters or numbers or are blank.
	RowHeaderAutoTextIndex	Gets or sets which row header column on this sheet displays the automatic text when there are multiple row header columns.
	RowHeaderColumnCount	Gets or sets the number of columns in the row header on this sheet.
	RowHeaderHorizontalGridLine	Gets or sets the horizontal grid line in the row header on this sheet.
	RowHeaderSelectorIndex	Gets or sets which row header column in the sheet displays the row selector when there are multiple row header columns.
	RowHeaderVerticalGridLine	Gets or sets the vertical grid line in the row header on this sheet.
	RowHeaderVisible	Gets or sets whether the row headers for this sheet are visible.
	Rows	Gets a Rows object for the rows in the data area of the sheet.
	ScrollingContentInfo	Gets or sets the info of the vertical scrolling tip for the sheet.
	SelectionBackColor	Gets or sets the background color of selections on this sheet.
	SelectionCount	Gets the number of selections on this sheet.
	SelectionFont	Gets or sets the default font for selected items on this sheet.
	SelectionForeColor	Gets or sets the foreground color of selections on this sheet.
	SelectionPolicy	Gets the selection policy for the sheet for normal operation mode.
	SelectionStyle	Gets or sets how selections on this sheet are drawn.
	SelectionUnit	Gets or sets the smallest unit users or the application can select on this sheet.
	SerializeModels	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.
	SheetCorner	Gets the sheet corner of the sheet.
	SheetCornerHorizontalGridLine	Gets or sets the horizontal grid line for the sheet corner.
	SheetCornerStyle	Gets or sets the style information for the sheet corner.
	SheetCornerStyleName	Gets or sets the name of the style for the sheet corner.
	SheetCornerVerticalGridLine	Gets or sets the vertical grid line for the sheet corner.
	SheetName	Gets or sets the name of the sheet.
	ShowRowSelector	Gets or sets a value indicating whether display a row selector in the row header of the selected row for the sheet.
	SparklineContainer
	StartingColumnNumber	Gets or sets the number or letter displayed in the first column header on this sheet.
	StartingRowNumber	Gets or sets the number or letter displayed in the first row header on this sheet.
	Tag	Gets or sets an application-defined tag value associated with the cells in this sheet.
	TitleInfo	Sheet title
	VerticalGridLine	Gets or sets the vertical grid line on this sheet.
	Visible	Gets or sets whether to display the sheet.
	VisualStyles	Gets or sets whether to use visual styles when rendering objects in the sheet.
	ZoomFactor	Gets or sets the scaling factor for displaying this sheet.

	Name	Description
	CanRaiseEvents	(Inherited from System.ComponentModel.Component)
	IgnoreApplySpreadSkin	Gets or sets a value indicates whether to ignore applying Spread skin.
	IsInitializing	Gets a value indicates whether SheetView is initialized.

	Name	Description
	AddChart	Overloaded. Adds the chart control.
	AddColumnFooterSpanCell	Adds a span of cells to a column Footer for a sheet.
	AddColumnHeaderSpanCell	Adds a span of cells to a column header for a sheet.
	AddColumns	Adds the column or columns to the data model at the specified index.
	AddControl	Overloaded. Adds a child control to the control container for the sheet.
	AddCustomFunction	Adds a user-defined custom function (FunctionInfo object) to the model for use in formulas.
	AddCustomName	Overloaded. Adds a custom name to the model using the specified string value.
	AddRangeGroup	Groups all the rows or columns from the specified start index by the specified amount to an outline (range group).
	AddRowHeaderSpanCell	Adds a span of cells to a row header for a sheet.
	AddRows	Adds a row or rows to the data model for a sheet.
	AddRowToDataSource	Adds the unbound row to the data source for a sheet.
	AddSelection	Adds a selection on this sheet.
	AddShape	Overloaded. Adds a shape to the drawing container for the sheet.
	AddSpanCell	Adds a span of cells on this sheet.
	AddSparkline	Overloaded. Adds the sparkline.
	AddSquareSparkline	Adds the sparkline.
	AddUnboundRows	Adds unbound rows to the data model for a sheet.
	AutoFilterColumn	Automatically filters the rows in the specified column according to the specified filter.
	AutoFilterReset	Resets the filters on the rows in the specified column.
	AutoSortColumn	Overloaded. Automatically sorts the rows of a sheet according to the specified column.
	BindDataColumn	Binds the column to the data source column for a sheet.
	ClearColumnFooterSpanCells	Removes all spans from the column footers.
	ClearColumnHeaderSpanCells	Removes all spans from the column headers.
	ClearConditionalFormats	Removes all of the conditional formats from the cell at the specified row and column.
	ClearControls	Removes all child controls from the control container for the sheet.
	ClearCustomFunctions	Removes all user-defined custom functions (FunctionInfo object) on this sheet from the model.
	ClearCustomNames	Removes all custom names on this sheet from the model.
	ClearRange	Overloaded. Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.
	ClearRangeGroup	Removes all the outlines (range grouping) from all rows or columns.
	ClearRowFilter	Overloaded. Removes all of the row filters from this sheet.
	ClearRowHeaderSpanCells	Removes all spans from the row headers.
	ClearSelection	Removes all selections from this sheet.
	ClearShapes	Removes all shapes from the drawing container for the sheet.
	ClearSpanCells	Removes all spans from this sheet.
	ClearSparklineGroupsInRange	Clear all sparkline groups
	ClearSparklines	Clears all sparklines
	ClipboardCopy	Overloaded. Copies the contents from the sheet to the Clipboard.
	ClipboardCopyShape	Copies the active shape to the Clipboard.
	ClipboardCut	Overloaded. Cuts the contents from the sheet to the Clipboard.
	ClipboardCutShape	Cuts the active shape to the Clipboard.
	ClipboardPaste	Overloaded. Pastes the contents from the Clipboard to the active sheet.
	ClipboardPasteShape	Overloaded. Pastes the shape from the Clipboard.
	CopyRange	Copies the data, formatting, formulas, and notes from a block of cells on the sheet to a new location.
	ExpandRangeGroup	Overloaded. Expands or collapses a specified outline (range group) of rows or columns.
	ExpandRow	Expands or collapses the specified parent row, which shows or hides the child view in a hierarchical display.
	FillRange	Overloaded. Fills a range of cells on this sheet by copying a specified range in the specified direction.
	FindChildView	Gets the child view for this sheet with the specified name.
	GetArray	Gets a two-dimensional array of objects containing the data for the specified range of cells on the sheet.
	GetCellFromTag	Gets a cell with a specific tag on the sheet.
	GetCellType	Gets the composited (that is, inherited) cell type for a specified cell on the sheet.
	GetChildRelation	Gets the name of the child data relation at the specified index on the sheet.
	GetChildSheets	Gets a list of child sheet views that have been created.
	GetChildView	Creates the sheet (SheetView object) for the specified row and the specified relation index.
	GetChildVisible	Gets whether to show the child view on this sheet when the parent row is expanded.
	GetClip	Gets a tab-delimited string that contains the formatted data in a specified range of cells on this sheet.
	GetClipDataObject	Gets a data object with the necessary formats for Clipboard usage: CellInfoRange, ColumnInfoRange and RowInfoRange
	GetClipValue	Gets a tab-delimited string that contains the unformatted data in a range of cells on this sheet.
	GetColumnAllowAutoSort	Gets whether the specified column on this sheet allows automatic sorting.
	GetColumnAllowFilter	Gets whether this column contains a column filter definition.
	GetColumnAutoFilterIndex	Gets the auto filter index for the specified column.
	GetColumnAutoSortIndex	Gets the auto sort index for the specified column.
	GetColumnAutoText	Gets the automatic text displayed in the column header for the specified column on this sheet.
	GetColumnFooterText	Gets the text in the specified column footer cell on this sheet.
	GetColumnFromTag	Gets a column on this sheet with a specific tag.
	GetColumnHeaderSpanCell	Gets the range of cells that are spanned at a specified cell on the column header of this sheet.
	GetColumnLabel	Gets the text in the specified column header cell on this sheet.
	GetColumnMerge	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.
	GetColumnPageBreak	Gets whether a forced page break is inserted before the specified column on this sheet when printing.
	GetColumnShowSortIndicator	Gets whether the specified column on this sheet should show a sort indicator when automatically sorted.
	GetColumnSizeable	Gets whether the user can resize a specified column on this sheet.
	GetColumnSortIndicator	Gets the sort indicator for the specified column on this sheet.
	GetColumnVisible	Gets whether a column on this sheet is displayed.
	GetColumnWidth	Gets the width in pixels for the specified column on this sheet.
	GetConditionalFormats	Overloaded. Gets the conditional formats for the cell at the specified row and column.
	GetControl	Gets a child control.
	GetControlContainer	Gets the control container for a sheet.
	GetCustomFunction	Gets a user-defined custom function (FunctionInfo object) from the model for this sheet.
	GetCustomFunctionEnumerator	Gets an IEnumerator for this sheet that enumerates through the names of the user-defined custom functions (FunctionInfo objects) in the model.
	GetCustomName	Overloaded. Gets the string value for a custom name on this sheet from the model.
	GetCustomNameEnumerator	Gets an IEnumerator on this sheet that enumerates through the custom names defined in the model.
	GetDataView	Gets the DataView object on this sheet.
	GetEditor	Gets the editor used to edit a specified cell on this sheet.
	GetExpression	Gets the formula, as an expression value, for the cell of the specified row and column of this sheet.
	GetFormula	Gets the formula of the specified cell on this sheet.
	GetLastNonEmptyColumn	Gets the index of the last column that contains data or formatting on this sheet.
	GetLastNonEmptyRow	Gets the row index of the last row that contains data or formatting on this sheet.
	GetModelColumnFromViewColumn	Gets the column index in the data model that corresponds to the specified column index in the sheet.
	GetModelRowFromViewRow	Gets the row index in the data model that corresponds to the specified row index in the sheet.
	GetNote	Gets the note (comments) from a specified cell.
	GetNoteBounds	Gets the rectangle for the cell note for the specified cell if its NoteStyle is StickyNote.
	GetPreferredCellSize	Gets the desired size of the given cell on this sheet.
	GetPreferredColumnWidth	Overloaded. Gets the width of the widest cell (based on text contents) in the specified column on this sheet.
	GetPreferredPrintColumnWidth	Gets the width of the widest cell (based on text contents) in the specified column on this sheet for printing to the specified graphics device.
	GetPreferredPrintRowHeight	Gets the height in pixels of the tallest cell (based on text contents) in the specified row on this sheet.
	GetPreferredRowHeight	Overloaded. Gets the height in pixels of the tallest cell (based on text contents) in the specified row on this sheet.
	GetRangeGroupInfo	Gets range groups of rows or columns by level.
	GetRangeGroupLevels	Gets the number of levels of rows or columns in the outline (range group).
	GetRenderer	Gets the renderer used to render a specified cell on this sheet.
	GetRootSheet	Gets the top SheetView object.
	GetRowAutoText	Gets the automatic text displayed in the row header for the specified row on this sheet.
	GetRowExpandable	Gets whether the row on this sheet can be expanded to show a child view in a hierarchical display.
	GetRowFromTag	Gets a row on this sheet with a specific tag.
	GetRowHeaderSpanCell	Gets the range of cells that are spanned at a specified cell on the row header of this sheet.
	GetRowHeight	Gets the height in pixels for the specified row on this sheet.
	GetRowLabel	Gets the text in the specified row header cell on this sheet.
	GetRowMerge	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.
	GetRowPageBreak	Gets whether a forced page break is inserted before the specified row on this sheet when printing.
	GetRowSizeable	Gets whether the user can resize the specified row on this sheet.
	GetRowVisible	Gets whether a row on this sheet is displayed.
	GetSelection	Gets the selection on this sheet with the specified index.
	GetSelections	Gets an ordered array of FarPoint.Win.Spread.Model.CellRange objects, from largest to smallest, containing the selected cells on the sheet with minimal overlap between the ranges.
	GetShape	Gets a shape.
	GetSpanCell	Gets the range of cells that are spanned at a specified cell on this sheet.
	GetSparkline	Gets the sparkline info.
	GetStickyNoteStyleInfo	Gets the style information for the cell notes on this sheet that stay visible.
	GetStyleInfo	Overloaded. Gets the style information for a specified cell on this sheet.
	GetTag	Gets the application-defined tag value for the specified cell, column, row, or entire sheet.
	GetText	Gets the formatted text in the cell on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell.
	GetUnboundValue	Gets the unbound value for the cell on this sheet.
	GetValue	Gets unformatted data from the specified cell on this sheet.
	GetViewColumnFromModelColumn	Gets the column on the sheet that corresponds to the specified column index in the model.
	GetViewRowFromModelRow	Gets the row on the sheet that corresponds to the specified row index in the model.
	GroupSparkline	Overloaded. Groups the sparkline and sets the type of new group.
	IsAnyCellInColumnSelected	Gets whether any cells in the specified column on this sheet are selected.
	IsAnyCellInRowSelected	Gets whether any cells in the specified row on this sheet are selected.
	IsColumnBound	Gets whether the specified column on this sheet is bound to a data source.
	IsRowBound	Gets whether the specified row on this sheet is bound to a data source.
	IsRowExpanded	Gets whether the row on this sheet displays a child view in a hierarchical display.
	IsSelected	Gets whether the specified cell on this sheet is selected.
	JoinShapes	Joins two shapes in the drawing container for the sheet.
	LoadFormulas	Loads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized.
	LoadTextFile	Overloaded. Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.
	MoveColumn	Overloaded. 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.
	MoveRange	Moves the data, formatting, formulas, and notes from a block of cells on this sheet to a new location.
	MoveRow	Overloaded. Moves the specified row 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.
	OnSheetRangeGroupModelChanged	Changes the sheet row axis model in synchronization with the data source.
	Open	Overloaded. Opens a saved XML file into a sheet view.
	OpenExcel	Overloaded. Opens an Excel file and loads the specified sheet (by name) from that file into this sheet.
	OpenSpreadFile	Opens a saved Spread file into this sheet.
	RaiseCellChanged	Overloaded. Raises the CellChanged event (that a change has been made to a cell on this sheet).
	RaisePropertyChanged	Raises the PropertyChanged event for this sheet.
	Recalculate	Evaluates all the formulas in cells on the sheet that have changed since the last calculation cycle.
	RecalculateAll	Evaluates all the formulas in cells on the sheet (including those that have not changed since the last calculation cycle).
	RemoveColumnFooterSpanCell	Removes the span that contains a specified anchor cell from a range of cells in the column footers.
	RemoveColumnHeaderSpanCell	Removes the span that contains a specified anchor cell from a range of cells in the column headers.
	RemoveColumns	Removes the column or columns on this sheet at the specified index.
	RemoveControl	Overloaded. Removes the child control from the control container for the sheet.
	RemoveCustomFunction	Removes a user-defined custom function (FunctionInfo object) on this sheet from the model.
	RemoveCustomName	Removes a custom name on this sheet from the model.
	RemoveRangeGroup	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.
	RemoveRowHeaderSpanCell	Removes the span that contains a specified anchor cell from a range of cells in the row headers.
	RemoveRows	Removes the row or rows on this sheet at the specified index.
	RemoveSelection	Removes the specified selection from this sheet.
	RemoveShape	Removes the shape from the drawing container for the sheet.
	RemoveSpanCell	Removes the span that contains a specified anchor cell from a range of cells on this sheet.
	Reset	Resets the view on this sheet to its original state.
	ResumeAutoUpdateChartData	Resume update of values to chart immediately.
	Save	Overloaded. Saves the contents of the sheet view to the specified file.
	SaveHtml	Overloaded. Saves the sheet to the specified file in HTML.
	SaveHtmlRange	Overloaded. Saves the specified range in the sheet to the specified file in HTML.
	SaveTextFile	Overloaded. Saves the sheet as delimited text to a stream with specific delimiters.
	SaveTextFileRange	Overloaded. Saves the range of cells in a sheet to a text file with the specified name, formatting settings, and delimiters.
	SaveXml	Overloaded. Saves the data on the sheet to the specified XML stream and the schema to the specified schema stream.
	SetActiveCell	Overloaded. Sets the active cell on this sheet.
	SetArray	Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet.
	SetChildVisible	Sets whether to make the child view on this sheet visible when the parent row is expanded.
	SetClip	Sets a tab-delimited string of formatted text in a specified range of cells on this sheet.
	SetClipSpecial	Overloaded. Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.
	SetClipValue	Sets a tab-delimited string of unformatted data in a specified range of cells on this sheet.
	SetColumnAllowAutoSort	Overloaded. Sets whether the specified column on this sheet allows automatic sorting.
	SetColumnAllowFilter	Overloaded. Sets whether the specified column on this sheet allows filtering.
	SetColumnAutoFilterIndex	Sets the auto filter index for the specified column.
	SetColumnAutoSortIndex	Sets the auto sort index for the specified column.
	SetColumnLabel	Sets the value for a specified cell in a column header on this sheet.
	SetColumnMerge	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.
	SetColumnPageBreak	Sets whether a forced page break is inserted before the specified column on this sheet when printing.
	SetColumnShowSortIndicator	Overloaded. Sets whether the specified column or columns should show a sort indicator when automatically sorted.
	SetColumnSizeable	Sets whether users can resize individual columns on this sheet.
	SetColumnSortIndicator	Sets the sort indicator for the specified column on this sheet.
	SetColumnVisible	Sets whether a column on this sheet is displayed.
	SetColumnWidth	Sets the width in pixels for the specified column on this sheet.
	SetConditionalFormat	Overloaded. Sets conditional formatting for a specified cell on the sheet based on a specified comparison.
	SetExpression	Sets the formula, as an expression, in the cell at the specified row and column of this sheet.
	SetFormula	Sets a formula in a specified cell on this sheet.
	SetFormulaConditionalFormat	Overloaded. Sets conditional formatting for a specified cell on the sheet based on a specified formula.
	SetInsideBorder	Sets borders to the inside of a range of cells.
	SetModelColumnForViewColumn	Sets the column index in the data model that corresponds to the specified column index in the sheet.
	SetModelRowForViewRow	Sets the row index in the data model that corresponds to the specified row index in the sheet.
	SetMultipleColumnWidths	Sets the width in pixels for the specified columns on this sheet.
	SetMultipleRowHeights	Sets the height in pixels for the specified rows on this sheet.
	SetNote	Sets a note in a specified cell on this sheet.
	SetNoteBounds	Sets the location and dimensions for a cell note when the style sets the note to always be shown.
	SetOutlineBorder	Sets borders to the outline of a range of cells.
	SetRowExpandable	Sets whether the row on this sheet can be expanded to show a child view in a hierarchical display.
	SetRowHeight	Sets the height in pixels for the specified row on this sheet.
	SetRowLabel	Sets the value for a specified cell in the row header on this sheet.
	SetRowMerge	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.
	SetRowPageBreak	Sets whether a forced page break is inserted before the specified row on this sheet when printing.
	SetRowSizeable	Sets whether users can resize individual rows on this sheet.
	SetRowVisible	Sets whether a row on this sheet is displayed.
	SetStickyNoteStyleInfo	Sets the style information for the cell notes on this sheet that stay visible.
	SetStyleInfo	Sets the style for a cell, a column, a row, or an entire sheet.
	SetTag	Sets the application-defined tag value for the specified cell, column, row, or entire sheet.
	SetText	Sets the formatted text in the cell on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell.
	SetValue	Overloaded. Sets the value for the specified cell on this sheet.
	ShouldSerializeColumnFooterSheetCornerHorizontalGridLine	Gets whether the horizontal grid line for the footer corner should be serialized.
	ShouldSerializeColumnFooterSheetCornerVerticalGridLine	Gets whether the vertical grid line for footer corner should be serialized.
	ShowNotes	Shows or hides all cell notes on the sheet.
	SortColumns	Overloaded. Sorts a range of columns in the sheet.
	SortRange	Sorts a range of cells on this sheet in the data model.
	SortRows	Overloaded. Sorts a range of rows in the sheet.
	SuspendAutoUpdateChartData	Suspend update of values to chart immediately.
	SwapRange	Swaps the data and formatting in a block of cells on this sheet with another block of cells on this sheet.
	UngroupSparkline	Overloaded. Ungroups the sparkline.
	UpdateNotes	Overloaded. Updates cell note appearances based on style being set or on changes to note text.

	Name	Description
	GetColumnVisibleCount	Gets the number of the visible columns.
	GetRowVisibleCount	Gets the number of the visible rows.
	OnAddColumnFooterRows	Occurs when footer rows are added
	OnDisposing	Raises the Disposing event
	OnNoteCreated	Occurs when a note of viewport area is created in the sheet's notes container.
	OnNoteMoved	Occurs when a note of viewport area is moved in the sheet's notes container.
	OnNoteSized	Occurs when a note of viewport area is sized in the sheet's notes container.
	OnRemoveColumnFooterRows	Occurs when column footer rows are removed.
	ShouldSerializeColumnFooterSheetCornerStyle	Gets whether the style for the sheet corner should be serialized.
	ShouldSerializeLockFont	Determines whether lock font should be serialized.
	ShouldSerializeNullBackColor	Determines whether null background color should be serialized.
	ShouldSerializeNullFont	Determines whether null font should be serialized.
	ShouldSerializeNullForeColor	Determines whether null text color should be serialized.
	ShouldSerializeSelectionFont	Determines whether selection font should be serialized.

	Name	Description
	CellChanged	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.
	Changed	Occurs when a change is made to the sheet that may require the entire sheet to be repainted (as with DefaultStyle or AlternatingRows).
	ColumnChanged	Occurs when a change is made to a column or range of columns that may require the column or range of columns be repainted.
	Disposing	Fires when the SheetView is being disposed.
	NoteCreated	Occurs when a note of viewport area is created on the sheet.
	NoteMoved	Occurs when a note of viewport area is moved on the sheet.
	NoteSized	Occurs when a note of viewport area is sized on the sheet.
	PropertyChanged	Occurs when the user changes a property of the sheet.
	RowChanged	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.
	StickyNoteCreated	Obsoleted. Use NoteCreated instead. Occurs when a sticky note is created on the sheet.
	StickyNoteMoved	Obsoleted. Use NoteMoved instead. Occurs when a sticky note is moved on the sheet.
	StickyNoteSized	Obsoleted. Use NoteSized instead. Occurs when a sticky note is sized on the sheet.

Public Constructors

Public Properties

Protected Properties

Public Methods

Protected Methods

Public Events

See Also

Reference

User-Task Documentation