Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class
Fields Properties Methods


In This Topic
    SheetView Class Members
    In This Topic

    The following tables list the members exposed by SheetView.

    Public Constructors
     NameDescription
    Public ConstructorSheetView ConstructorOverloaded.   
    Top
    Protected Fields
     NameDescription
    Protected FieldchildViewsSpecifies a list of child views in a hierarchical display for this sheet.  
    Protected FieldparentViewSpecifies the parent view for this sheet.  
    Top
    Public Properties
     NameDescription
    Public PropertyActiveChartGets or sets the active chart.  
    Public PropertyActiveColumnGets or sets the active column.  
    Public PropertyActiveImageGets or sets the active image.  
    Public PropertyActiveRowGets or sets the active row.  
    Public PropertyActiveSkinGets or sets the current active skin.  
    Public PropertyAllowColumnMoveGets or sets whether to allow the user to move columns.  
    Public PropertyAllowDeleteGets or sets whether a user can delete a row in the sheet.  
    Public PropertyAllowGroupGets or sets whether a user can group rows.  
    Public PropertyAllowInsertGets or sets whether a user can insert a row in the sheet.  
    Public PropertyAllowLoadOnDemandGets or sets whether to allow incremental loads to the client on demand when the user is scrolling.  
    Public PropertyAllowPageGets or sets whether the sheet displays the number of pages and the arrows for navigating to other pages in the sheet.  
    Public PropertyAllowRowMoveGets or sets whether to allow the user to move rows.  
    Public PropertyAllowSortGets or sets whether users can sort rows in the sheet.  
    Public PropertyAllowTableCornerGets or sets whether to allow the sheet corner to be a structure table.  
    Public PropertyAllowUserFormulasGets or sets whether to allow the user to enter formulas in a cell in the control.  
    Public PropertyAllowVirtualScrollPagingGets or sets whether to allow virtual paging to load data when the user is scrolling.  
    Public PropertyAlternatingRowsGets the alternating rows in the specified portion of the sheet.  
    Public PropertyAutoCalculationGets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change.  
    Public PropertyAutoFilterModeGets or sets the AutoFilterMode which indicates which filtering UI is used.  
    Public PropertyAutoGenerateColumnsGets or sets whether to generate the columns automatically based on the data source.  
    Public PropertyAutoPostBackGets or sets whether a postback to the server automatically occurs when the user interacts with the sheet.  
    Public PropertyBackColorGets or sets the background color of the sheet.  
    Public PropertyCellsGets the cells in the data area of the sheet.  
    Public PropertyCellSpacingGets or sets the cell spacing to use in the displayed HTML page.  
    Public PropertyChartsGets the charts.  
    Public PropertyChildRelationCountGets the number of child views in a hierarchical display for this sheet.  
    Public PropertyClickHeaderCellToExpandWhen 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.  
    Public PropertyColumnAxisModelGets or sets the column information for the sheet.  
    Public PropertyColumnCountGets or sets the number of columns in the sheet.  
    Public PropertyColumnFooterGets the column footers for the sheet.  
    Public PropertyColumnFooterDataModelGets or sets the data for the column footer.  
    Public PropertyColumnFooterHeightGets or sets the column footer height.  
    Public PropertyColumnFooterRowAxisModelGets or sets the row information for the column footer.  
    Public PropertyColumnFooterSpanModelGets or sets the spanned cells for the column footer.  
    Public PropertyColumnFooterStyleModelGets or sets the cell types and other style settings for cells in the column footer.  
    Public PropertyColumnFooterVisibleGets or sets whether the column footers are visible.  
    Public PropertyColumnHeaderGets the column headers for the sheet.  
    Public PropertyColumnHeaderAutoFilterIndexGets or sets which column header row displays the filtering indicator when there are multiple column header rows.  
    Public PropertyColumnHeaderAutoTextGets or sets whether column headers display letters or numbers or are blank.  
    Public PropertyColumnHeaderAutoTextIndexGets or sets which column header row displays the automatic text when there are multiple column header rows.  
    Public PropertyColumnHeaderDataModelGets or sets the data for the column header.  
    Public PropertyColumnHeaderHeightGets or sets the column header height.  
    Public PropertyColumnHeaderRowAxisModelGets or sets the row information for the column header.  
    Public PropertyColumnHeaderSpanModelGets or sets the spanned cells for the column header.  
    Public PropertyColumnHeaderStyleModelGets or sets the cell types and other style settings for cells in the column header.  
    Public PropertyColumnHeaderVisibleGets or sets whether the column headers are visible.  
    Public PropertyColumnsGets the columns in the data area of the sheet.  
    Public PropertyConditionalFormattingGets or sets the conditional formatting model.  
    Public PropertyContextMenuStyleGets or sets the context menu style.  
    Public PropertyCurrentPageIndexGets or sets the current page.  
    Public PropertyDataAutoCellTypesGets or sets whether a bound sheet automatically sets the cell type for the cells in a column.  
    Public PropertyDataKeyFieldGets or sets the data key for this sheet.  
    Public PropertyDataKeyNamesGets or sets an array of strings that contains the names of the key fields for the data source for this sheet.  
    Public PropertyDataMemberGets or sets the data member for this sheet.  
    Public PropertyDataModelGets or sets the data for the sheet.  
    Public PropertyDataSourceGets or sets the data source for this sheet.  
    Public PropertyDataSourceIDGets or sets the unique identifier of the data source for this sheet.  
    Public PropertyDefaultColumnWidthGets or sets the default column width in pixels for all columns in the sheet.  
    Public PropertyDefaultRowHeightGets or sets the default row height in pixels for all rows in the sheet.  
    Public PropertyDefaultStyleGets or sets the default style information for the cells in this sheet.  
    Public PropertyDefaultStyleNameGets or sets the name of the default style for the cells in this sheet.  
    Public PropertyDeleteMethodGets or sets the name of the method to call in order to delete data.  
    Public PropertyEditRowGets or sets the row with the cell that is being edited.  
    Public PropertyEditTemplateColumnCountThe number of columns in the editing form.  
    Public PropertyEnableRowEditTemplateGets or sets whether to enable the row edit template.  
    Public PropertyExpandableGets or sets whether the rows are expandable.  
    Public PropertyFilterBarGets or sets FilterBarInfo for filterBar  
    Public PropertyFpSpreadGets the active FpSpread from the SheetView.  
    Public PropertyFrozenColumnCountGets or sets the number of frozen (non-scrollable) columns for this sheet.  
    Public PropertyFrozenRowCountGets or sets the number of frozen (non-scrollable) rows for this sheet.  
    Public PropertyGrayAreaCursorImageUrlGets or sets which ImageUrl of the cursor is displayed when the mouse is on the gray area of the sheet.  
    Public PropertyGrayAreaCursorTypeGets or sets which type of cursor is displayed when the mouse is on the gray area of the sheet.  
    Public PropertyGridLineColorGets or sets the color of the grid lines in the sheet.  
    Public PropertyGridLinesGets or sets whether to display grid lines in the sheet.  
    Public PropertyGroupBarBackColorGets or sets the grouping bar background color.  
    Public PropertyGroupBarHeightGets or sets the grouping bar height.  
    Public PropertyGroupBarTextGets or sets the group bar text.  
    Public PropertyGroupBarVisibleGets or sets whether the grouping bar is visible.  
    Public PropertyGroupFooterInfosGets or sets the collection of group footer information objects.  
    Public PropertyGroupFooterVisibleGets or sets whether the footer of the grouping bar is visible.  
    Public PropertyGroupInfosGets or sets the collection of group information objects.  
    Public PropertyGroupingPolicyGets or sets grouping policy to collapse or expand rows when grouping occurs.  
    Public PropertyGroupMaximumLevelGets or sets the maximum grouping level.  
    Public PropertyHeaderGrayAreaBackgroundImageUrlGets or sets the background image of the header area that does not contain column header or row header cells.  
    Public PropertyHeaderGrayAreaColorGets or sets the color of the header area that does not contain column header or row header cells.  
    Public PropertyIgnoreHiddenRowsWhenPagingGets or sets if the hidden rows are ignored when paging.  
    Public PropertyImagesGet the image collection  
    Public PropertyInsertMethodGets or sets the name of the method to call in order to insert data.  
    Public PropertyIsTrackingViewStateGets or sets whether the control tracks the current sheet view state.  
    Public PropertyItemTypeGets or sets the name of the data item type in model binding.  
    Public PropertyIterationGets or sets whether circular references in the sheet are evaluated.  
    Public PropertyLayoutModeGets or sets the type of layout mode.  
    Public PropertyLoadInitRowCountGets or sets the number of rows to load initially to the client.  
    Public PropertyLoadOffsetFromBottomGets 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.  
    Public PropertyLoadOnDemandIntervalGets or sets a period of time (in milliseconds) when spread loads the next set of rows.  
    Public PropertyLoadOnDemandModeGets 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.  
    Public PropertyLoadOnDemandTriggerModeGets 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.  
    Public PropertyLoadRowIncrementGets or sets the number of rows to include in incremental loads on demand.  
    Public PropertyLockBackColorGets or sets the background color of locked cells on this sheet.  
    Public PropertyLockForeColorGets or sets the foreground color of locked cells on this sheet.  
    Public PropertyMaximumChangeGets or sets the maximum amount of change below which iterations stop when circular references are evaluated for the sheet.  
    Public PropertyMaximumIterationsGets or sets the formula recalculation iteration count for the sheet.  
    Public PropertyMessageRowStyleGets or sets the style for the message row.  
    Public PropertyNamedStylesGets or sets a collection of styles.  
    Public PropertyNonEmptyColumnCountGets a value that is one more than the index of the last column on this sheet that contains data.  
    Public PropertyNonEmptyRowCountGets a value that is one more than the index of the last row on this sheet that contains data.  
    Public PropertyOperationModeGets or sets the operation mode of the sheet.  
    Public PropertyPageMaxAlignGets or sets whether to show the maximum number of rows on the last page.  
    Public PropertyPageSizeGets or sets the number of rows to display at a time.  
    Public PropertyParentGets the reference to the parent sheet (SheetView object).  
    Public PropertyParentRowIndexGets the index of the parent row in a hierarchical display.  
    Public PropertyPreviewRowColumnIndexGets or sets the index of the preview row column.  
    Public PropertyPreviewRowStyleGets or sets the style information for the preview row.  
    Public PropertyPreviewRowTemplateGets or sets the preview row template.  
    Public PropertyPreviewRowVisibleGets or sets whether to display the preview row.  
    Public PropertyPrintInfoGets or sets a PrintInfo object that determines printing behavior for the sheet.  
    Public PropertyProtectGets or sets whether users can edit cells marked as locked.  
    Public PropertyReferenceStyleGets or sets the cell reference style.  
    Public PropertyRelationNameGets the name of the data relation in a hierarchical display.  
    Public PropertyRenderEditorsGets or sets whether the FarPoint Spread always displays the editor if the editor is defined for a cell.  
    Public PropertyRowAxisModelGets or sets the row information for the sheet.  
    Public PropertyRowCountGets or sets the number of rows in the sheet.  
    Public PropertyRowEditTemplateGets or sets the row edit template.  
    Public PropertyRowFilterGets or sets the row filter for the sheet.  
    Public PropertyRowHeaderGets the row headers for the sheet.  
    Public PropertyRowHeaderAutoTextGets or sets whether row headers display letters or numbers or are blank.  
    Public PropertyRowHeaderAutoTextIndexGets or sets which row header column displays the automatic text when there are multiple row header columns.  
    Public PropertyRowHeaderColumnAxisModelGets or sets the column information for the row header.  
    Public PropertyRowHeaderDataModelGets or sets the data for the row header.  
    Public PropertyRowHeaderSpanModelGets or sets the spanned cells for the row header.  
    Public PropertyRowHeaderStyleModelGets or sets the cell types and other style settings for cells in the row header.  
    Public PropertyRowHeaderVisibleGets or sets whether the row headers are visible.  
    Public PropertyRowHeaderWidthGets or sets the row header column width.  
    Public PropertyRowsGets the rows in the data area of the sheet.  
    Public PropertyRowTemplateGets the row template of the sheet.  
    Public PropertyScrollingContentColumnsGets or sets the scrolling content tip columns.  
    Public PropertyScrollingContentHiddenDelayGets or sets the hidden delay of the scrolling content tip in milliseconds.  
    Public PropertyScrollingContentMaxHeightGets or sets the maximum height in pixels for the scrolling content tip.  
    Public PropertyScrollingContentVisibleGets or sets a value that indicates whether to display the scrolling content tip.  
    Public PropertySelectionBackColorGets or sets the background color for selected cells.  
    Public PropertySelectionBackColorStyleGets or sets the backcolor style for the display of selected cells.  
    Public PropertySelectionBorderGets or sets the settings for the selection border.  
    Public PropertySelectionForeColorGets or sets the text color for selected cells.  
    Public PropertySelectionModelGets or sets the selections for the sheet.  
    Public PropertySelectionPolicyGets or sets the selection policy.  
    Public PropertySelectMethodGets or sets the name of the method to call in order to read data.  
    Public PropertySheetCornerGets the sheet corner for the sheet.  
    Public PropertySheetCornerColumnAxisModelGets or sets the column information for the sheet corner.  
    Public PropertySheetCornerDataModelGets or sets the data for the sheet corner.  
    Public PropertySheetCornerRowAxisModelGets or sets the row information for the sheet corner.  
    Public PropertySheetCornerSpanModelGets or sets the spanned cells for the sheet corner.  
    Public PropertySheetCornerStyleGets or sets the style information for the sheet corner.  
    Public PropertySheetCornerStyleModelGets or sets the cell types and other style settings for cells in the sheet corner.  
    Public PropertySheetCornerStyleNameGets or sets the name of the style for the sheet corner.  
    Public PropertySheetNameGets or sets the name of the sheet.  
    Public PropertyShowFrozenIndicatorGets or sets whether the frozen indicator should be displayed.  
    Public PropertySortedColumnGets the model index of the column last sorted.  
    Public PropertySpanModelGets or sets the spanned cells for the sheet.  
    Public PropertySparklineContainerGets or sets the sparkline container.  
    Public PropertyStartingColumnNumberGets or sets the number displayed in the first column header.  
    Public PropertyStartingRowNumberGets or sets the number displayed in the first row header.  
    Public PropertyStartPageGets or sets the number of the first page to display in the page navigation aids.  
    Public PropertyStyleModelGets or sets the cell types and other style settings for the sheet.  
    Public PropertyTitleInfoGets the title information of the sheet.  
    Public PropertyTopRowGets or sets the row to display as the top row in the sheet.  
    Public PropertyUpdateMethodGets or sets the name of the method to call in order to update data.  
    Public PropertyVirtualScrollPagingFormatStringGets 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.  
    Public PropertyVirtualScrollPagingPrevRowCountIndicates 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.  
    Public PropertyVisibleGets or sets whether to display the sheet.  
    Public PropertyWorksheetTemplateGets the worksheet template.  
    Top
    Public Methods
     NameDescription
    Public MethodAddChartOverloaded. Adds the chart control.  
    Public MethodAddColumnsAdds columns to the data model at the specified index.  
    Public MethodAddImageOverloaded.   
    Public MethodAddRowsAdds rows to the data model.  
    Public MethodAddRowToDataSourceAdds the unbound row to the data source.  
    Public MethodAddSpanCellAdds a span of cells to a sheet.  
    Public MethodAddSparklineOverloaded. Adds the sparkline.  
    Public MethodAddSquareSparklineAdds the sparkline.  
    Public MethodAddUnboundRowsAdds unbound rows to the data model.  
    Public MethodAutoFilterColumnAutomatically filters the rows in the specified column according to the specified filter.  
    Public MethodAutoFilterResetResets the filters on the rows in the specified column.  
    Public MethodClearConditionalFormatingOverloaded. Removes all of the conditional formatting from the cell at the specified row and column.  
    Public MethodClearConditionalFormatingsRemoves all of the conditional formatting from the sheet.  
    Public MethodClearConditionalFormatsRemoves all of the conditional formats from the cell at the specified row and column.  
    Public MethodClearRangeRemoves all of the data, formatting, formulas, and notes from a range of cells on this sheet.  
    Public MethodClearRowFilterClears the row filter for this sheet.  
    Public MethodClearSparklineGroupsInRangeClears all sparkline groups.  
    Public MethodClearSparklinesClears all sparklines.  
    Public MethodExpandAllExpands or collapses all the levels of hierarchy  
    Public MethodExpandRowExpands or collapses the specified row in the hierarchical display.  
    Public MethodFindChildViewGets the child view in a hierarchical display with the specified row and data relation index.  
    Public MethodGetCellFromTagGets a cell with a specific tag on the sheet.  
    Public MethodGetCellRangeSpanCombinedGets the cell range of the combined span.  
    Public MethodGetCellTypeGets the cell type for a cell at the specified row and column.  
    Public MethodGetChildRelationGets the name of the child data relation in a hierarchical display at the specified index.  
    Public MethodGetChildViewGets a child sheet in a hierarchical display for the specified row and the specified relation index.  
    Public MethodGetChildVisibleGets whether the child view is displayed in a hierarchical display.  
    Public MethodGetClipOverloaded. Gets a tab-delimited string that contains the formatted text in a specified range.  
    Public MethodGetClipValueGets a tab-delimited string that contains the unformatted text in a specified range.  
    Public MethodGetColumnAllowFilterGets whether this column contains a column filter definition.  
    Public MethodGetColumnAutoTextGets the automatic text displayed in the specified column header.  
    Public MethodGetColumnFromTagGets a column on this sheet with a specific tag.  
    Public MethodGetColumnLabelGets the text in the column header cell at the specified row and column.  
    Public MethodGetColumnMergeGets whether or how cells in a column on this sheet that have the same content are joined in a single cell across multiple rows.  
    Public MethodGetColumnSizeableGets whether the user can resize a specified column.  
    Public MethodGetColumnSortIndicatorGets the sort indicator to display at the specified column.  
    Public MethodGetColumnVisibleGets whether a column is displayed.  
    Public MethodGetColumnWidthGets the width of the specified column in pixels.  
    Public MethodGetConditionalFormatsOverloaded. Gets the conditional formats for the cell at the specified row and column.  
    Public MethodGetConditionalFormattingOverloaded. Gets all the conditional formatting in the specified cell range.  
    Public MethodGetCustomNameOverloaded. Gets the string value for a custom name on this sheet from the model.  
    Public MethodGetDataKeyGets the identifier for the specified row if it is visible.  
    Public MethodGetDefaultEditorGets the default editor used to edit the cell.  
    Public MethodGetDefaultRendererGets the default renderer used to render the cell.  
    Public MethodGetDropDownFilterItemsGets the filter items to be displayed in the drop-down list for the specified column.  
    Public MethodGetEditorGets the editor used to edit a cell at the specified row and column.  
    Public MethodGetExpressionGets the formula of the specified cell on this sheet.  
    Public MethodGetFormatterGets the formatter used to format a cell at the specified row and column.  
    Public MethodGetFormulaGets the formula in the cell at the specified row and column.  
    Public MethodGetGroupFooterInfoGets the group footer information for the sheet.  
    Public MethodGetGroupInfoGets the group information for the sheet.  
    Public MethodGetModelColumnFromViewColumnGets the index in the model for the specified column.  
    Public MethodGetModelRowFromViewRowGets a row index in a model for a specified row in a sheet.  
    Public MethodGetNoteGets the cell note for a cell at the specified row and column.  
    Public MethodGetRendererGets the renderer used to render a cell at the specified row and column.  
    Public MethodGetRowAutoTextGets the automatic text displayed in the specified row header.  
    Public MethodGetRowExpandableGets whether the row on this sheet is expandable in the hierarchical display.  
    Public MethodGetRowFromTagGets a row on this sheet with a specific tag.  
    Public MethodGetRowHeightGets the height of the specified row.  
    Public MethodGetRowLabelGets the text in the specified row header cell.  
    Public MethodGetRowMergeGets whether or how cells in a row on this sheet that have the same content are joined into a single cell across multiple columns.  
    Public MethodGetRowSizeableGets whether the user can resize the specified row.  
    Public MethodGetRowVisibleGets whether a row is displayed.  
    Public MethodGetSelectionsGets 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.  
    Public MethodGetSpanCellGets the span of cells at a specified cell.  
    Public MethodGetSparklineGets the sparkline information.  
    Public MethodGetStyleInfoGets the composite cell style information for a cell at the specified row and column.  
    Public MethodGetTagGets the application-defined tag value for the specified cell, column, row, or entire sheet.  
    Public MethodGetTextGets the formatted text in the cell using the IFormatter object for the cell.  
    Public MethodGetUnboundValueGets the unbound value for a cell at the specified row and column.  
    Public MethodGetValidConditionalFormatGets the valid conditional format.  
    Public MethodGetValueGets unformatted data from a cell at the specified row and column.  
    Public MethodGetViewColumnFromModelColumnGets the sheet column index for a specified model column.  
    Public MethodGetViewRowFromModelRowGets a sheet row index for the specified model row.  
    Public MethodGroupSparklineOverloaded. Groups the sparkline and sets the type of the new group.  
    Public MethodIsColumnBoundGets whether the column is bound to a data source column.  
    Public MethodIsRowBoundGets whether the specified row is bound to a data source.  
    Public MethodIsRowExpandedGets whether the row is expanded in the hierarchical display.  
    Public MethodLoadFormulasLoads formulas that are deserialized, but not parsed yet, to be used after all sheets have been created and deserialized.  
    Public MethodLoadTextFileOverloaded. Loads a text file with the specified name into the sheet.  
    Public MethodLoadViewStateLoads a saved view state for a sheet.  
    Public MethodMoveColumnMoves the column or columns to a specified location.  
    Public MethodMoveRowMoves the row or rows to a specified location.  
    Public MethodOpenOverloaded. Opens a sheet saved as XML from the specified file and loads it into the sheet.  
    Public MethodOpenExcelOverloaded. Opens an Excel file and loads the specified Excel sheet into this sheet.  
    Public MethodRecalculateEvaluates all the formulas in the sheet that have changed since the last calculation cycle.  
    Public MethodRecalculateAllEvaluates all the formulas in the sheet (including those that have not changed since the last calculation cycle).  
    Public MethodRemoveColumnsRemoves the columns at the specified index.  
    Public MethodRemoveRowsRemoves the rows at the specified index.  
    Public MethodRemoveSpanCellRemoves the span from a range of cells that contain a specified anchor cell.  
    Public MethodResetSets the sheet to its default values.  
    Public MethodResetViewColumnIndexesResets all column indexes in the sheet to be the same as the column indexes in the corresponding data model.  
    Public MethodResetViewRowIndexesResets all row indexes in the sheet to be the same as the row indexes in the corresponding data model.  
    Public MethodSaveOverloaded. Saves the contents of the sheet to XML in the specified file.  
    Public MethodSaveHtmlOverloaded. Saves the sheet as HTML content to the stream  
    Public MethodSaveTextFileOverloaded. Saves the sheet to a text file with the specified name.  
    Public MethodSaveTextFileRangeOverloaded. Saves the range of cells (and may include headers) to a text file as specified.  
    Public MethodSaveViewStateSaves the current view state of the sheet.  
    Public MethodSetChildVisibleSets whether to display the child view in a hierarchical display.  
    Public MethodSetClipSets a tab-delimited string that contains the formatted text in a specified range.  
    Public MethodSetClipValueSets a tab-delimited string that contains the unformatted text in a specified range.  
    Public MethodSetColumnLabelSets the value for a specified cell in a column header.  
    Public MethodSetColumnMergeSets whether or how cells in a column on this sheet that have the same content are joined in a single cell across multiple rows.  
    Public MethodSetColumnSizeableSets whether users can resize individual columns.  
    Public MethodSetColumnSortIndicatorSets the sort indicator to display at the specified column.  
    Public MethodSetColumnVisibleSets whether a column is displayed.  
    Public MethodSetColumnWidthSets the width of the specified column in pixels.  
    Public MethodSetConditionalFormatOverloaded. Sets conditional formatting based on a specified comparison for a specified cell.  
    Public MethodSetConditionalFormattingOverloaded. Sets conditional formatting for a specified cell on the sheet based on specified rules.  
    Public MethodSetExpressionSets a formula in a specified cell on this sheet.  
    Public MethodSetFormulaSets the formula for a specified cell.  
    Public MethodSetFormulaConditionalFormatOverloaded. Sets conditional formatting based on a specified formula for a specified cell.  
    Public MethodSetModelDataColumnBinds the model column to the data source column.  
    Public MethodSetNoteSets the cell note for a specified cell.  
    Public MethodSetRowExpandableSets whether the row on this sheet can be expanded to show the child view in the hierarchical display.  
    Public MethodSetRowHeight

    Sets the height of the specified row in pixels.

     
    Public MethodSetRowLabelSets the value for a specified cell in the row header.  
    Public MethodSetRowMergeSets whether or how cells in a row on this sheet that have the same content are joined into a single cell across multiple columns.  
    Public MethodSetRowSizeableSets whether users can resize individual rows.  
    Public MethodSetRowVisibleSets whether a row is displayed.  
    Public MethodSetStyleInfoSets the style for a cell, a column, a row, or an entire sheet.  
    Public MethodSetTagSets the application-defined tag value for the specified cell, column, row, or entire sheet.  
    Public MethodSetTextSets the formatted text in the cell using the IFormatter object for the cell.  
    Public MethodSetValueSets the value for a cell at the specified row and column.  
    Public MethodSortSorts a range of cells in the data model.  
    Public MethodSortColumnsOverloaded. Sorts all the columns in the sheet according to the specified parameters.  
    Public MethodSortRowsOverloaded. Sorts all the rows in the sheet according to the specified parameters.  
    Public MethodToStringReturns the name of the sheet.  
    Public MethodUngroupSparklineOverloaded. Ungroups the sparkline.  
    Top
    Protected Methods
     NameDescription
    Protected MethodCreateColumnAxisModelCreates the column axis model.  
    Protected MethodCreateDataModelCreates the data model.  
    Protected MethodCreateRowAxisModelCreates the row axis model.  
    Protected MethodCreateSelectionModelCreates the selection model.  
    Protected MethodCreateSpanModelCreates the span model.  
    Protected MethodCreateStyleModelCreates the style model.  
    Protected MethodFlushDataCalls GetPagingSupport of the DataModel, selects data to data source view.  
    Protected MethodGetChildViewNameGets a name for the child view in a hierarchical display based on the row index and the relation index.  
    Protected MethodOnAddColumnFooterRowsProcesses the addition of the specified rows to the column footer in the data model.  
    Protected MethodOnAddColumnHeaderRowsProcesses the addition of the specified rows to the column header in the data model.  
    Protected MethodOnAddColumnsProcesses the addition of columns to the data model and updates the other models and internal variables of the fpSpread component.  
    Protected MethodOnAddRowHeaderColumnsProcesses the addition of columns to the row header of the sheet.  
    Protected MethodOnAddRowsProcesses the addition of rows to the data model.  
    Protected MethodOnDataModelChangedProcesses the change to the sheet data model and synchronizes the models.  
    Protected MethodOnRemoveColumnFooterRowsProcesses the removal of rows from the column header.  
    Protected MethodOnRemoveColumnHeaderRowsProcesses the removal of rows from the column header.  
    Protected MethodOnRemoveColumnsProcesses the removal of the specified columns from the data model.  
    Protected MethodOnRemoveRowHeaderColumnsProcesses the removal of columns from the row header.  
    Protected MethodOnRemoveRowsProcesses the removal of the specified rows from the data model.  
    Protected MethodShouldSerializePrintInfoDetermines whether the print information should be serialized.  
    Protected MethodSyncIndexOnAddColumnsSynchronizes the index on the added columns.  
    Protected MethodSyncIndexOnAddRowsSynchronizes the index on the added rows.  
    Protected MethodSyncIndexOnRemoveColumnsSynchronizes the index on the removed columns.  
    Protected MethodSyncIndexOnRemoveRowsSynchronizes the index on the removed rows.  
    Top
    See Also

    Reference

    SheetView Class
    FarPoint.Web.Spread Namespace
    FpSheetViewCollection class
    Sheets Property
    SheetViewCollection Class

    User-Task Documentation

    Customizing the Appearance of a Sheet