Replied 8 September 2017, 2:50 pm EST

Hello,

Summary rows basically refer to a row in the same grid that holds the results for the various aggregation formulas applied to different columns in the grid. Spread also has the feature of setting various formulas in the column footer that provides different aggregation of the values in the column like sum or average of all the values in a column.

When we set the formulas in a Column Footer, then these formulas are

simply meant to provide an aggregation for all the values in the Column.

The aggregation can be of different types like sum of all the values in

a column, average of all the values in a Column, maximum and minimum

value in a column and more. The SetAggregationType method is used to set

the formulas in a column footer. It has three parameters. First and the

second one specify the row index and column index in the Column Footer

to which the formula is to be applied. Since a column footer can have

multiple rows so you need to specify the row index and column index

specifies to which column are we actually applying the formula. The last

parameter is an enum value where the enum contains all the different

aggregation formulas that can be applied in a column footer. So, the row

index and column index specify the cell in the Column Footer to which

the formula is applied and the enum value tells which formula is

applied.

I am attaching a sample which depicts how you can use

SetAggregationType method to calculate the sum of a column, average of a

column and maximum value in a column, kindly have a look at the same.

Hope it will help you. Please let me know if you have any queries

further.

Thanks,

Manpreet Kaur

2011/12/ColumFooterFormula.zip