Spread for ASP.NET 7.0 Product Documentation
GetAggregationResult Method
See Also  Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > IAggregationSupport Interface : GetAggregationResult Method


row
Row index of first row in selected range
column
Column index of first column in selected range
rowCount
Number of rows in selected range
columnCount
Number of columns in selected range
aggType
The type of aggregation
aggformula
The aggregation formula.

Glossary Item Box

Gets the aggregation of the cells in the specified range of cells.

Syntax

Visual Basic (Declaration) 
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 IAggregationSupport
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# 
object GetAggregationResult( 
   int row,
   int column,
   int rowCount,
   int columnCount,
   AggregationType aggType,
   string aggformula
)

Parameters

row
Row index of first row in selected range
column
Column index of first column in selected range
rowCount
Number of rows in selected range
columnCount
Number of columns in selected range
aggType
The type of aggregation
aggformula
The aggregation formula.

Return Value

An object of the aggregation result

Exceptions

ExceptionDescription
ParseException aggformula is not a valid formula.

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

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