Spread Windows Forms 9.0 Product Documentation
SheetView Class Methods


For a list of all members of this type, see SheetView members.

Public Methods
 NameDescription
Public MethodAddChartOverloaded. Adds the chart control.  
Public MethodAddColumnFooterSpanCellAdds a span of cells to a column footer for a sheet.  
Public MethodAddColumnHeaderSpanCellAdds a span of cells to a column header for a sheet.  
Public MethodAddColumnsAdds the column or columns to the data model at the specified index.  
Public MethodAddControlOverloaded. Adds a child control to the control container for the sheet.  
Public MethodAddCustomFunctionAdds a user-defined custom function (FunctionInfo object) to the model for use in formulas.  
Public MethodAddCustomNameOverloaded. Adds a custom name to the model using the specified string value.  
Public MethodAddRangeGroupGroups all the rows or columns from the specified start index by the specified amount to an outline (range group).  
Public MethodAddRowHeaderSpanCellAdds a span of cells to a row header for a sheet.  
Public MethodAddRowsAdds a row or rows to the data model for a sheet.  
Public MethodAddRowToDataSourceAdds the unbound row to the data source for a sheet.  
Public MethodAddSelectionAdds a selection on this sheet.  
Public MethodAddShapeOverloaded. Adds a shape to the drawing container for the sheet.  
Public MethodAddSpanCellAdds a span of cells on this sheet.  
Public MethodAddSparklineOverloaded. Adds the sparkline.  
Public MethodAddSquareSparklineAdds the sparkline.  
Public MethodAddTableOverloaded. Adds a table with the specified name to the specified cell range of the sheet view with the default table style.  
Public MethodAddUnboundRowsAdds unbound rows to the data model for a sheet.  
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 MethodAutoSortColumnOverloaded. Automatically sorts the rows of a sheet according to the specified column.  
Public MethodBindDataColumnBinds the column to the data source column for a sheet.  
Public MethodClearColumnFooterSpanCellsRemoves all spans from the column footers.  
Public MethodClearColumnHeaderSpanCellsRemoves all spans from the column headers.  
Public MethodClearConditionalFormatingOverloaded. Removes all the conditional formatting from the specified cell.  
Public MethodClearConditionalFormatingsRemoves all the conditional formatting from the sheet.  
Public MethodClearControlsRemoves all child controls from the control container for the sheet.  
Public MethodClearCustomFunctionsRemoves all user-defined custom functions (FunctionInfo object) on this sheet from the model.  
Public MethodClearCustomNamesOverloaded. Removes all custom names on this sheet from the model.  
Public MethodClearRangeOverloaded. Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.  
Public MethodClearRangeGroupRemoves all the outlines (range grouping) from all rows or columns.  
Public MethodClearRowFilterOverloaded. Removes all of the row filters from this sheet.  
Public MethodClearRowHeaderSpanCellsRemoves all spans from the row headers.  
Public MethodClearSelectionRemoves all selections from this sheet.  
Public MethodClearShapesRemoves all shapes from the drawing container for the sheet.  
Public MethodClearSpanCellsRemoves all spans from this sheet.  
Public MethodClearSparklineGroupsInRangeClears all sparkline groups.  
Public MethodClearSparklinesClears all sparklines.  
Public MethodClipboardCopyOverloaded. Copies the contents from the sheet to the Clipboard.  
Public MethodClipboardCopyShapeCopies the active shape to the Clipboard.  
Public MethodClipboardCutOverloaded. Cuts the contents from the sheet to the Clipboard.  
Public MethodClipboardCutShapeCuts the active shape to the Clipboard.  
Public MethodClipboardPasteOverloaded. Pastes the contents from the Clipboard to the active sheet.  
Public MethodClipboardPasteShapeOverloaded. Pastes the shape from the Clipboard.  
Public MethodConvertTableToRangeConverts the specified table to a range.  
Public MethodCopyRangeCopies the data, formatting, formulas, and notes from a block of cells on the sheet to a new location.  
Public MethodExpandRangeGroupOverloaded. Expands or collapses a specified outline (range group) of rows or columns.  
Public MethodExpandRowExpands or collapses the specified parent row, which shows or hides the child view in a hierarchical display.  
Public MethodFillRangeOverloaded. Fills a range of cells on this sheet by copying a specified range in the specified direction.  
Public MethodFindChildViewGets the child view for this sheet with the specified name.  
Public MethodGetArrayGets a two-dimensional array of objects that contain the data for the specified range of cells on the sheet.  
Public MethodGetCellErrorTextGets the error text of a specified cell.  
Public MethodGetCellFromTagGets a cell with a specific tag on the sheet.  
Public MethodGetCellTypeGets the composited (inherited) cell type for a specified cell on the sheet.  
Public MethodGetChildRelationGets the name of the child data relation at the specified index on the sheet.  
Public MethodGetChildSheetsGets a list of child sheet views that have been created.  
Public MethodGetChildViewCreates the sheet (SheetView object) for the specified row and the specified relation index.  
Public MethodGetChildVisibleGets whether to show the child view on this sheet when the parent row is expanded.  
Public MethodGetClipGets a tab-delimited string that contains the formatted data in a specified range of cells on this sheet.  
Public MethodGetClipDataObjectGets a data object with the necessary formats for Clipboard usage: CellInfoRange, ColumnInfoRange, and RowInfoRange.  
Public MethodGetClipValueGets a tab-delimited string that contains the unformatted data in a range of cells on this sheet.  
Public MethodGetColumnAllowAutoSortGets whether the specified column on this sheet allows automatic sorting.  
Public MethodGetColumnAllowFilterGets whether this column contains a column filter definition.  
Public MethodGetColumnAutoFilterIndexGets the automatic filter index for the specified column.  
Public MethodGetColumnAutoSortIndexGets the automatic sort index for the specified column.  
Public MethodGetColumnAutoTextGets the automatic text displayed in the column header for the specified column on this sheet.  
Public MethodGetColumnFooterTextGets the text in the specified column footer cell on this sheet.  
Public MethodGetColumnFromTagGets a column on this sheet with a specific tag.  
Public MethodGetColumnHeaderSpanCellGets the range of cells that are spanned at a specified cell on the column header of this sheet.  
Public MethodGetColumnLabelGets the text in the specified column header cell on this sheet.  
Public MethodGetColumnMergeGets whether or how cells in a column on this sheet that have the same content are joined into a single cell across multiple rows.  
Public MethodGetColumnPageBreakGets whether a forced page break is inserted before the specified column on this sheet when printing.  
Public MethodGetColumnShowSortIndicatorGets whether the specified column on this sheet should display a sort indicator when automatically sorted.  
Public MethodGetColumnSizeableGets whether the user can resize a specified column on this sheet.  
Public MethodGetColumnSortIndicatorGets the sort indicator for the specified column on this sheet.  
Public MethodGetColumnVisibleGets whether a column on this sheet is displayed.  
Public MethodGetColumnWidthGets the width in pixels for the specified column on this sheet.  
Public MethodGetConditionalFormattingOverloaded. Gets all conditional formatting in the specified cell range.  
Public MethodGetControlGets a child control.  
Public MethodGetControlContainerGets the control container for a sheet.  
Public MethodGetCustomFunctionGets a user-defined custom function (FunctionInfo object) from the model for this sheet.  
Public MethodGetCustomFunctionEnumeratorGets an IEnumerator for this sheet that enumerates through the names of the user-defined custom functions (FunctionInfo objects) in the model.  
Public MethodGetCustomNameOverloaded. Gets the string value for a custom name on this sheet from the model.  
Public MethodGetCustomNameCommentGets the comment of the custom name.  
Public MethodGetCustomNameEnumeratorOverloaded. Gets an IEnumerator on this sheet that enumerates through the custom names defined in the model.  
Public MethodGetDataViewGets the DataView object on this sheet.  
Public MethodGetEditorGets the editor used to edit a specified cell on this sheet.  
Public MethodGetExpressionGets the formula, as an expression value, for the cell of the specified row and column of this sheet.  
Public MethodGetFilterBarCellTypeGets the composited (inherited) cell type for a specified cell on the filter bar.  
Public MethodGetFormulaGets the formula of the specified cell on this sheet.  
Public MethodGetLastNonEmptyColumnGets the index of the last column that contains data or formatting on this sheet.  
Public MethodGetLastNonEmptyRowGets the row index of the last row that contains data or formatting on this sheet.  
Public MethodGetModelColumnFromViewColumnGets the column index in the data model that corresponds to the specified column index in the sheet.  
Public MethodGetModelRowFromViewRowGets the row index in the data model that corresponds to the specified row index in the sheet.  
Public MethodGetNoteGets the note (comments) from a specified cell.  
Public MethodGetNoteBoundsGets the rectangle for the cell note for the specified cell if its NoteStyle is StickyNote.  
Public MethodGetPreferredCellSizeGets the desired size of the given cell on this sheet.  
Public MethodGetPreferredColumnWidthOverloaded. Gets the width of the widest cell (based on text content) in the specified column on this sheet.  
Public MethodGetPreferredPrintColumnWidthGets the width of the widest cell (based on text content) in the specified column on this sheet for printing to the specified graphics device.  
Public MethodGetPreferredPrintRowHeightGets the height in pixels of the tallest cell (based on text content) in the specified row on this sheet.  
Public MethodGetPreferredRowHeightOverloaded. Gets the height in pixels of the tallest cell (based on text content) in the specified row on this sheet.  
Public MethodGetRangeGroupInfoGets range groups of rows or columns by level.  
Public MethodGetRangeGroupLevelsGets the number of levels of rows or columns in the outline (range group).  
Public MethodGetRendererGets the renderer used to render a specified cell on this sheet.  
Public MethodGetRootSheetGets the top SheetView object.  
Public MethodGetRowAutoTextGets the automatic text displayed in the row header for the specified row on this sheet.  
Public MethodGetRowErrorTextGets the row error text.  
Public MethodGetRowExpandableGets whether the row on this sheet can be expanded to show a child view in a hierarchical display.  
Public MethodGetRowFromTagGets a row on this sheet with a specific tag.  
Public MethodGetRowHeaderSpanCellGets the range of cells that are spanned at a specified cell on the row header of this sheet.  
Public MethodGetRowHeightGets the height in pixels for the specified row on this sheet.  
Public MethodGetRowLabelGets the text in the specified row header cell on this sheet.  
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 MethodGetRowPageBreakGets whether a forced page break is inserted before the specified row on this sheet when printing.  
Public MethodGetRowSizeableGets whether users can resize the specified row on this sheet.  
Public MethodGetRowVisibleGets whether a row on this sheet is displayed.  
Public MethodGetSelectionGets the selection on this sheet with the specified index.  
Public MethodGetSelectionsGets an ordered array of FarPoint.Win.Spread.Model.CellRange objects, from largest to smallest, that contain the selected cells on the sheet with minimal overlap between the ranges.  
Public MethodGetShapeGets a shape.  
Public MethodGetSpanCellGets the range of cells that are spanned at a specified cell on this sheet.  
Public MethodGetSparklineGets the sparkline information.  
Public MethodGetStickyNoteStyleInfoGets the style information for the cell notes on this sheet that stay visible.  
Public MethodGetStyleInfoOverloaded. Gets the style information for a specified cell on this sheet.  
Public MethodGetTableOverloaded. Gets a TableView from a specific position.  
Public MethodGetTableEnumeratorGets the FarPoint.Win.Spread.Model.ITableRange enumerator.  
Public MethodGetTagGets the application-defined tag value for the specified cell, column, row, or entire sheet.  
Public MethodGetTextGets the formatted text in the cell on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell.  
Public MethodGetUnboundValueGets the unbound value for the cell on this sheet.  
Public MethodGetValidConditionalFormatGets the valid conditional format.  
Public MethodGetValueGets unformatted data from the specified cell on this sheet.  
Public MethodGetViewColumnFromModelColumnGets the column on the sheet that corresponds to the specified column index in the model.  
Public MethodGetViewRowFromModelRowGets the row on the sheet that corresponds to the specified row index in the model.  
Public MethodGroupSparklineOverloaded. Groups the sparkline and sets the type of new group.  
Public MethodIsAnyCellInColumnSelectedGets whether any cells in the specified column on this sheet are selected.  
Public MethodIsAnyCellInRowSelectedGets whether any cells in the specified row on this sheet are selected.  
Public MethodIsColumnBoundGets whether the specified column on this sheet is bound to a data source.  
Public MethodIsRowBoundGets whether the specified row on this sheet is bound to a data source.  
Public MethodIsRowExpandedGets whether the row on this sheet displays a child view in a hierarchical display.  
Public MethodIsSelectedGets whether the specified cell on this sheet is selected.  
Public MethodJoinShapesJoins two shapes in the drawing container for the sheet.  
Public MethodLoadFormulasLoads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized.  
Public MethodLoadTextFileOverloaded. Loads delimited text from a specified file into the sheet, with or without headers, with the specified encoding.  
Public MethodLoadTextFileRangeOverloaded. Loads delimited text from a specified file into the sheet.  
Public MethodModifyCustomNameModifies the name of a custom name.  
Public MethodMoveColumnOverloaded. Moves the specified column from its current index to the specified index, and shifts each column in between and the destination column one column in the direction of the specified column.  
Public MethodMoveRangeMoves the data, formatting, formulas, and notes from a block of cells on this sheet to a new location.  
Public MethodMoveRowOverloaded. Moves the specified row from its current index to the specified index, and shifts each row in between and the destination row one row in the direction of the specified row.  
Public MethodOnSheetRangeGroupModelChangedChanges the sheet row axis model in synchronization with the data source.  
Public MethodOpenOverloaded. Opens a saved XML file into a sheet view.  
Public MethodOpenExcelOverloaded. Opens an Excel stream and loads the specified sheet (by name) from that file into this sheet.  
Public MethodOpenSpreadFileOpens a saved Spread file into this sheet.  
Public MethodRaiseCellChangedOverloaded. Raises the CellChanged event (that a change has been made to a cell on this sheet).  
Public MethodRaisePropertyChangedRaises the PropertyChanged event for this sheet.  
Public MethodRecalculateEvaluates all the formulas in cells on the sheet that have changed since the last calculation cycle.  
Public MethodRecalculateAllEvaluates all the formulas in cells on the sheet (including those that have not changed since the last calculation cycle).  
Public MethodRemoveColumnFooterSpanCellRemoves the span that contains a specified anchor cell from a range of cells in the column footers.  
Public MethodRemoveColumnHeaderSpanCellRemoves the span that contains a specified anchor cell from a range of cells in the column headers.  
Public MethodRemoveColumnsRemoves the column or columns on this sheet at the specified index.  
Public MethodRemoveControlOverloaded. Removes the child control from the control container for the sheet.  
Public MethodRemoveCustomFunctionRemoves a user-defined custom function (FunctionInfo object) on this sheet from the model.  
Public MethodRemoveCustomNameOverloaded. Removes a custom name on this sheet from the model.  
Public MethodRemoveRangeGroupRemoves rows or columns from an outline (range group) from a specified start index by a specified amount, and returns them to individual rows or columns.  
Public MethodRemoveRowHeaderSpanCellRemoves the span that contains a specified anchor cell from a range of cells in the row headers.  
Public MethodRemoveRowsRemoves the row or rows on this sheet at the specified index.  
Public MethodRemoveSelectionRemoves the specified selection from this sheet.  
Public MethodRemoveShapeRemoves the shape from the drawing container for the sheet.  
Public MethodRemoveSpanCellRemoves the span that contains a specified anchor cell from a range of cells on this sheet.  
Public MethodRemoveTableRemoves a TableView.  
Public MethodResetResets the view on this sheet to its original state.  
Public MethodResumeAutoUpdateChartDataResumes updates of values to the chart immediately.  
Public MethodSaveOverloaded. Saves the contents of the sheet view to the specified file.  
Public MethodSaveHtmlOverloaded. Saves the sheet to the specified file in HTML.  
Public MethodSaveHtmlRangeOverloaded. Saves the specified range in the sheet to the specified file in HTML.  
Public MethodSaveTextFileOverloaded. Saves the sheet as delimited text to a file with specific delimiters.  
Public MethodSaveTextFileRangeOverloaded. Saves the range of cells in a sheet to a text file with the specified name, formatting settings, and delimiters.  
Public MethodSaveXmlOverloaded. Saves the data on the sheet to the specified XML stream and the schema to the specified schema stream.  
Public MethodSetActiveCellOverloaded. Sets the active cell on this sheet.  
Public MethodSetArraySets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet.  
Public MethodSetCellErrorTextSets the error text for a specified cell.  
Public MethodSetChildVisibleSets whether to make the child view on this sheet visible when the parent row is expanded.  
Public MethodSetClipSets a tab-delimited string of formatted text in a specified range of cells on this sheet.  
Public MethodSetClipSpecialOverloaded. Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.  
Public MethodSetClipValueSets a tab-delimited string of unformatted data in a specified range of cells on this sheet.  
Public MethodSetColumnAllowAutoSortOverloaded. Sets whether the specified column on this sheet allows automatic sorting.  
Public MethodSetColumnAllowFilterOverloaded. Sets whether the specified column on this sheet allows filtering.  
Public MethodSetColumnAutoFilterIndexSets the automatic filter index for the specified column.  
Public MethodSetColumnAutoSortIndexSets the automatic sort index for the specified column.  
Public MethodSetColumnLabelSets the value for a specified cell in a column header on this sheet.  
Public MethodSetColumnMergeSets whether or how cells in a column on this sheet that have the same content are joined into a single cell across multiple rows.  
Public MethodSetColumnPageBreakSets whether a forced page break is inserted before the specified column on this sheet when printing.  
Public MethodSetColumnShowSortIndicatorOverloaded. Sets whether the specified column or columns should show a sort indicator when automatically sorted.  
Public MethodSetColumnSizeableSets whether the user can resize a specified column on this sheet.  
Public MethodSetColumnSortIndicatorSets the sort indicator for the specified column on this sheet.  
Public MethodSetColumnVisibleSets whether a column on this sheet is displayed.  
Public MethodSetColumnWidthSets the width in pixels for the specified column on this sheet.  
Public MethodSetConditionalFormattingOverloaded. Sets conditional formatting for a specified cell on the sheet based on specified rules.  
Public MethodSetCustomNameCommentAdds a comment to the specified custom name.  
Public MethodSetExpressionSets the formula, as an expression, in the cell at the specified row and column of this sheet.  
Public MethodSetFormulaSets a formula in a specified cell on this sheet.  
Public MethodSetInsideBorderSets borders on the inside of a range of cells.  
Public MethodSetModelColumnForViewColumnSets the column index in the data model that corresponds to the specified column index in the sheet.  
Public MethodSetModelRowForViewRowSets the row index in the data model that corresponds to the specified row index in the sheet.  
Public MethodSetMultipleColumnWidthsSets the width in pixels for the specified columns on this sheet.  
Public MethodSetMultipleRowHeightsSets the height in pixels for the specified rows on this sheet.  
Public MethodSetNoteSets a note in a specified cell on this sheet.  
Public MethodSetNoteBoundsSets the location and dimensions for a cell note when the style sets the note to always be shown.  
Public MethodSetOutlineBorderSets border outlines for a range of cells.  
Public MethodSetRowErrorTextSets error text for row.  
Public MethodSetRowExpandableSets whether the row on this sheet can be expanded to show a child view in a hierarchical display.  
Public MethodSetRowHeightSets the height in pixels for the specified row on this sheet.  
Public MethodSetRowLabelSets the value for a specified cell in the row header on this sheet.  
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 MethodSetRowPageBreakSets whether a forced page break is inserted before the specified row on this sheet when printing.  
Public MethodSetRowSizeableSets whether users can resize the specified row on this sheet.  
Public MethodSetRowVisibleSets whether a row on this sheet is displayed.  
Public MethodSetStickyNoteStyleInfoSets the style information for the cell notes on this sheet that stay visible.  
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 on this sheet using the FarPoint.Win.Spread.CellType.IFormatter object for the cell.  
Public MethodSetValueOverloaded. Sets the value for the specified cell on this sheet.  
Public MethodShouldSerializeBackgroundImageGets whether the background image should be serialized.  
Public MethodShouldSerializeColumnFooterSheetCornerHorizontalGridLineGets whether the horizontal grid line for the footer corner should be serialized.  
Public MethodShouldSerializeColumnFooterSheetCornerVerticalGridLineGets whether the vertical grid line for the footer corner should be serialized.  
Public MethodShouldSerializeIsBackgroundImageTiledGets whether the tiled background image should be serialized.  
Public MethodShowNotesShows or hides all cell notes on the sheet.  
Public MethodSortColumnsOverloaded. Sorts a range of columns in the sheet.  
Public MethodSortRangeSorts a range of cells on this sheet in the data model.  
Public MethodSortRowsOverloaded. Sorts a range of rows in the sheet.  
Public MethodSuspendAutoUpdateChartDataSuspends updates of values to the chart immediately.  
Public MethodSwapRangeSwaps the data and formatting in a block of cells on this sheet with another block of cells on this sheet.  
Public MethodUngroupSparklineOverloaded. Ungroups the sparkline.  
Public MethodUpdateNotesOverloaded. Updates cell note appearances based on style being set or on changes to note text.  
Top
Protected Methods
 NameDescription
