TableColumn Class
Represents a single column inside a Table.
Inheritance
Object
Documents.Spreadsheet.TableColumn
Namespace: Radzen.Documents.Spreadsheet
Assembly: Radzen.Blazor.dll
Syntax
public class TableColumnProperties
Formulalink
Calculated-column formula. Setting this populates every data row in this column. Use Excel structured-reference syntax ([@[Q1]]) or plain cell references.
Declaration
public string Formula { get; set; }Property Value
| Type | Description |
|---|---|
| string | Calculated-column formula. Setting this populates every data row in this column. Use Excel structured-reference syntax ([@[Q1]]) or plain cell references. |
Indexlink
Position of the column inside the table (zero-based).
Declaration
public int Index { get; }Property Value
| Type | Description |
|---|---|
| int | Position of the column inside the table (zero-based). |
Namelink
Column name. Defaults to the header cell's value when ShowHeaderRow is true, otherwise Column1, Column2, ...
Declaration
public string Name { get; set; }Property Value
| Type | Description |
|---|---|
| string | Column name. Defaults to the header cell's value when ShowHeaderRow is true, otherwise Column1, Column2, ... |
Rangelink
The data-body range of this column (excludes header and totals rows).
Declaration
public Documents.Spreadsheet.RangeRef Range { get; }Property Value
| Type | Description |
|---|---|
| Documents.Spreadsheet.RangeRef | The data-body range of this column (excludes header and totals rows). |
Tablelink
The owning table.
Declaration
public Documents.Spreadsheet.Table Table { get; }Property Value
| Type | Description |
|---|---|
| Documents.Spreadsheet.Table | The owning table. |
TotalsCalculationlink
Aggregation displayed in this column's totals-row cell.
Declaration
public Documents.Spreadsheet.TotalsCalculation TotalsCalculation { get; set; }Property Value
| Type | Description |
|---|---|
| Documents.Spreadsheet.TotalsCalculation | Aggregation displayed in this column's totals-row cell. |
TotalsCelllink
The totals cell for this column, or null when the totals row is hidden.
Declaration
public Documents.Spreadsheet.CellRef? TotalsCell { get; }Property Value
| Type | Description |
|---|---|
| Documents.Spreadsheet.CellRef? | The totals cell for this column, or null when the totals row is hidden. |