Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Table Class
Properties Methods


In This Topic
    Table Class Members
    In This Topic

    The following tables list the members exposed by Table.

    Public Properties
     NameDescription
    Public PropertyActiveGets a value indicating whether the active cell of worksheet is inside the range of this Table object.  
    Public PropertyAutoFilterGets the filter of this Table.  
    Public PropertyAutoGenerateColumnsGets or sets whether to generate the columns automatically based on the data source.  
    Public PropertyBorderFormattingGets the table border format.  
    Public PropertyCommentGets or sets the comment associated with the Table object.  
    Public PropertyDataAllowAddNewGets or sets whether to allow the user to add a new row when the table is bound.  
    Public PropertyDataRowGets the worksheet index of the table data's top row.  
    Public PropertyDataRow2Gets the worksheet index of the table data's bottom row.  
    Public PropertyDataRowFormattingGets the data row format.  
    Public PropertyDataSourceGets or sets the data source that populates the table.  
    Public PropertyHeaderRowBorderFormattingGets the header row border format.  
    Public PropertyHeaderRowFormattingGets the header row format.  
    Public PropertyItemGets the TableColumn at the specified column index.  
    Public PropertyNameGets the name of Table object.  
    Public PropertyRangeGets the range reference of this Table.  
    Public PropertyShowAutoFilterDropDownGets or sets a value indicating whether the filter button in the header row of each column is displayed.  
    Public PropertyShowHeadersGets or sets a value indicating whether the header row is visible.  
    Public PropertyShowTotalsGets or sets a value indicating whether the total row is visible.  
    Public PropertySortGets the sort object.  
    Public PropertyTableStyleGets the TableStyle indicates which style will be applied to this Table.  
    Public PropertyTableStyleSettingGets or sets the TableStyleSetting value indicates which style will be applied.  
    Public PropertyTotalsRowBorderFormattingGets the totals row border format.  
    Public PropertyTotalsRowFormattingGets the totals row format.  
    Top
    Public Methods
     NameDescription
    Public MethodApplyTableStyleOverloaded. Applies the specified table style to this Table.  
    Public MethodCreateFormulaGets the formula that represents the specified area in the table.  
    Public MethodEqualsOverloaded. Indicates whether the current object is equal to another object of the same type.  
    Public MethodGetColumnFormulaGets the formula of the specified calculated column.  
    Public MethodGetColumnIdGets the relative column index of the specified column.  
    Public MethodGetStyleFormatGets the style format of the specified cell on this table.  
    Public MethodGetTableExpressionGet table Formula from structuredItemSpecifiers and column index.  
    Public MethodInsertColumnsInserts table column(s) at the specified index.  
    Public MethodInsertRowsInserts table row(s) at the specified index.  
    Public MethodIsBindingGets a boolean value indicating whether the table is binding to a data source.  
    Public MethodMoveColumnsMoves table column(s) at the specified index to other index.  
    Public MethodMoveRowsMoves table row(s) at the specified index to other index.  
    Public MethodRemoveColumnsRemoves table column(s) at the specified index.  
    Public MethodRemoveRowsRemoves table row(s) at the specified index.  
    Public MethodResizeResizes the boundary of this table over a new range. No cells are inserted or moved.  
    Public MethodSetColumnFormulaSets the calculated column's formula.  
    Public MethodSetColumnNameSets the name of the column.  
    Public MethodSetDataRowStyleOverloaded. Sets the name of the cell style that is applied to the data row cell of the specified column.  
    Public MethodSetHeaderRowStyleOverloaded. Sets the name of the cell style that is applied to the header row cell of the specified column.  
    Public MethodSetTotalsRowFormulaOverloaded. Sets the totals row formula.  
    Public MethodSetTotalsRowLabelSets the totals row label.  
    Public MethodSetTotalsRowStyleOverloaded. Sets the name of the cell style that is applied to the totals row cell of the specified column.  
    Public MethodToggleHeadersToggles the headers row's visibility.  
    Public MethodToggleTotalsToggles the totals row's visibility.  
    Public MethodToString  
    Top
    Protected Methods
     NameDescription
    Protected MethodOnAutoFilterDeletedOccurs after the auto filter is deleted;  
    Top
    See Also

    Reference

    Table Class
    GrapeCity.Spreadsheet Namespace