TTableColumnDefinition Structure

Contains the definition for a column in an Excel table. This is mostly useful if the table doesn't have headers; since when the table has headers, the columns are inferred from the cells where the header is.

Syntax

Namespace: FlexCel.Core

public struct TTableColumnDefinition

Constructors

Name	Description
TTableColumnDefinition	Overloaded TTableColumnDefinition(String, Int32) TTableColumnDefinition(String, Int32, Nullable<TTableFormula>, Nullable<TTableFormula>, String, String, String, TTotalsRowFunction, String)

Methods

Name	Description
GetHashCode	Hashcode for the column.
Equals	Returns true if obj has the same data as this instance.

Operators

Name	Description
Equality	Returns true if both objects have the same data.
Inequality	Returns true if both objects have different data.

Properties

Name	Description
Name	Name of the column. Note that when the table has a header row, the names will be read from the cells where the column is, not from this name. This property is mostly useful if the table doesn't have headers.
Id	Unique id that identifies this column. It should not change when the column name changes or the column moves its position.
CalculatedColumnFormula	Stores the formula that is used to perform the calculation for each cell in this column. Note that the column can have different formulas from this one, but this is normally not the case. This formula is also used by Excel to automatically add new formulas when you add new rows to the table. FlexCel doesn't automatically adds this formula to the new rows, you need to set the cells to the formula manually if you want to.
TotalsRowFormula	A custom formula for aggregating values from the column. This formula is only used if TotalsRowFunction is set to "Custom". Additionally, FlexCel will ignore this value when adding a table with totals and read the formula from the cell itself. If the table doesn't have a total row, then this value will be used.
DataCellStyle	Style for the cells in the column, if they don't have a given cell style. This property has more priority than the table cell style, but less than the cell style. This value is used when adding a new empty row as a default for the column.
HeaderRowCellStyle	Style for the header row cell in the column, if it doesn't have a given cell style. This property has more priority than the table header row cell style, but less than the cell style. FlexCel will ignore this value when adding a table and read the style from the cell itself.
TotalsRowCellStyle	Style for the totals row cell in the column, if it doesn't have a given cell style. This property has more priority than the table totals row cell style, but less than the cell style. FlexCel will ignore this value when adding a table with totals and read the formula from the cell itself. If the table doesn't have a total row, then this value will be used.
TotalsRowFunction	An enumeration that specifies what function is used to aggregate the data in a column. When set to custom, the value in TotalsRowFormula is used instead. Additionally, FlexCel will ignore this value when adding a table with totals and read the formula from the cell itself. If the table doesn't have a total row, then this value will be used.
TotalsRowLabel	A String to show in the totals row cell for this column. This is ignored unless TotalsRowFunction is none. Additionally, FlexCel will ignore this value when adding a table with totals and read the formula from the cell itself. If the table doesn't have a total row, then this value will be used.