TotalsCalculation
Overview
TotalsCalculation is a enum in Aspose.Cells FOSS for Java.
Aggregation function applied to a table’s totals row.
This enumeration defines 10 values: NONE, SUM, COUNT, AVERAGE, MAX, MIN, STD_DEV, VAR, COUNT_NUMS, CUSTOM.
Description
TotalsCalculation is an enumeration type in the Aspose.Cells FOSS library for Java. It defines a set of named constants that control behavior or specify options within the API. Enumerations like TotalsCalculation help ensure type safety by restricting values to a predefined set.
Values
| Value | Description |
|---|---|
NONE | No totals row calculation. |
SUM | Calculates the sum of values in the column. |
COUNT | Counts the number of non-empty cells in the column. |
AVERAGE | Calculates the average of values in the column. |
MAX | Returns the maximum value in the column. |
MIN | Returns the minimum value in the column. |
STD_DEV | Calculates the standard deviation of values in the column. |
VAR | Calculates the variance of values in the column. |
COUNT_NUMS | Counts the number of numeric cells in the column. |
CUSTOM | Uses a custom formula for the totals row. |