SheetView Class

Represents a sheet in the FarPoint Spread component.

Inheritance

object

SheetView

Implements

ISerializePresentation

IWebSparklineSheetView

IFindRowsVisibleStateSupport

Namespace: FarPoint.Web.Spread

Assembly: FarPoint.Web.Spread.dll

Syntax

public class SheetView : ISerializeSupport, ISerializeSettings, ISerializeStyles, ISerializeData, ISerializePresentation, IWebSparklineSheetView, IFindRowsVisibleStateSupport

Public Class SheetView
    Implements ISerializeSupport, ISerializeSettings, ISerializeStyles, ISerializeData, ISerializePresentation, IWebSparklineSheetView, IFindRowsVisibleStateSupport

Constructors

Name	Description
SheetView()	Creates a sheet (SheetView object).
SheetView(NamedStyleCollection)	Creates a sheet (SheetView object) with the specified style collection.

Fields

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

Properties

Name	Description
ActiveChart	Gets or sets the active chart.
ActiveColumn	Gets or sets the active column.
ActiveImage	Gets or sets the active image.
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.
AllowRowMove	Gets or sets whether to allow the user to move rows.
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 is 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.
CellSpacing	Gets or sets the cell spacing to use in the displayed HTML page.
Cells	Gets the cells in the data area of the sheet.
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 are 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.
DesignString	Gets or sets an XML string that contains the serialization of the data and presentation (column widths, row heights, spans, styles, etc.) for the sheet.
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.
GroupMaximumLevel	Gets or sets the maximum grouping level.
GroupingPolicy	Gets or sets grouping policy to collapse or expand rows when grouping occurs.
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.
Images	Get the image collection
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 that contains data.
NonEmptyRowCount	Gets a value that is one more than the index of the last row on this sheet that contains 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 are 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.
SelectMethod	Gets or sets the name of the method to call in order to read data.
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.
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.
StartPage	Gets or sets the number of the first page to display in the page navigation aids.
StartingColumnNumber	Gets or sets the number displayed in the first column header.
StartingRowNumber	Gets or sets the number displayed in the first row header.
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.

Methods

