Spread Windows Forms 15.0
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class
Fields Properties Methods Events


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
    Public Fields
     NameDescription
    Public FieldIsDisposing  
    Top
    Public Properties
     NameDescription
    Public PropertyActiveCellGets a Cell object for the active cell on the sheet.  
    Public PropertyActiveColumnGets a Column object for the active column on the sheet.  
    Public PropertyActiveColumnIndexGets or sets the column index of the active cell on the sheet.  
    Public PropertyActiveRowGets a Row object for the active row on the sheet.  
    Public PropertyActiveRowIndexGets or sets the row index of the active cell on the sheet.  
    Public PropertyActiveSkinGets or sets the skin for the sheet.  
    Public PropertyAllowAutoSortIndexes  
    Public PropertyAllowGroupGets or sets whether to allow the user to group rows on the sheet.  
    Public PropertyAllowNoteEditGets or sets whether notes on this sheet are editable.  
    Public PropertyAllowTableCornerGets or sets whether the sheet corner can have a grid structure (table).  
    Public PropertyAlternatingRowsGets an AlternatingRows object for the alternating rows in the data area of the sheet.  
    Public PropertyAutoCalculationGets or sets whether the control recalculates each formula when the contents of dependent cells change for a sheet.  
    Public PropertyAutoFilterGets or sets whether the filter will automatically update for any changes.  
    Public PropertyAutoFilterModeGets or sets the AutoFilterMode.  
    Public PropertyAutoGenerateColumnsGets or sets whether to automatically generate the columns for a sheet based on the data source.  
    Public PropertyAutoSortColumnsGets or sets whether to allow automatic sorting for a sheet and whether to show the sort indicator.  
    Public PropertyAutoSortEnhancedContextMenuGets or sets whether to use the Spread's enhanced filter menu.  
    Public PropertyAutoSortEnhancedModeGets or sets whether to use the Spread's sorting behavior in enhanced filter context menu.  
    Public PropertyAutoSortFrozenRowsGets or sets a value that indicates whether frozen rows are sorted.  
    Public PropertyAutoSortTrailingFrozenRowsGets or sets a value that indicates whether trailing frozen rows are sorted.  
    Public PropertyAutoUpdateNotesGets or sets whether cell notes are automatically updated when changes are made to the note style or to the text, or notes are added, removed, or moved.  
    Public PropertyBackgroundImageGets or sets sheetview background image.  
    Public PropertyBackgroundImageLayoutGets or sets sheetview background image layout.  
    Public PropertyCellsGets a Cells object for the cells in the data area of the sheet.  
    Public PropertyChartsGets the charts.  
    Public PropertyChildRelationCountGets the number of child relations (data relation count) for a sheet.  
    Public PropertyCodeDomDeserializingInternal use only  
    Public PropertyColumnAutoSortedGets the index of the last column that was automatically sorted for the sheet.  
    Public PropertyColumnCountGets or sets the number of columns in the sheet.  
    Public PropertyColumnFooterGets the ColumnFooter object for the column footer area of the sheet.  
    Public PropertyColumnFooterHorizontalGridLineGets or sets the horizontal grid line in the column footer for the sheet.  
    Public PropertyColumnFooterRowCountGets or sets the number of rows in the column footers for the sheet.  
    Public PropertyColumnFooterSheetCornerHorizontalGridLineGets or sets the horizontal grid line for the column footer sheet corner.  
    Public PropertyColumnFooterSheetCornerStyleGets or sets the style information for the sheet corner for the column footer.  
    Public PropertyColumnFooterSheetCornerStyleNameGets or sets the name of the style for the sheet corner of the column footer.  
    Public PropertyColumnFooterSheetCornerVerticalGridLineGets or sets the vertical grid line for the column footer sheet corner.  
    Public PropertyColumnFooterVerticalGridLineGets or sets the vertical grid line in the column footer for the sheet.  
    Public PropertyColumnFooterVisibleGets or sets whether the column footers for this sheet are visible.  
    Public PropertyColumnHeaderGets the ColumnHeader object for the column header area of the sheet.  
    Public PropertyColumnHeaderAutoFilterIndexGets or sets which column header row in the sheet displays the filter indicator when there are multiple column header rows.  
    Public PropertyColumnHeaderAutoSortIndexGets or sets which column header row in the sheet displays the sort indicator when there are multiple column header rows.  
    Public PropertyColumnHeaderAutoTextGets or sets whether column headers for the sheet display letters or numbers or are blank.  
    Public PropertyColumnHeaderAutoTextIndexGets or sets which column header row for the sheet displays the automatic text when there are multiple column header rows.  
    Public PropertyColumnHeaderHorizontalGridLineGets or sets the horizontal grid line for the sheet.  
    Public PropertyColumnHeaderRowCountGets or sets the number of rows in the column headers for the sheet.  
    Public PropertyColumnHeaderVerticalGridLineGets or sets the vertical grid line in the column header for the sheet.  
    Public PropertyColumnHeaderVisibleGets or sets whether the column headers for this sheet are visible.  
    Public PropertyColumnsGets a Columns object for the columns in the data area of the sheet.  
    Public PropertyContainer (Inherited from System.ComponentModel.Component)
    Public PropertyContainingViewsGets the containing views.  
    Public PropertyDataAllowAddNewGets or sets whether to allow the user to add a new row when the sheet is bound.  
    Public PropertyDataAutoCellTypesGets or sets whether a bound sheet automatically sets the cell type for the cells in a column.  
    Public PropertyDataAutoHeadingsGets or sets whether a bound sheet automatically assigns the data field names to be the text in the column headers.  
    Public PropertyDataAutoSizeColumnsGets or sets whether a bound sheet automatically sizes its columns based on the data in the associated database fields.  
    Public PropertyDataMemberGets or sets the name of the data member that populates the sheet.  
    Public PropertyDataSourceGets or sets the name of the data source that populates the sheet.  
    Public PropertyDefaultGroupFooterDefault setting for group footers.  
    Public PropertyDefaultStyleGets or sets a StyleInfo object for the default style of the sheet.  
    Public PropertyDefaultStyleNameGets or sets the name of the default style for the sheet.  
    Public PropertyDisplayZeroGets or sets whether zero values are displayed in cells.  
    Public PropertyDrawingContainerGets or sets a drawing container for the sheet for a drawing object in the drawing space.  
    Public PropertyEnableDiagonalLineSets or gets whether cell diagonal line is enable.  
    Public PropertyEnhancedFilterSortingModeGets or sets whether the enhanced filter shows items in the tree by default or alphabetic order.  
    Public PropertyExpandableGets or sets whether the rows are expandable.  
    Public PropertyFilterBarGets the FilterBar object of the sheet.  
    Public PropertyFilterBarHeaderHorizontalGridLineGets or sets the horizontal grid line for the filter bar header.  
    Public PropertyFilterBarHeaderStyleGets or sets the style information for the filter bar header.  
    Public PropertyFilterBarHeaderStyleNameGets or sets the name of the style for the filter bar header.  
    Public PropertyFilterBarHeaderVerticalGridLineGets or sets the vertical grid line for the filter bar.  
    Public PropertyFilterBarHorizontalGridLineGets or sets the horizontal grid line for the filter bar.  
    Public PropertyFilterBarVerticalGridLineGets or sets the vertical grid line for the filter bar.  
    Public PropertyFpSpreadGets Fpspread from sheet view.  
    Public PropertyFrozenColumnCountGets or sets the number of non-scrolling columns on the leading edge of this sheet.  
    Public PropertyFrozenRowCountGets or sets the number of non-scrolling rows on the leading edge of this sheet.  
    Public PropertyFrozenTrailingColumnCountGets or sets the number of non-scrolling columns on the trailing edge of this sheet.  
    Public PropertyFrozenTrailingRowCountGets or sets the number of non-scrolling rows on the trailing edge of this sheet.  
    Public PropertyFrozenTrailingStickToEdgeGets or sets whether the frozen trailing row(s) or column(s) stick to the edge of viewport area.  
    Public PropertyGrayAreaBackColorGets or sets the color in the area between the sheet and the edge of the control.  
    Public PropertyGroupBarBackColorObsolete. Use GroupBarInfo.BackColor instead. Gets or sets the background color for the grouping bar of the sheet.  
    Public PropertyGroupBarHeightObsolete. Use GroupBarInfo.Height instead. Gets or sets the height of the grouping bar for the sheet.  
    Public PropertyGroupBarInfoGets or sets the information of the grouping bar for the sheet.  
    Public PropertyGroupBarVisibleObsolete. Use GroupBarInfo.Visible instead. Gets or sets whether the grouping bar for the sheet is displayed.  
    Public PropertyGroupFooterVisibleGets or sets whether the group footer is displayed.  
    Public PropertyGroupInfosGets or sets the collection of grouping information objects for the sheet.  
    Public PropertyGroupingPolicyGets or sets grouping policy to collapse or expand rows when grouping occurs.  
    Public PropertyGroupMaximumLevelGets or sets the maximum number of levels of grouping for the sheet.  
    Public PropertyGroupVerticalIndentObsolete. Use GroupBarInfo.GroupVerticalIndent instead. Gets or sets the separation of grouping levels for the sheet.  
    Public PropertyHorizontalGridLineGets or sets the horizontal grid line for this sheet.  
    Public PropertyIgnoreRemoveChartFromSheetView  
    Public PropertyIsBlockSelectedGets whether a block of cells on this sheet is currently selected.  
    Public PropertyIterationGets or sets whether circular references are evaluated on this sheet.  
    Public PropertyLockBackColorGets or sets the background color of locked cells on this sheet.  
    Public PropertyLockFontGets or sets the default font for locked items 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 on this sheet.  
    Public PropertyMaximumIterationsGets or sets the maximum number of iterations for calculating circular references on this sheet.  
    Public PropertyMinZoomFactorGets or sets a value that indicates the minimum zoom factor for this sheet.  
    Public PropertyModelsGets or sets a SheetView.DocumentModels object that contains all the models for the sheet.  
    Public PropertyNamedStylesGets or sets a NamedStyleCollection of NamedStyle objects for this sheet.  
    Public PropertyNonEmptyColumnCountGets a value that is one more than the index of the last column on this sheet containing data.  
    Public PropertyNonEmptyRowCountGets a value that is one more than the index of the last row on this sheet containing data.  
    Public PropertyNotesContainerInternal use only. Gets or sets the drawing container for cell notes in the drawing space.  
    Public PropertyNullBackColorGets or sets the background color of null items on this sheet.  
    Public PropertyNullFontGets or sets the default font for null items on this sheet.  
    Public PropertyNullForeColorGets or sets the foreground color of null items on this sheet.  
    Public PropertyOperationModeGets or sets the mode that determines mouse, keyboard, and selection behavior for this sheet.  
    Public PropertyParentGets or sets the name of the parent sheet (SheetView object) of this sheet.  
    Public PropertyParentRelationNameGets the data relation name for this sheet.  
    Public PropertyParentRowIndexGets the index of the parent row on this sheet.  
    Public PropertyPreviewRowInfoGets or sets preview row information for the sheet.  
    Public PropertyPrintInfoGets or sets a PrintInfo object that determines printing behavior for the sheet.  
    Public PropertyPropertyCodeDomSetIntInternal use only  
    Public PropertyProtectGets or sets whether cells on this sheet that are marked as locked are not editable.  
    Public PropertyRangeGroupBackgroundColorGets or sets the background color of the outline (range group) region.  
    Public PropertyRangeGroupButtonStyleGets or sets the style of the outline (range group) button.  
    Public PropertyRangeGroupSummaryColumnRightGets or sets whether the direction of the summary column is to the right of the detail.  
    Public PropertyRangeGroupSummaryRowBelowGets or sets whether the direction of the summary row is below the detail.  
    Public PropertyReferenceStyleGets or sets the style for cell and range references in formulas in cells on this sheet.  
    Public PropertyRename  
    Public PropertyRestrictColumnsGets or sets whether users are restricted from typing data in a column on this sheet that is more than one column beyond the last column that contains data.  
    Public PropertyRestrictRowsGets or sets whether users are restricted from typing data in a row on this sheet that is more than one row beyond the last row that contains data.  
    Public PropertyRowCountGets or sets the number of rows on this sheet.  
    Public PropertyRowFilterGets or sets the row filter for the sheet.  
    Public PropertyRowHeaderGets the RowHeader object for the row header area of the sheet.  
    Public PropertyRowHeaderAutoTextGets or sets whether row headers on this sheet display letters or numbers or are blank.  
    Public PropertyRowHeaderAutoTextIndexGets or sets which row header column on this sheet displays the automatic text when there are multiple row header columns.  
    Public PropertyRowHeaderColumnCountGets or sets the number of columns in the row header on this sheet.  
    Public PropertyRowHeaderHorizontalGridLineGets or sets the horizontal grid line in the row header on this sheet.  
    Public PropertyRowHeaderSelectorIndexGets or sets which row header column in the sheet displays the row selector when there are multiple row header columns.  
    Public PropertyRowHeaderVerticalGridLineGets or sets the vertical grid line in the row header on this sheet.  
    Public PropertyRowHeaderVisibleGets or sets whether the row headers for this sheet are visible.  
    Public PropertyRowsGets a Rows object for the rows in the data area of the sheet.  
    Public PropertySaveNamedStylesInternal use only.  
    Public PropertyScrollingContentInfoGets or sets the information of the vertical scrolling tip for the sheet.  
    Public PropertySelectionBackColorGets or sets the background color of selections on this sheet.  
    Public PropertySelectionCountGets the number of selections on this sheet.  
    Public PropertySelectionFontGets or sets the default font for selected items on this sheet.  
    Public PropertySelectionForeColorGets or sets the foreground color of selections on this sheet.  
    Public PropertySelectionPolicyGets the selection policy for the sheet for normal operation mode.  
    Public PropertySelectionStyleGets or sets how selections on this sheet are drawn.  
    Public PropertySelectionUnitGets or sets the smallest unit users or the application can select on this sheet.  
    Public PropertySerializeModelsGets or sets whether the DocumentModels for this sheet should be serialized to the form resources, rather than generating code that initializes the Cells, Columns, Rows, and AlternatingRows.  
    Public PropertySheetCornerGets the sheet corner of the sheet.  
    Public PropertySheetCornerHorizontalGridLineGets or sets the horizontal grid line for the sheet corner.  
    Public PropertySheetCornerStyleGets or sets the style information for the sheet corner.  
    Public PropertySheetCornerStyleNameGets or sets the name of the style for the sheet corner.  
    Public PropertySheetCornerVerticalGridLineGets or sets the vertical grid line for the sheet corner.  
    Public PropertySheetNameGets or sets the name of the sheet.  
    Public PropertyShowEditingRowSelectorGets or sets a value that indicates whether to display a row selector in the editing row header of the selected row for the sheet.  
    Public PropertyShowIndicatorIndexes  
    Public PropertyShowRowSelectorGets or sets a value that indicates whether to display a row selector in the row header of the selected row for the sheet.  
    Public PropertySiteOverridden. Gets or sets the site.  
    Public PropertySparklineContainerGets or sets a sparkline container for the sheet for maintaining sparklines.  
    Public PropertyStartingColumnNumberGets or sets the number or letter displayed in the first column header on this sheet.  
    Public PropertyStartingRowNumberGets or sets the number or letter displayed in the first row header on this sheet.  
    Public PropertyStopUpdatingChartDataSource  
    Public PropertyTagGets or sets an application-defined tag value associated with the cells in this sheet.  
    Public PropertyTitleInfoSheet title  
    Public PropertyValidationsGets the object which manages all DataValidtions.  
    Public PropertyVerticalGridLineGets or sets the vertical grid line on this sheet.  
    Public PropertyViewGet or set the view type of a SheetView.  
    Public PropertyVisibleGets or sets whether to display the sheet.  
    Public PropertyVisualStylesGets or sets whether to use visual styles when rendering objects in the sheet.  
    Public PropertyZoomFactorGets or sets the scaling factor for displaying this sheet.  
    Top
    Protected Properties
     NameDescription
    Protected PropertyCanRaiseEvents (Inherited from System.ComponentModel.Component)
    Protected PropertyEvents (Inherited from System.ComponentModel.Component)
    Protected PropertyIgnoreApplySpreadSkinGets or sets a value that indicates whether to ignore applying Spread skin.  
    Protected PropertyIsInitializingGets a value that indicates whether SheetView is initialized.  
    Top
    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 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 specified style.  
    Public MethodAddUnboundRowsAdds unbound rows to the data model for a sheet.  
    Public MethodAddValidation  
    Public MethodAddValidatorsOverloaded. Adds validators to a cell range.  
    Public MethodAsWorksheetGets the coressponding GrapeCity.Spreadsheet.IWorksheet object that allows accessing to new object model and API set.  
    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 MethodClearValidatorsClears validators.  
    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 sheet.  
    Public MethodClipboardPasteShapeOverloaded. Pastes the shape from the Clipboard.  
    Public MethodCloneCreates a copy of the sheet.  
    Public MethodContainMultiCellsArrayFormulaChecks whether a specified range contains multi-cells array formula  
    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 MethodCopyScTableStyleToCopy SC's tablestyle of this SheetView to target SheetView. Intended to be use when creata a new SheetView from another SheetView in designer only Internal use only.  
    Public MethodCreateObjRef (Inherited from System.MarshalByRefObject)
    Public MethodDisposeOverloaded. Overridden. Cleans up any resources being used.  
    Public MethodEvaluateExpressionOverloaded. Evaluates the expression and returns the resulting object for the cell at the specified row and column.  
    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 MethodFireRemovedFromSpread  
    Public MethodGetAllFormulaArrayGets all formula array. Internal use only.  
    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 MethodGetCellNoteInternalInternal use only. Gets the cell note object of a specified cell on this sheet.  
    Public MethodGetCellTypeGets the CellType.  
    Public MethodGetChartGet chart at index.  
    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 MethodGetCompositedStylePropertiesGets composited style and return its properties. Support feature exporting to html  
    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 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 MethodGetDropDownFilterItemsGets the filter items to be displayed in the drop-down list for the specified column.  
    Public MethodGetEditorGets the editor used to edit a specified cell on this sheet.  
    Public MethodGetExcelSheetNames  
    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 MethodGetFormulaArrayGets the formula array at the specified row and column index. Internal use only.  
    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 MethodGetLifetimeService (Inherited from System.MarshalByRefObject)
    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 of a specified cell on this sheet.  
    Public MethodGetNoteBoundsGets the rectangle for the cell note for the specified cell if its NoteStyle is StickyNote.  
    Public MethodGetNoteColumnIndex  
    Public MethodGetNoteRowIndex  
    Public MethodGetNoteStyleGets the composited style of notes of a specified cell on this sheet.  
    Public MethodGetNoteZoomFactor  
    Public MethodGetObjectDataSerializes the object to the SerializationInfo object.  
    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 by name.  
    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 MethodGetValidatorsGets validators which associates to the specified cell range.  
    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 MethodInitializeLifetimeService (Inherited from System.MarshalByRefObject)
    Public MethodInternalShouldSerializeAutoSortColumns  
    Public MethodInvalidateRowFilterResets all the temporary filter settings and filters the rows again based on the filter settings of each column. (Internal use only.)  
    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 MethodLoadExpressionECFReload the expressions of all Conditional Formatting in current sheet, when we have fully data.  
    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 MethodOnDataModelChangedChanges the data model for this sheet in synchronization with the data source.  
    Public MethodOnSheetColumnAxisModelChangedChanges the sheet column axis model in synchronization with the data source.  
    Public MethodOnSheetRangeGroupModelChangedChanges the sheet row axis model in synchronization with the data source.  
    Public MethodOnSheetRowAxisModelChangedChanges the sheet row axis model in synchronization with the data source.  
    Public MethodOnSpanModelChangedChanges the span model in sync with the data source for this sheet.  
    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 MethodResetFilteredColumnInternal Use: Resets the display of rows based on the "(All)" filter item in the drop-down list. (Internal use only.)  
    Public MethodResumeAutoUpdateChartDataResumes updates of values to the chart immediately.  
    Public MethodResumeFormulaParsingResumes parsing of formulas and parses all formulas set while parsing was suspended.  
    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 on this sheet should display 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 MethodSetErrorValueSets the value for the specified cell on this sheet.  
    Public MethodSetFilteredColumnOverloaded. Internal Use: Applies the row filtering to the specified column when the specified filter item is selected from the drop-down list. (Internal use only.)  
    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 MethodShouldSerializeHorizontalGridLineGets whether the horizontal grid line for the data area should be serialized.  
    Public MethodShouldSerializeIsBackgroundImageTiledGets whether the tiled background image should be serialized.  
    Public MethodShouldSerializeModelsGets whether the document models for the sheet should be persisted.  
    Public MethodShouldSerializeNamedStylesInternal use only.  
    Public MethodShouldSerializeSheetCornerHorizontalGridLineGets whether the horizontal grid line for the corner should be serialized.  
    Public MethodShouldSerializeSheetCornerVerticalGridLineGets whether the vertical grid line for the corner should be serialized.  
    Public MethodShouldSerializeVerticalGridLineGets whether the vertical grid line for the data area should be serialized.  
    Public MethodShouldSerializeZoomFactorGets whether the zoom factor should be serialized.  
    Public MethodShowNotesShows or hides all cell notes on the sheet.  
    Public MethodSortColumnsOverloaded. Sorts all the columns on the sheet by the specified row.  
    Public MethodSortRangeSorts a range of cells on this sheet in the data model.  
    Public MethodSortRowsOverloaded. Sorts all the rows on this sheet by the specified column.  
    Public MethodSuspendAutoUpdateChartDataSuspends updates of values to the chart immediately.  
    Public MethodSuspendFormulaParsingSuspends parsing of formulas.  
    Public MethodSwapRangeSwaps the data and formatting in a block of cells on this sheet with another block of cells on this sheet.  
    Public MethodToString (Inherited from System.ComponentModel.Component)
    Public MethodUngroupSparklineOverloaded. Ungroups the sparkline.  
    Public MethodUpdateChartOnLayoutChanged  
    Public MethodUpdateNotesOverloaded. Updates cell note appearances based on style being set or on changes to note text.  
    Public MethodValidateValidates a cell.  
    Top
    Protected Methods
     NameDescription
    Protected MethodFinalizeOverridden. The destructor method  
    Protected MethodGetColumnVisibleCountGets the number of the visible columns.  
    Protected MethodGetRowVisibleCountGets the number of the visible rows.  
    Protected MethodGetService (Inherited from System.ComponentModel.Component)
    Protected MethodInitPropArrayProperty names.  
    Protected MethodMemberwiseCloneOverloaded.  (Inherited from System.MarshalByRefObject)
    Protected MethodOnAddColumnFooterRowsOccurs when footer rows are added.  
    Protected MethodOnAddColumnHeaderRowsOccurs when column header rows are added.  
    Protected MethodOnAddColumnsOccurs when columns are added.  
    Protected MethodOnAddRowHeaderColumnsOccurs when row header columns are added.  
    Protected MethodOnAddRowsOccurs when rows are added.  
    Protected MethodOnCellChangedOccurs when the cell is changed.  
    Protected MethodOnCopyCellsOccurs when the cells are copied.  
    Protected MethodOnCopyColumnsOccurs when the columns are copied.  
    Protected MethodOnCopyRowsOccurs when rows are copied.  
    Protected MethodOnDisposingRaises the Disposing event  
    Protected MethodOnMoveCellsOccurs when the cells are moved.  
    Protected MethodOnMoveColumnsOccurs when columns are moved.  
    Protected MethodOnMoveRowsOccurs when rows are moved.  
    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 MethodOnRemoveColumnHeaderRowsOccurs when column header rows are removed.  
    Protected MethodOnRemoveColumnsOccurs when columns are removed.  
    Protected MethodOnRemoveRowHeaderColumnsOccurs when row header columns are removed.  
    Protected MethodOnRemoveRowsOccurs when rows are removed.  
    Protected MethodOnStickyNoteCreatedObsolete. Use OnNoteCreated(object sender, EventArgs e) instead. Occurs when a note is created in the sheet's notes container.  
    Protected MethodOnStickyNoteMovedObsolete. Use OnNoteMoved(object sender, EventArgs e) instead. Occurs when a note is moved in the sheet's notes container.  
    Protected MethodOnStickyNoteSizedObsolete. Use OnNoteSized(object sender, EventArgs e) instead. Occurs when a note is sized in the sheet's notes container.  
    Protected MethodOnStyleModelChangedOccurs when the style model is changed.  
    Protected MethodOnSwapCellsOccurs when the cells are swapped.  
    Protected MethodOnSwapColumnsOccurs when columns are swapped.  
    Protected MethodOnSwapRowsOccurs when rows are swapped.  
    Protected MethodShouldSerializeAlternatingRowsDetermines whether the alternating rows should be serialized.  
    Protected MethodShouldSerializeCellsDetermines whether the cells should be serialized.  
    Protected MethodShouldSerializeColumnFooterSheetCornerStyleGets whether the style for the sheet corner should be serialized.  
    Protected MethodShouldSerializeColumnsDetermines whether the columns should be serialized.  
    Protected MethodShouldSerializeDefaultStyleGets whether the DefaultStyle property should be serialized.  
    Protected MethodShouldSerializeFilterBarHeaderStyleGets whether the style for the filter bar header should be serialized.  
    Protected MethodShouldSerializeGrayAreaBackColorGets whether the GrayAreaBackColor property 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 MethodShouldSerializePrintInfoDetermines whether print information should be serialized.  
    Protected MethodShouldSerializeRowsDetermines whether the rows should be serialized.  
    Protected MethodShouldSerializeSaveNamedStylesDetermines whether the named styles should be serialized.  
    Protected MethodShouldSerializeSelectionBackColorDetermines whether selection background color should be serialized.  
    Protected MethodShouldSerializeSelectionFontDetermines whether selection font should be serialized.  
    Protected MethodShouldSerializeSelectionForeColorDetermines whether selection text color should be serialized.  
    Protected MethodShouldSerializeSheetCornerStyleGets whether the style for the sheet corner should be serialized.  
    Top
    Public Events
     NameDescription
    Public EventCellChangedOccurs when a change is made to a cell or range of cells on this sheet that may require the cell or range of cells be repainted.  
    Public EventChangedOccurs when a change is made to the sheet that may require the entire sheet to be repainted (as with DefaultStyle or AlternatingRows).  
    Public EventColumnChangedOccurs when a change is made to a column or range of columns that may require the column or range of columns be repainted.  
    Public EventDisposed (Inherited from System.ComponentModel.Component)
    Public EventDisposingFires when the SheetView is being disposed.  
    Public EventNoteCreatedOccurs when a note for the viewport area is created on the sheet.  
    Public EventNoteMovedOccurs when a note for the viewport area is moved on the sheet.  
    Public EventNoteSizedOccurs when a note for the viewport area is sized on the sheet.  
    Public EventPropertyChangedOccurs when the user changes a property of the sheet.  
    Public EventReferenceStyleChangedOccurs when the reference style changes.  
    Public EventRowChangedOccurs when a change is made to a row or range of rows on this sheet that may require the row or range of rows be repainted.  
    Public EventStickyNoteCreatedObsolete. Use NoteCreated instead. Occurs when a sticky note is created on the sheet.  
    Public EventStickyNoteMovedObsolete. Use NoteMoved instead. Occurs when a sticky note is moved on the sheet.  
    Public EventStickyNoteSizedObsolete. Use NoteSized instead. Occurs when a sticky note is sized on the sheet.  
    Top
    See Also

    Reference

    SheetView Class
    FarPoint.Win.Spread Namespace

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page