Spread for ASP.NET 7.0 Product Documentation
SheetView Class Members
See Also Fields Properties Methods Support Options

	Name	Description
	childViews	Specifies a list of child views in a hierarchical display for this sheet.
	parentView	Specifies the parent view for this sheet.

	Name	Description
	ActiveChart	Gets or sets the active chart.
	ActiveColumn	Gets or sets the active column.
	ActiveRow	Gets or sets the active row.
	ActiveSkin	Gets or sets the current active skin.
	AllowColumnMove	Gets or sets whether to allow the user to move columns.
	AllowDelete	Gets or sets whether a user can delete a row in the sheet.
	AllowGroup	Gets or sets whether a user can group rows.
	AllowInsert	Gets or sets whether a user can insert a row in the sheet.
	AllowLoadOnDemand	Gets or sets whether to allow incremental loads to the client on demand when the user is scrolling.
	AllowPage	Gets or sets whether the sheet displays the number of pages and the arrows for navigating to other pages in the sheet.
	AllowSort	Gets or sets whether users can sort rows in the sheet.
	AllowTableCorner	Gets or sets whether to allow the sheet corner to be a structure table.
	AllowUserFormulas	Gets or sets whether to allow the user to enter formulas in a cell in the control.
	AllowVirtualScrollPaging	Gets or sets whether to allow virtual paging to load data when the user is scrolling.
	AlternatingRows	Gets the alternating rows in the specified portion of the sheet.
	AutoCalculation	Gets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change.
	AutoFilterMode	Gets or sets the AutoFilterMode which indicates which filtering UI will be used.
	AutoGenerateColumns	Gets or sets whether to generate the columns automatically based on the data source.
	AutoPostBack	Gets or sets whether a postback to the server automatically occurs when the user interacts with the sheet.
	BackColor	Gets or sets the background color of the sheet.
	Cells	Gets the cells in the data area of the sheet.
	CellSpacing	Gets or sets the cell spacing to use in the displayed HTML page.
	Charts	Gets the charts.
	ChildRelationCount	Gets the number of child views in a hierarchical display for this sheet.
	ClickHeaderCellToExpand	When this property is true and client script is enabled, the spread will expand the row in a hierarchical view when the row header cell is clicked; otherwise, the spread will expand the row only when the expand image is clicked.
	ColumnAxisModel	Gets or sets the column information for the sheet.
	ColumnCount	Gets or sets the number of columns in the sheet.
	ColumnFooter	Gets the column footers for the sheet.
	ColumnFooterDataModel	Gets or sets the data for the column footer.
	ColumnFooterHeight	Gets or sets the column footer height.
	ColumnFooterRowAxisModel	Gets or sets the row information for the column footer.
	ColumnFooterSpanModel	Gets or sets the spanned cells for the column footer.
	ColumnFooterStyleModel	Gets or sets the cell types and other style settings for cells in the column footer.
	ColumnFooterVisible	Gets or sets whether the column footers are visible.
	ColumnHeader	Gets the column headers for the sheet.
	ColumnHeaderAutoFilterIndex	Gets or sets which column header row displays the filtering indicator when there are multiple column header rows.
	ColumnHeaderAutoText	Gets or sets whether column headers display letters or numbers or is blank.
	ColumnHeaderAutoTextIndex	Gets or sets which column header row displays the automatic text when there are multiple column header rows.
	ColumnHeaderDataModel	Gets or sets the data for the column header.
	ColumnHeaderHeight	Gets or sets the column header height.
	ColumnHeaderRowAxisModel	Gets or sets the row information for the column header.
	ColumnHeaderSpanModel	Gets or sets the spanned cells for the column header.
	ColumnHeaderStyleModel	Gets or sets the cell types and other style settings for cells in the column header.
	ColumnHeaderVisible	Gets or sets whether the column headers are visible.
	Columns	Gets the columns in the data area of the sheet.
	ConditionalFormatting	Gets or sets the conditional formatting model.
	ContextMenuStyle	Gets or sets the context menu style.
	CurrentPageIndex	Gets or sets the current page.
	DataAutoCellTypes	Gets or sets whether a bound sheet automatically sets the cell type for the cells in a column.
	DataKeyField	Gets or sets the data key for this sheet.
	DataKeyNames	Gets or sets an array of strings that contains the names of the key fields for the data source for this sheet.
	DataMember	Gets or sets the data member for this sheet.
	DataModel	Gets or sets the data for the sheet.
	DataSource	Gets or sets the data source for this sheet.
	DataSourceID	Gets or sets the unique identifier of the data source for this sheet.
	DefaultColumnWidth	Gets or sets the default column width in pixels for all columns in the sheet.
	DefaultRowHeight	Gets or sets the default row height in pixels for all rows in the sheet.
	DefaultStyle	Gets or sets the default style information for the cells in this sheet.
	DefaultStyleName	Gets or sets the name of the default style for the cells in this sheet.
	DeleteMethod	Gets or sets the name of the method to call in order to delete data.
	EditRow	Gets or sets the row with the cell that is being edited.
	EditTemplateColumnCount	The number of columns in the editing form.
	EnableRowEditTemplate	Gets or sets whether to enable the row edit template.
	Expandable	Gets or sets whether the rows are expandable.
	FilterBar	Gets or sets FilterBarInfo for filterBar
	FpSpread	Gets the active FpSpread from the SheetView.
	FrozenColumnCount	Gets or sets the number of frozen (non-scrollable) columns for this sheet.
	FrozenRowCount	Gets or sets the number of frozen (non-scrollable) rows for this sheet.
	GrayAreaCursorImageUrl	Gets or sets which ImageUrl of the cursor is displayed when the mouse is on the gray area of the sheet.
	GrayAreaCursorType	Gets or sets which type of cursor is displayed when the mouse is on the gray area of the sheet.
	GridLineColor	Gets or sets the color of the grid lines in the sheet.
	GridLines	Gets or sets whether to display grid lines in the sheet.
	GroupBarBackColor	Gets or sets the grouping bar background color.
	GroupBarHeight	Gets or sets the grouping bar height.
	GroupBarText	Gets or sets the group bar text.
	GroupBarVisible	Gets or sets whether the grouping bar is visible.
	GroupFooterInfos	Gets or sets the collection of group footer information objects.
	GroupFooterVisible	Gets or sets whether the footer of the grouping bar is visible.
	GroupInfos	Gets or sets the collection of group information objects.
	GroupingPolicy	Gets or sets grouping policy to collapse or expand rows when grouping occurs.
	GroupMaximumLevel	Gets or sets the maximum grouping level.
	HeaderGrayAreaBackgroundImageUrl	Gets or sets the background image of the header area that does not contain column header or row header cells.
	HeaderGrayAreaColor	Gets or sets the color of the header area that does not contain column header or row header cells.
	IgnoreHiddenRowsWhenPaging	Gets or sets if the hidden rows are ignored when paging.
	InsertMethod	Gets or sets the name of the method to call in order to insert data.
	IsTrackingViewState	Gets or sets whether the control tracks the current sheet view state.
	ItemType	Gets or sets the name of the data item type in model binding.
	Iteration	Gets or sets whether circular references in the sheet are evaluated.
	LayoutMode	Gets or sets the type of layout mode.
	LoadInitRowCount	Gets or sets the number of rows to load initially to the client.
	LoadOffsetFromBottom	Gets or sets the row index (from bottom to top) in the view from where spread loads the next set of rows after scrolling to this position.
	LoadOnDemandInterval	Gets or sets a period of time (in milliseconds) when spread loads the next set of rows.
	LoadOnDemandMode	Gets or sets the LoadOnDemandMode property. In Standard mode, spread loads the next set of rows, if after scrolling, there are no bottom rows (in the view) that are hidden. In Background mode, spread loads the next set of rows after a period of time or after the user scrolls to the row at the LoadOffsetFromBottom position.
	LoadOnDemandTriggerMode	Gets or sets the LoadOnDemandTriggerMode property. If trigger mode is Timed, spread loads the next set of rows after a period of time until there are no rows to load. If trigger mode is OffsetBased, spread only loads the next set of rows if the user scrolls to the row at the LoadOffsetFromBottom position.
	LoadRowIncrement	Gets or sets the number of rows to include in incremental loads on demand.
	LockBackColor	Gets or sets the background color of locked cells 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 for the sheet.
	MaximumIterations	Gets or sets the formula recalculation iteration count for the sheet.
	MessageRowStyle	Gets or sets the style for the message row.
	NamedStyles	Gets or sets a collection of styles.
	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.
	OperationMode	Gets or sets the operation mode of the sheet.
	PageMaxAlign	Gets or sets whether to show the maximum number of rows on the last page.
	PageSize	Gets or sets the number of rows to display at a time.
	Parent	Gets the reference to the parent sheet (SheetView object).
	ParentRowIndex	Gets the index of the parent row in a hierarchical display.
	PreviewRowColumnIndex	Gets or sets the index of the preview row column.
	PreviewRowStyle	Gets or sets the style information for the preview row.
	PreviewRowTemplate	Gets or sets the preview row template.
	PreviewRowVisible	Gets or sets whether to display the preview row.
	PrintInfo	Gets or sets a PrintInfo object that determines printing behavior for the sheet.
	Protect	Gets or sets whether users can edit cells marked as locked.
	ReferenceStyle	Gets or sets the cell reference style.
	RelationName	Gets the name of the data relation in a hierarchical display.
	RenderEditors	Gets or sets whether the FarPoint Spread always displays the editor if the editor is defined for a cell.
	RowAxisModel	Gets or sets the row information for the sheet.
	RowCount	Gets or sets the number of rows in the sheet.
	RowEditTemplate	Gets or sets the row edit template.
	RowFilter	Gets or sets the row filter for the sheet.
	RowHeader	Gets the row headers for the sheet.
	RowHeaderAutoText	Gets or sets whether row headers display letters or numbers or is blank.
	RowHeaderAutoTextIndex	Gets or sets which row header column displays the automatic text when there are multiple row header columns.
	RowHeaderColumnAxisModel	Gets or sets the column information for the row header.
	RowHeaderDataModel	Gets or sets the data for the row header.
	RowHeaderSpanModel	Gets or sets the spanned cells for the row header.
	RowHeaderStyleModel	Gets or sets the cell types and other style settings for cells in the row header.
	RowHeaderVisible	Gets or sets whether the row headers are visible.
	RowHeaderWidth	Gets or sets the row header column width.
	Rows	Gets the rows in the data area of the sheet.
	ScrollingContentColumns	Gets or sets the scrolling content tip columns.
	ScrollingContentHiddenDelay	Gets or sets the hidden delay of the scrolling content tip in milliseconds.
	ScrollingContentMaxHeight	Gets or sets the maximum height in pixels for the scrolling content tip.
	ScrollingContentVisible	Gets or sets a value that indicates whether to display the scrolling content tip.
	SelectionBackColor	Gets or sets the background color for selected cells.
	SelectionBackColorStyle	Gets or sets the backcolor style for the display of selected cells.
	SelectionBorder	Gets or sets the settings for the selection border.
	SelectionForeColor	Gets or sets the text color for selected cells.
	SelectionModel	Gets or sets the selections for the sheet.
	SelectionPolicy	Gets or sets the selection policy.
	SelectMethod	Gets or sets the name of the method to call in order to read data.
	SheetCorner	Gets the sheet corner for the sheet.
	SheetCornerColumnAxisModel	Gets or sets the column information for the sheet corner.
	SheetCornerDataModel	Gets or sets the data for the sheet corner.
	SheetCornerRowAxisModel	Gets or sets the row information for the sheet corner.
	SheetCornerSpanModel	Gets or sets the spanned cells for the sheet corner.
	SheetCornerStyle	Gets or sets the style information for the sheet corner.
	SheetCornerStyleModel	Gets or sets the cell types and other style settings for cells in the sheet corner.
	SheetCornerStyleName	Gets or sets the name of the style for the sheet corner.
	SheetName	Gets or sets the name of the sheet.
	ShowFrozenIndicator	Gets or sets whether the frozen indicator should be displayed.
	SortedColumn	Gets the model index of the column last sorted.
	SpanModel	Gets or sets the spanned cells for the sheet.
	SparklineContainer	Gets or sets the sparkline container.
	StartingColumnNumber	Gets or sets the number displayed in the first column header.
	StartingRowNumber	Gets or sets the number displayed in the first row header.
	StartPage	Gets or sets the number of the first page to display in the page navigation aids.
	StyleModel	Gets or sets the cell types and other style settings for the sheet.
	TitleInfo	Gets the title information of the sheet.
	TopRow	Gets or sets the row to display as the top row in the sheet.
	UpdateMethod	Gets or sets the name of the method to call in order to update data.
	VirtualScrollPagingFormatString	Gets or sets the custom format string to show in the text tip during virtual scroll paging. Default pattern is "Page {page} of {count}", where {page} will be replaced for page index and {count} will be replaced for page count.
	VirtualScrollPagingPrevRowCount	Indicates the number of additional rows that are displayed from previous pages before the top of the current page. The default value is zero. This setting only has an effect when AllowVirtualScrollPaging is true.
	Visible	Gets or sets whether to display the sheet.
	WorksheetTemplate	Gets the worksheet template.

	Name	Description
	AddChart	Overloaded. Adds the chart control.
	AddColumns	Adds columns to the data model at the specified index.
	AddRows	Adds rows to the data model.
	AddRowToDataSource	Adds the unbound row to the data source.
	AddSpanCell	Adds a span of cells to a sheet.
	AddSparkline	Overloaded. Adds the sparkline.
	AddSquareSparkline	Adds the sparkline.
	AddUnboundRows	Adds unbound rows to the data model.
	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.
	ClearConditionalFormating	Overloaded. Removes all of the conditional formatting from the cell at the specified row and column.
	ClearConditionalFormatings	Removes all of the conditional formatting from the sheet.
	ClearRange	Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.
	ClearRowFilter	Clears the row filter for this sheet.
	ClearSparklineGroupsInRange	Clears all sparkline groups.
	ClearSparklines	Clears all sparklines.
	ExpandAll	Expands or collapses all the levels of hierarchy
	ExpandRow	Expands or collapses the specified row in the hierarchical display.
	FindChildView	Gets the child view in a hierarchical display with the specified row and data relation index.
	GetCellFromTag	Gets a cell with a specific tag on the sheet.
	GetCellType	Gets the cell type for a cell at the specified row and column.
	GetChildRelation	Gets the name of the child data relation in a hierarchical display at the specified index.
	GetChildView	Gets a child sheet in a hierarchical display for the specified row and the specified relation index.
	GetChildVisible	Gets whether the child view is displayed in a hierarchical display.
	GetClip	Overloaded. Gets a tab-delimited string that contains the formatted text in a specified range.
	GetClipValue	Gets a tab-delimited string that contains the unformatted text in a specified range.
	GetColumnAllowFilter	Gets whether this column contains a column filter definition.
	GetColumnAutoText	Gets the automatic text displayed in the specified column header.
	GetColumnFromTag	Gets a column on this sheet with a specific tag.
	GetColumnLabel	Gets the text in the column header cell at the specified row and column.
	GetColumnMerge	Gets whether or how cells in a column on this sheet that have the same content are joined in a single cell across multiple rows.
	GetColumnSizeable	Gets whether the user can resize a specified column.
	GetColumnSortIndicator	Gets the sort indicator to display at the specified column.
	GetColumnVisible	Gets whether a column is displayed.
	GetColumnWidth	Gets the width of the specified column in pixels.
	GetConditionalFormatting	Overloaded. Gets all the conditional formatting in the specified cell range.
	GetCustomName	Overloaded. Gets the string value for a custom name on this sheet from the model.
	GetDataKey	Gets the identifier for the specified row if it is visible.
	GetDefaultEditor	Gets the default editor used to edit the cell.
	GetDefaultRenderer	Gets the default renderer used to render the cell.
	GetDropDownFilterItems	Gets the filter items to be displayed in the drop-down list for the specified column.
	GetEditor	Gets the editor used to edit a cell at the specified row and column.
	GetExpression	Gets the formula of the specified cell on this sheet.
	GetFormatter	Gets the formatter used to format a cell at the specified row and column.
	GetFormula	Gets the formula in the cell at the specified row and column.
	GetGroupFooterInfo	Gets the group footer information for the sheet.
	GetGroupInfo	Gets the group information for the sheet.
	GetModelColumnFromViewColumn	Gets the index in the model for the specified column.
	GetModelRowFromViewRow	Gets a row index in a model for a specified row in a sheet.
	GetNote	Gets the cell note for a cell at the specified row and column.
	GetRenderer	Gets the renderer used to render a cell at the specified row and column.
	GetRowAutoText	Gets the automatic text displayed in the specified row header.
	GetRowExpandable	Gets whether the row on this sheet is expandable in the hierarchical display.
	GetRowFromTag	Gets a row on this sheet with a specific tag.
	GetRowHeight	Gets the height of the specified row.
	GetRowLabel	Gets the text in the specified row header cell.
	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.
	GetRowSizeable	Gets whether the user can resize the specified row.
	GetRowVisible	Gets whether a row is displayed.
	GetSelections	Gets an ordered array of FarPoint.Web.Spread.Model.CellRange objects, from largest to smallest, containing the selected cells on the sheet with minimal overlap between the ranges.
	GetSpanCell	Gets the span of cells at a specified cell.
	GetSparkline	Gets the sparkline information.
	GetStyleInfo	Gets the composite cell style information for a cell at the specified row and column.
	GetTag	Gets the application-defined tag value for the specified cell, column, row, or entire sheet.
	GetText	Gets the formatted text in the cell using the IFormatter object for the cell.
	GetUnboundValue	Gets the unbound value for a cell at the specified row and column.
	GetValidConditionalFormat	Gets the valid conditional format.
	GetValue	Gets unformatted data from a cell at the specified row and column.
	GetViewColumnFromModelColumn	Gets the sheet column index for a specified model column.
	GetViewRowFromModelRow	Gets a sheet row index for the specified model row.
	GroupSparkline	Overloaded. Groups the sparkline and sets the type of the new group.
	IsColumnBound	Gets whether the column is bound to a data source column.
	IsRowBound	Gets whether the specified row is bound to a data source.
	IsRowExpanded	Gets whether the row is expanded in the hierarchical display.
	LoadFormulas	Loads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.
	LoadTextFile	Overloaded. Loads a text file with data (and perhaps headers and footer) into the sheet with the specified delimiters.
	LoadViewState	Loads a saved view state for a sheet.
	MoveColumn	Moves the column or columns to a specified location.
	Open	Overloaded. Opens a sheet saved as XML from the specified file and loads it into the sheet.
	OpenExcel	Overloaded. Opens an Excel file and loads the specified Excel sheet into this sheet.
	Recalculate	Evaluates all the formulas in the sheet that have changed since the last calculation cycle.
	RecalculateAll	Evaluates all the formulas in the sheet (including those that have not changed since the last calculation cycle).
	RemoveColumns	Removes the columns at the specified index.
	RemoveRows	Removes the rows at the specified index.
	RemoveSpanCell	Removes the span from a range of cells that contain a specified anchor cell.
	Reset	Sets the sheet to its default values.
	ResetViewColumnIndexes	Resets all column indexes in the sheet to be the same as the column indexes in the corresponding data model.
	ResetViewRowIndexes	Resets all row indexes in the sheet to be the same as the row indexes in the corresponding data model.
	Save	Overloaded. Saves the contents of the sheet to XML in the specified file.
	SaveHtml	Overloaded. Saves the sheet as HTML content to the stream
	SaveTextFile	Overloaded. Saves the sheet to a text file with the specified name.
	SaveTextFileRange	Overloaded. Saves the range of cells (and may include headers) to a text file as specified.
	SaveViewState	Saves the current view state of the sheet.
	SetChildVisible	Sets whether to display the child view in a hierarchical display.
	SetClip	Sets a tab-delimited string that contains the formatted text in a specified range.
	SetClipValue	Sets a tab-delimited string that contains the unformatted text in a specified range.
	SetColumnLabel	Sets the value for a specified cell in a column header.
	SetColumnMerge	Sets whether or how cells in a column on this sheet that have the same content are joined in a single cell across multiple rows.
	SetColumnSizeable	Sets whether users can resize individual columns.
	SetColumnSortIndicator	Sets the sort indicator to display at the specified column.
	SetColumnVisible	Sets whether a column is displayed.
	SetColumnWidth	Sets the width of the specified column in pixels.
	SetConditionalFormatting	Overloaded. Sets conditional formatting for a specified cell on the sheet based on specified rules.
	SetExpression	Sets a formula in a specified cell on this sheet.
	SetFormula	Sets the formula for a specified cell.
	SetModelDataColumn	Binds the model column to the data source column.
	SetNote	Sets the cell note for a specified cell.
	SetRowExpandable	Sets whether the row on this sheet can be expanded to show the child view in the hierarchical display.
	SetRowHeight	Sets the height of the specified row in pixels.
	SetRowLabel	Sets the value for a specified cell in the row header.
	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.
	SetRowSizeable	Sets whether users can resize individual rows.
	SetRowVisible	Sets whether a row is displayed.
	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 using the IFormatter object for the cell.
	SetValue	Sets the value for a cell at the specified row and column.
	Sort	Sorts a range of cells in the data model.
	SortColumns	Overloaded. Sorts all the columns in the sheet according to the specified parameters.
	SortRows	Overloaded. Sorts all the rows in the sheet according to the specified parameters.
	ToString	Returns the name of the sheet.
	UngroupSparkline	Overloaded. Ungroups the sparkline.

	Name	Description
	CreateColumnAxisModel	Creates the column axis model.
	CreateDataModel	Creates the data model.
	CreateRowAxisModel	Creates the row axis model.
	CreateSelectionModel	Creates the selection model.
	CreateSpanModel	Creates the span model.
	CreateStyleModel	Creates the style model.
	FlushData	Calls GetPagingSupport of the DataModel, selects data to data source view.
	GetChildViewName	Gets a name for the child view in a hierarchical display based on the row index and the relation index.
	OnAddColumnFooterRows	Processes the addition of the specified rows to the column footer in the data model.
	OnAddColumnHeaderRows	Processes the addition of the specified rows to the column header in the data model.
	OnAddColumns	Processes the addition of columns to the data model and updates the other models and internal variables of the fpSpread component.
	OnAddRowHeaderColumns	Processes the addition of columns to the row header of the sheet.
	OnAddRows	Processes the addition of rows to the data model.
	OnDataModelChanged	Processes the change to the sheet data model and synchronizes the models.
	OnRemoveColumnFooterRows	Processes the removal of rows from the column header.
	OnRemoveColumnHeaderRows	Processes the removal of rows from the column header.
	OnRemoveColumns	Processes the removal of the specified columns from the data model.
	OnRemoveRowHeaderColumns	Processes the removal of columns from the row header.
	OnRemoveRows	Processes the removal of the specified rows from the data model.
	ShouldSerializePrintInfo	Determines whether the print information should be serialized.

Public Constructors

Protected Fields

Public Properties

Public Methods

Protected Methods

See Also

Reference

User-Task Documentation