TableColumn.TotalRowArrayFormula Property

Specifies an array formula to calculate the column total.

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp

string TotalRowArrayFormula { get; set; }

Property TotalRowArrayFormula As String

Type	Description
String

A string that is the array formula.

You can specify how to calculate a total for each column in the table. To do this, use the following properties.

TableColumn.TotalRowFunction - allows you to select one of the predefined functions to calculate the column total.
TableColumn.TotalRowFormula - allows you to specify any formula to calculate the column total.
TableColumn.TotalRowArrayFormula - allows you to specify an array formula to calculate the column total.
TableColumn.TotalRowLabel - allows you to specify the text to be displayed in the total cell of the table column.

Use the Table.ShowTotals property to control the visibility of the table total row.