GrapeCity.Documents.Excel.ITableColumn.TotalsCalculation

TotalsCalculation Property

TotalsCalculation

Gets the calculation type used in the Totals row of this table column.

The returned TotalsCalculation value determines how the totals cell for the column is calculated when the table shows a totals row.

Declaration

TotalsCalculation TotalsCalculation { get; set; }

Property TotalsCalculation As TotalsCalculation

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Product", "Amount"},
    {"Apple", 100},
    {"Pear", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
table.ShowTotals = true;
table.Columns[1].TotalsCalculation = TotalsCalculation.Sum;
TotalsCalculation calculation = table.Columns[1].TotalsCalculation;