|
»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.
|
|
| | A | B | C | D | E | F | G | H | I | J | K | L | M |
| 1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 2 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 3 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 |
| 4 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 |
| 5 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 |
| 6 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 |
| 7 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 |
| Average | Count | CountA | Max | Min | Product | S.D. | S.D.P | Sum | Variance | VarP | Custom | None |
| 39 | 7 | 7 | 81 | 4 | 40654429200 | 28.08 | 26 | Sum:[329] | 78866.67% | 676 | 37.2~10.1 |
|
|