Protected MethodGetColumnVisibleCountGets the number of the visible columns.  
Protected MethodGetRowVisibleCountGets the number of the visible rows.  
Protected MethodOnAddColumnFooterRowsOccurs when footer rows are added.  
Protected MethodOnDisposingRaises the Disposing event  
Protected MethodOnNoteCreatedOccurs when a note for the viewport area is created in the sheet's notes container.  
Protected MethodOnNoteMovedOccurs when a note for the viewport area is moved in the sheet's notes container.  
Protected MethodOnNoteSizedOccurs when a note for the viewport area is sized in the sheet's notes container.  
Protected MethodOnRemoveColumnFooterRowsOccurs when column footer rows are removed.  
Protected MethodShouldSerializeColumnFooterSheetCornerStyleGets whether the style for the sheet corner should be serialized.  
Protected MethodShouldSerializeFilterBarHeaderStyleGets whether the style for the filter bar header should be serialized.  
Protected MethodShouldSerializeLockFontDetermines whether lock font should be serialized.  
Protected MethodShouldSerializeNullBackColorDetermines whether null background color should be serialized.  
Protected MethodShouldSerializeNullFontDetermines whether null font should be serialized.  
Protected MethodShouldSerializeNullForeColorDetermines whether null text color should be serialized.  
Protected MethodShouldSerializeSelectionFontDetermines whether selection font should be serialized.  
Top
See Also

Reference

SheetView Class
FarPoint.Win.Spread Namespace

User-Task Documentation

Adding a Sheet
Customizing the Appearance of a Sheet
Customizing Interaction with a Sheet

 

 


Copyright © GrapeCity, inc. All rights reserved.