Spread for ASP.NET 12 Product Documentation
GetAggregationResult Method (DefaultSheetDataModel)


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
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)
public object GetAggregationResult( 
   int row,
   int column,
   int rowCount,
   int columnCount,
   AggregationType aggType,
   string 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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members