Name	Description
AddChart(CellRange, Type, int, int, int, int)	Adds the chart control.
AddChart(CellRange, Type, int, int, int, int, ChartViewType, bool)	Adds the chart control.
AddChart(CellRange[], Type, int, int, int, int)	Adds a chart to the SheetView. The chart is aligned in the center of the SheetView.
AddChart(CellRange[], Type, int, int, int, int, ChartViewType, bool)	Adds a chart to the SheetView. The chart is aligned in the center of the SheetView.
AddChart(int, int, Type, int, int, int, int)	Adds the chart control.
AddChart(int, int, Type, int, int, int, int, ChartViewType, bool)	Adds the chart control.
AddColumns(int, int)	Adds columns to the data model at the specified index.
AddImage(int, int, int, int, Image)
AddImage(int, int, int, int, string)
AddRowToDataSource(int, bool)	Adds the unbound row to the data source.
AddRows(int, int)	Adds rows to the data model.
AddSpanCell(int, int, int, int)	Adds a span of cells to a sheet.
AddSparkline(SheetCellRange, CellRange, SparklineType, ExcelSparklineSetting)	Adds the sparkline.
AddSparkline(SheetCellRange[], CellRange[], SparklineType, ExcelSparklineSetting)	Adds the sparkline.
AddSparkline(string, string, SparklineType, ExcelSparklineSetting)	Adds the sparkline.
AddSquareSparkline(SheetCellRange, CellRange, SparklineType, ExcelSparklineSetting, bool)	Adds the sparkline.
AddUnboundRows(int, int)	Adds unbound rows to the data model.
AutoFilterColumn(int, string)	Automatically filters the rows in the specified column according to the specified filter.
AutoFilterReset(int)	Resets the filters on the rows in the specified column.
ClearConditionalFormating(int, int)	Removes all of the conditional formatting from the cell at the specified row and column.
ClearConditionalFormating(int, int, int, int)	Removes all of the conditional formatting from the specified cell range.
ClearConditionalFormatings()	Removes all of the conditional formatting from the sheet.
ClearRange(int, int, int, int, bool)	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(CellRange)	Clears all sparkline groups.
ClearSparklines(CellRange)	Clears all sparklines.
CreateColumnAxisModel(int)	Creates the column axis model.
CreateDataModel(int, int)	Creates the data model.
CreateRowAxisModel(int)	Creates the row axis model.
CreateSelectionModel(int, int)	Creates the selection model.
CreateSpanModel(int, int)	Creates the span model.
CreateStyleModel(int, int)	Creates the style model.
ExpandAll(bool)	Expands or collapses all the levels of hierarchy
ExpandRow(int, bool)	Expands or collapses the specified row in the hierarchical display.
FindChildView(int, int)	Gets the child view in a hierarchical display with the specified row and data relation index.
FirePropertyChanged(string)	Fire a property changed event when a property value changes.
FlushData()	Calls GetPagingSupport of the DataModel, selects data to data source view.
GetCellFromTag(Cell, object)	Gets a cell with a specific tag on the sheet.
GetCellType(int, int)	Gets the cell type for a cell at the specified row and column.
GetChildRelation(int)	Gets the name of the child data relation in a hierarchical display at the specified index.
GetChildView(int, int)	Gets a child sheet in a hierarchical display for the specified row and the specified relation index.
GetChildViewName(int, int)	Gets a name for the child view in a hierarchical display based on the row index and the relation index.
GetChildVisible(SheetView)	Gets whether the child view is displayed in a hierarchical display.
GetClip(int, int, int, int)	Gets a tab-delimited string that contains the formatted text in a specified range.
GetClip(int, int, int, int, bool)	Gets a tab-delimited string that contains the formatted text in a specified range.
GetClipValue(int, int, int, int)	Gets a tab-delimited string that contains the unformatted text in a specified range.
GetColumnAllowFilter(int)	Gets whether this column contains a column filter definition.
GetColumnAutoText(int)	Gets the automatic text displayed in the specified column header.
GetColumnFromTag(Column, object)	Gets a column on this sheet with a specific tag.
GetColumnLabel(int, int)	Gets the text in the column header cell at the specified row and column.
GetColumnMerge(int)	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(int)	Gets whether the user can resize a specified column.
GetColumnSortIndicator(int)	Gets the sort indicator to display at the specified column.
GetColumnVisible(int)	Gets whether a column is displayed.
GetColumnWidth(int)	Gets the width of the specified column in pixels.
GetConditionalFormatting(int, int)	Gets all the conditional formatting in the specified cell.
GetConditionalFormatting(int, int, int, int)	Gets all the conditional formatting in the specified cell range.
GetCustomName(string)	Gets the expression value for a custom name on this sheet from the model.
GetCustomName(string, int, int)	Gets the string value for a custom name on this sheet from the model.
GetDataKey(int)	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(int)	Gets the filter items to be displayed in the drop-down list for the specified column.
GetEditor(int, int)	Gets the editor used to edit a cell at the specified row and column.
GetExpression(int, int)	Gets the formula of the specified cell on this sheet.
GetFormatter(int, int)	Gets the formatter used to format a cell at the specified row and column.
GetFormula(int, int)	Gets the formula in the cell at the specified row and column.
GetGroupFooterInfo(GroupFooter)	Gets the group footer information for the sheet.
GetGroupInfo(Group)	Gets the group information for the sheet.
GetModelColumnFromViewColumn(int)	Gets the index in the model for the specified column.
GetModelRowFromViewRow(int)	Gets a row index in a model for a specified row in a sheet.
GetNote(int, int)	Gets the cell note for a cell at the specified row and column.
GetRenderer(int, int)	Gets the renderer used to render a cell at the specified row and column.
GetRowAutoText(int)	Gets the automatic text displayed in the specified row header.
GetRowExpandable(int)	Gets whether the row on this sheet is expandable in the hierarchical display.
GetRowFromTag(Row, object)	Gets a row on this sheet with a specific tag.
GetRowHeight(int)	Gets the height of the specified row.
GetRowLabel(int, int)	Gets the text in the specified row header cell.
GetRowMerge(int)	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(int)	Gets whether the user can resize the specified row.
GetRowVisible(int)	Gets whether a row is displayed.
GetSelections()	Gets an ordered array of CellRange objects, from largest to smallest, containing the selected cells on the sheet with minimal overlap between the ranges.
GetSpanCell(int, int)	Gets the span of cells at a specified cell.
GetSparkline(int, int)	Gets the sparkline information.
GetStyleInfo(int, int)	Gets the composite cell style information for a cell at the specified row and column.
GetTag(int, int)	Gets the application-defined tag value for the specified cell, column, row, or entire sheet.
GetText(int, int)	Gets the formatted text in the cell using the IFormatter object for the cell.
GetUnboundValue(int, int)	Gets the unbound value for a cell at the specified row and column.
GetValidConditionalFormat(int, int, out IPrePaintConditionalFormattingRule[], out IPrePaintTextConditionalFormattingRule[])	Gets the valid conditional format.
GetValue(int, int)	Gets unformatted data from a cell at the specified row and column.
GetViewColumnFromModelColumn(int)	Gets the sheet column index for a specified model column.
GetViewRowFromModelRow(int)	Gets a sheet row index for the specified model row.
GroupSparkline(CellRange[])	Groups the sparkline to the active sparkline.
GroupSparkline(CellRange[], SparklineType)	Groups the sparkline and sets the type of the new group.
InitPropArray()	Initializes the array of properties for the sheet.
InitStyle()	Initializes the style settings for the sheet.
InvalidateRowFilter(bool)	Resets all the temporary filter settings and filters the rows again based on the filter settings of each column. (Internal use only.)
IsColumnBound(int)	Gets whether the column is bound to a data source column.
IsRowBound(int)	Gets whether the specified row is bound to a data source.
IsRowExpanded(int)	Gets whether the row is expanded in the hierarchical display.
LoadFormulas(bool)	Loads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.
LoadTextFile(Stream, bool)	Loads a stream that contains delimited data into the sheet.
LoadTextFile(Stream, bool, IncludeHeaders, bool, string, string, string)	Loads a stream that contains delimited data (and perhaps headers and footer) into the sheet with the specified delimiters.
LoadTextFile(Stream, bool, IncludeHeaders, bool, string, string, string, Encoding)	Loads a stream that contains delimited data (and perhaps headers and footer) into the sheet with the specified delimiters.
LoadTextFile(Stream, bool, IncludeHeaders, bool, string, string, string, Encoding, bool)	Loads a stream that contains delimited data (and perhaps headers and footer) into the sheet with the specified delimiters.
LoadTextFile(Stream, bool, IncludeHeaders, string, string, string)	Loads a stream that contains delimited data (and perhaps headers) into the sheet with the specified delimiters.
LoadTextFile(Stream, bool, IncludeHeaders, string, string, string, Encoding)	Loads a stream that contains delimited data (and perhaps headers) into the sheet with the specified delimiters.
LoadTextFile(Stream, bool, IncludeHeaders, string, string, string, Encoding, bool)	Loads a stream that contains delimited data (and perhaps headers) into the sheet with the specified delimiters.
LoadTextFile(string, bool)	Loads a text file with the specified name into the sheet.
LoadTextFile(string, bool, IncludeHeaders, bool, string, string, string)	Loads a text file with data (and perhaps headers and footer) into the sheet with the specified delimiters.
LoadTextFile(string, bool, IncludeHeaders, bool, string, string, string, Encoding)	Loads a text file with data (and perhaps headers and footer) into the sheet with the specified delimiters.
LoadTextFile(string, bool, IncludeHeaders, bool, string, string, string, Encoding, bool)	Loads a text file with data (and perhaps headers and footer) into the sheet with the specified delimiters.
LoadTextFile(string, bool, IncludeHeaders, string, string, string)	Loads a text file with data (and perhaps headers) into the sheet with the specified delimiters.
LoadTextFile(string, bool, IncludeHeaders, string, string, string, Encoding)	Loads a text file with data (and perhaps headers) into the sheet with the specified delimiters.
LoadTextFile(string, bool, IncludeHeaders, string, string, string, Encoding, bool)	Loads a text file with data (and perhaps headers) into the sheet with the specified delimiters.
LoadViewState(object)	Loads a saved view state for a sheet.
MoveColumn(int, int, int)	Moves the column or columns to a specified location.
MoveRow(int, int, int)	Moves the row or rows to a specified location.
OnAddColumnFooterRows(int, int)	Processes the addition of the specified rows to the column footer in the data model.
OnAddColumnHeaderRows(int, int)	Processes the addition of the specified rows to the column header in the data model.
OnAddColumns(int, int)	Processes the addition of columns to the data model and updates the other models and internal variables of the fpSpread component.
OnAddRowHeaderColumns(int, int)	Processes the addition of columns to the row header of the sheet.
OnAddRows(int, int)	Processes the addition of rows to the data model.
OnDataModelChanged(object, SheetDataModelEventArgs)	Processes the change to the sheet data model and synchronizes the models.
OnRemoveColumnFooterRows(int, int)	Processes the removal of rows from the column header.
OnRemoveColumnHeaderRows(int, int)	Processes the removal of rows from the column header.
OnRemoveColumns(int, int)	Processes the removal of the specified columns from the data model.
OnRemoveRowHeaderColumns(int, int)	Processes the removal of columns from the row header.
OnRemoveRows(int, int)	Processes the removal of the specified rows from the data model.
Open(Stream)	Opens a sheet saved as XML from the specified stream and loads it into the sheet.
Open(string)	Opens a sheet saved as XML from the specified file and loads it into the sheet.
OpenExcel(Stream, int)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(Stream, int, ExcelOpenFlags)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(Stream, int, ExcelOpenFlags, string)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(Stream, string)	Opens an Excel file and load the specified Excel sheet into this sheet.
OpenExcel(Stream, string, ExcelOpenFlags)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(Stream, string, ExcelOpenFlags, string)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(string, int)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(string, int, ExcelOpenFlags)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(string, int, ExcelOpenFlags, string)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(string, string)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(string, string, ExcelOpenFlags)	Opens an Excel file and loads the specified Excel sheet into this sheet.
OpenExcel(string, string, ExcelOpenFlags, string)	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(int, int)	Removes the columns at the specified index.
RemoveRows(int, int)	Removes the rows at the specified index.
RemoveSpanCell(int, int)	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(Stream, bool)	Saves the contents of the sheet to XML in the specified stream.
Save(string, bool)	Saves the contents of the sheet to XML in the specified file.
SaveHtml()	Saves the sheet to the HTML content.
SaveHtml(Stream)	Saves the sheet as HTML content to the stream
SaveHtml(Stream, Encoding)	Saves the sheet as HTML content to the stream
SaveHtml(string)	Saves the sheet to the HTML file.
SaveHtml(string, Encoding)	Saves the sheet to the HTML file.
SaveTextFile(Stream, bool)	Saves the sheet as delimited text to a stream as specified.
SaveTextFile(Stream, bool, IncludeHeaders, bool, string, string, string)	Saves the range of cells (and may include headers and footer) as delimited text to a stream as specified.
SaveTextFile(Stream, bool, IncludeHeaders, string, string, string)	Saves the range of cells (and may include headers) as delimited text to a stream as specified.
SaveTextFile(string, bool)	Saves the sheet to a text file with the specified name.
SaveTextFile(string, bool, IncludeHeaders, bool, string, string, string)	Saves the sheet (and optionally headers and footer) to a text file with the specified name and delimiters.
SaveTextFile(string, bool, IncludeHeaders, string, string, string)	Saves the sheet (and optionally headers) to a text file with the specified name and delimiters.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, bool, string, string, string)	Saves the range in the sheet (and may include headers and footer) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, bool, string, string, string, bool)	Saves the range in the sheet (and may include headers and footer) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, bool, string, string, string, bool, Encoding)	Saves the range in the sheet (and may include headers and footer) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, bool, string, string, string, bool, Encoding, bool)	Saves the range in the sheet (and may include headers and footer) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, bool, string, string, string, Encoding)	Saves the range in the sheet (and may include headers and footer) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, string, string, string)	Saves the range in the sheet (and may include headers) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, string, string, string, bool)	Saves the range in the sheet (and may include headers) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, string, string, string, bool, Encoding)	Saves the range in the sheet (and may include headers) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, string, string, string, bool, Encoding, bool)	Saves the range in the sheet (and may include headers) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, Stream, bool, IncludeHeaders, string, string, string, Encoding)	Saves the range in the sheet (and may include headers) as delimited text to a stream as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, bool, string, string, string)	Saves the range of cells (and may include headers and footer) to a text file as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, bool, string, string, string, bool)	Saves the range of cells (and may include headers and footer) to a text file as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, bool, string, string, string, bool, Encoding)	Saves the range of cells (and may include headers and footer) to a text file as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, bool, string, string, string, bool, Encoding, bool)	Saves the range of cells (and may include headers and footer) to a text file as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, bool, string, string, string, Encoding)	Saves the range of cells (and may include headers and footer) to a text file as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, string, string, string)	Saves the range of cells (and may include headers) to a text file as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, string, string, string, bool)	Saves the range of cells (and may include headers) to a text file as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, string, string, string, bool, Encoding)	Saves the range of cells (and may include headers) to a text file as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, string, string, string, bool, Encoding, bool)	Saves the range of cells (and may include headers) to a text file as specified.
SaveTextFileRange(int, int, int, int, string, bool, IncludeHeaders, string, string, string, Encoding)	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(SheetView, bool)	Sets whether to display the child view in a hierarchical display.
SetClip(int, int, int, int, string)	Sets a tab-delimited string that contains the formatted text in a specified range.
SetClipValue(int, int, int, int, string)	Sets a tab-delimited string that contains the unformatted text in a specified range.
SetColumnLabel(int, int, string)	Sets the value for a specified cell in a column header.
SetColumnMerge(int, MergePolicy)	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(int, bool)	Sets whether users can resize individual columns.
SetColumnSortIndicator(int, SortIndicator)	Sets the sort indicator to display at the specified column.
SetColumnVisible(int, bool)	Sets whether a column is displayed.
SetColumnWidth(int, int)	Sets the width of the specified column in pixels.
SetConditionalFormatting(params ConditionalFormatting[])	Sets conditional formatting for the sheet.
SetConditionalFormatting(CellRange[], params IConditionalFormattingRule[])	Sets conditional formatting for specified ranges of cells on the sheet based on specified rules.
SetConditionalFormatting(CellRange[], bool, params IConditionalFormattingRule[])	Sets conditional formatting for specified ranges of cells on the sheet based on specified rules.
SetConditionalFormatting(int, int, params IConditionalFormattingRule[])	Sets conditional formatting for a specified cell on the sheet based on specified rules.
SetConditionalFormatting(int, int, bool, params IConditionalFormattingRule[])	Sets conditional formatting for a specified cell on the sheet based on specified rules.
SetConditionalFormatting(int, int, int, int, params IConditionalFormattingRule[])	Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
SetConditionalFormatting(int, int, int, int, bool, params IConditionalFormattingRule[])	Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
SetExpression(int, int, Expression)	Sets a formula in a specified cell on this sheet.
SetFormula(int, int, string)	Sets the formula for a specified cell.
SetModelDataColumn(int, string)	Binds the model column to the data source column.
SetNote(int, int, string)	Sets the cell note for a specified cell.
SetRowExpandable(int, bool)	Sets whether the row on this sheet can be expanded to show the child view in the hierarchical display.
SetRowHeight(int, int)	Sets the height of the specified row in pixels.
SetRowLabel(int, int, string)	Sets the value for a specified cell in the row header.
SetRowMerge(int, MergePolicy)	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(int, bool)	Sets whether users can resize individual rows.
SetRowVisible(int, bool)	Sets whether a row is displayed.
SetStyleInfo(int, int, StyleInfo)	Sets the style for a cell, a column, a row, or an entire sheet.
SetTag(int, int, object)	Sets the application-defined tag value for the specified cell, column, row, or entire sheet.
SetText(int, int, string)	Sets the formatted text in the cell using the IFormatter object for the cell.
SetValue(int, int, object)	Sets the value for a cell at the specified row and column.
ShouldSerializePrintInfo()	Determines whether the print information should be serialized.
Sort(int, int, int, int, bool, SortInfo[])	Sorts a range of cells in the data model.
SortColumns(int, bool)	Sorts all the columns in the sheet according to the specified parameters.
SortColumns(int, bool, IComparer)	Sorts all the columns in the sheet according to the specified parameters.
SortColumns(int, int, SortInfo[])	Sorts a range of columns in the sheet according to the specified parameters.
SortRows(int, bool, bool)	Sorts all the rows in the sheet according to the specified parameters.
SortRows(int, bool, bool, IComparer)	Sorts all the rows in the sheet according to the specified parameters.
SortRows(int, int, SortInfo[])	Sorts a range of rows in the sheet according to the specified parameters.
ToString()	Returns the name of the sheet.
UngroupSparkline(CellRange)	Ungroups the sparkline.
UngroupSparkline(CellRange[])	Ungroups the sparkline.
UngroupSparkline(string)	Ungroups the sparkline.