Spread Windows Forms 10.0 Product Documentation
AggregationType Enumeration
Example Example 


Specifies the type of aggregation on ranges of cells.
Syntax
'Declaration
 
Public Enum AggregationType 
   Inherits System.Enum
'Usage
 
Dim instance As AggregationType
public enum AggregationType : System.Enum 
Members
MemberDescription
AvgReturns the average of cells in a range.
AvgIgnoreHiddenReturns the average of cells (ignores hidden values) in a range.
CountCounts the number of cells in a range that contain numbers.
CountACounts the number of cells in a range that are not empty.
CountAIgnoreHiddenCounts the number of cells (ignores hidden values) in a range that are not empty.
CountIgnoreHiddenCounts the number of cells (ignores hidden values) in a range that contain numbers.
CustomSpecifies custom aggregation.
MaxReturns the maximum value of cells in a range.
MaxIgnoreHiddenReturns the maximum value of cells (ignores hidden values) in a range.
MinIndicates the row count of the cells in the specified range of cells.
MinIgnoreHiddenIndicates the row count of the cells (ignores hidden values) in the specified range of cells.
NoneIndicates that aggregation for the sheet is not supported.
ProductMultiplies all the cells in a range and returns the product.
ProductIgnoreHiddenMultiplies all the cells (ignores hidden values) in a range and returns the product.
StDevReturns the standard deviation for a set of cells in a range.
StDevIgnoreHiddenReturns the standard deviation for a set of cells (ignores hidden values) in a range.
StDevPCalculates standard deviation based on the entire population given as cells in a range.
StDevPIgnoreHiddenCalculates standard deviation based on the entire population given as cells (ignores hidden values) in a range.
SumSums values of cells in a range.
SumIgnoreHiddenSums values of cells (ignores hidden values) in a range.
VarCalculates variance based on a sample of a population.
VarIgnoreHiddenCalculates variance based on a sample (ignores hidden values) of a population.
VarPCalculates variance based on the entire population.
VarPIgnoreHiddenCalculates variance based on the entire population (ignores hidden values).
Remarks
AggregationType Function Code (Include Hidden Values) AggregationType Function Code (Ignore Hidden Values)
Avg 1 AvgIgnoreHidden 101
Count 2 CountIgnoreHidden 102
CountA 3 CountAIgnoreHidden 103
Max 4 MaxIgnoreHidden 104
Min 5 MinIgnoreHidden 105
Product 6 ProductIgnoreHidden 106
StDev 7 StDevIgnoreHidden 107
StDevP 8 StDevPIgnoreHidden 108
Sum 9 SumIgnoreHidden 109
Var 10 VarIgnoreHidden 110
VarP 11 VarPIgnoreHidden 111
Example

This example sets the AggregationType.

fpSpread1.Sheets[0].RowCount=8;
fpSpread1.Sheets[0].ColumnCount = 15;
fpSpread1.Sheets[0].GroupBarInfo.Visible = true;
fpSpread1.Sheets[0].AllowGroup = true;
fpSpread1.Sheets[0].GroupFooterVisible = true;
fpSpread1.Sheets[0].ColumnFooter.Visible = true;
fpSpread1.Sheets[0].ColumnFooter.RowCount = 2;
fpSpread1.Sheets[0].ColumnFooter.Columns[12].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left;
fpSpread1.Sheets[0].ColumnFooter.Cells[0, 12].RowSpan = 2; 
//Value
for (int r = 0; r < fpSpread1.Sheets[0].RowCount; r++)
{
        for (int j = 0; j < fpSpread1.Sheets[0].ColumnCount; j++)
    {
        fpSpread1.Sheets[0].Models.Data.SetValue(r, j, j + r * fpSpread1.Sheets[0].ColumnCount); 
    }
}
int i=0;
fpSpread1.Sheets[0].ColumnFooter.SetAggregationFormat(0, 1, "Sum:{0}");
fpSpread1.Sheets[0].ColumnFooter.SetAggregationType(0,1, FarPoint.Win.Spread.Model.AggregationType.Sum); 
fpSpread1.Sheets[0].Models.ColumnFooterRowAxis.SetResizable(1, true);
fpSpread1.Sheets[0].ColumnFooter.Cells[0, i].Value = "Sum"; 

private void fpSpread1_Grouped(object sender, EventArgs e)
 {
  FarPoint.Win.Spread.Model.GroupDataModel gdm;
  gdm = (FarPoint.Win.Spread.Model.GroupDataModel)fpSpread1.ActiveSheet.Models.Data;
  gdm.GroupFooterVisible = true;
  FarPoint.Win.Spread.Model.Group g1 = (FarPoint.Win.Spread.Model.Group)gdm.Groups[1];           
  ((FarPoint.Win.Spread.Model.IAggregationSupport)g1.GroupFooter.DataModel).SetCellAggregationType(0, 0, FarPoint.Win.Spread.Model.AggregationType.Sum);
((FarPoint.Win.Spread.Model.IAggregationSupport)g1.GroupFooter.DataModel).SetCellAggregationFormat(0, 0, "Sum: {0}");
  fpSpread1.ActiveSheet.Models.Data = gdm;
  }
FpSpread1.Sheets(0).RowCount = 8
FpSpread1.Sheets(0).ColumnCount = 15
FpSpread1.Sheets(0).GroupBarInfo.Visible = True
FpSpread1.Sheets(0).AllowGroup = True
FpSpread1.Sheets(0).GroupFooterVisible = True
FpSpread1.Sheets(0).ColumnFooter.Visible = True
FpSpread1.Sheets(0).ColumnFooter.RowCount = 2
fpSpread1.Sheets(0).ColumnFooter.Columns(12).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Left
'Value
        Dim r As Integer
        Dim j As Integer
        For r = 0 To FpSpread1.Sheets(0).RowCount
            For j = 0 To FpSpread1.Sheets(0).ColumnCount
                FpSpread1.Sheets(0).Models.Data.SetValue(r, j, j + r * FpSpread1.Sheets(0).ColumnCount)
            Next j
        Next r
        Dim i As Integer
        i = 0
FpSpread1.Sheets(0).ColumnFooter.SetAggregationFormat(0, 1, "Sum:{0}")
FpSpread1.Sheets(0).ColumnFooter.SetAggregationType(0, 1, FarPoint.Win.Spread.Model.AggregationType.Sum)
FpSpread1.Sheets(0).Models.ColumnFooterRowAxis.SetResizable(1, True)
FpSpread1.Sheets(0).ColumnFooter.Cells(0, i).Value = "Sum"

Private Sub FpSpread1_Grouped(ByVal sender As Object, ByVal e As System.EventArgs) Handles FpSpread1.Grouped
        Dim gdm As FarPoint.Win.Spread.Model.GroupDataModel
        Dim g1 As FarPoint.Win.Spread.Model.Group
        gdm = FpSpread1.Sheets(0).Models.Data
        gdm.GroupFooterVisible = True
        g1 = gdm.Groups(1)
        CType(g1.GroupFooter.DataModel, FarPoint.Win.Spread.Model.IAggregationSupport).SetCellAggregationType(0, 0, FarPoint.Win.Spread.Model.AggregationType.Sum)
CType(g1.GroupFooter.DataModel, FarPoint.Win.Spread.Model.IAggregationSupport).SetCellAggregationFormat(0, 0, "Sum: {0}")
        FpSpread1.ActiveSheet.Models.Data = gdm
    End Sub
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.Model.AggregationType

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FarPoint.Win.Spread.Model Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.