Spread Windows Forms 6.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 value based on aggregation type and forms value with 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 aggregation format

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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