Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / GetAggregationResult Method
Row index
Column index
Number of rows
Number of columns
Aggregation type
Aggregation formula


In This Topic
    GetAggregationResult Method (DefaultSheetDataModel)
    In This Topic
    Calculates the value based on the aggregation type and formats the value with the aggregation format.
    Syntax
    'Declaration
     
    
    Public Function GetAggregationResult( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal aggType As AggregationType, _
       ByVal aggformula As String _
    ) As Object
    'Usage
     
    
    Dim instance As DefaultSheetDataModel
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim aggType As AggregationType
    Dim aggformula As String
    Dim value As Object
     
    value = instance.GetAggregationResult(row, column, rowCount, columnCount, aggType, aggformula)

    Parameters

    row
    Row index
    column
    Column index
    rowCount
    Number of rows
    columnCount
    Number of columns
    aggType
    Aggregation type
    aggformula
    Aggregation formula

    Return Value

    The calculated value in form of the aggregation format
    See Also