TableColumn.TotalRowArrayFormula Property

Gets or sets the array formula to calculate the total of the table column.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

string TotalRowArrayFormula { get; set; }

VB.NET

Property TotalRowArrayFormula As String

Property Value

Type	Description
String	A string that is the array formula.

Remarks

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.