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
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. |