»Spread for ASP.NET  » Product Tour  » Summary Aggregation jump to:

Summary Aggregation

You can show a column footer or a group footer or both for the sheet and put information in the footer such as formulas or text. The column footer is an area at the bottom of the sheet. The group footer is an extra row of footer cells at the bottom of a sheet with grouping, if you are using the grouping feature.

In order to calculate the column footer or group footer result with a formula, set the AggregationType property of the Column object to the correct formula type for that column.

 ABCDEFGHIJKLM
10123456789101112
213141516171819202122232425
326272829303132333435363738
439404142434445464748495051
552535455565758596061626364
665666768697071727374757677
778798081828384858687888990
 
AverageCountCountAMaxMinProductS.D.S.D.PSumVarianceVarPCustomNone
397781440654429200
28.08
26Sum:[329]
78866.67%
67637.2~10.1