Back to Devexpress

TableColumn Members

officefileapi-devexpress-dot-spreadsheet-dot-tablecolumn-dot-underscore-members.md

latest2.3 KB
Original Source

TableColumn Members

A single column in a table.

Properties

NameDescription
ArrayFormulaGets or sets the array formula applied to all cells in the table column.
DataRangeReturns the cell range that contains column data (without the column header and total cell).
FormulaGets or sets the formula applied to all cells in the table column.
IndexGet the zero-based index of the column within the table’s TableColumnCollection.
NameGets or sets the name of the table column.
RangeReturns the cell range that contains the entire table column.
TotalReturns the cell that contains the column total.
TotalRowArrayFormulaSpecifies an array formula to calculate the column total.
TotalRowFormulaSpecifies a formula to calculate the column total.
TotalRowFunctionSpecifies a predefined function to calculate the column total.
TotalRowLabelSpecifies text displayed in the total cell of the table column.

Methods

NameDescription
Delete()Deletes a column from a table.

See Also

TableColumn Interface

DevExpress.Spreadsheet Namespace