Spread Windows Forms 7.0 Product Documentation
GetAggregationResult Method
See Also  Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : GetAggregationResult Method


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

Glossary Item Box

Calculates the value based on the aggregation type and formats the value with the aggregation format.

Syntax

Visual Basic (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
Visual Basic (Usage)Copy Code
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)
C# 
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

Requirements

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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.