- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.Web.Chart Assembly
-
FarPoint.Web.Spread Assembly
- FarPoint.Web.Spread
- FarPoint.Web.Spread.Chart
- FarPoint.Web.Spread.Data
- FarPoint.Web.Spread.Editor
-
FarPoint.Web.Spread.Model
-
Classes
- AggregateArgs
- AutoFilterIndexChangedEventArgs
- BaseSheetAxisModel
- BaseSheetDataModel
- BaseSheetSelectionModel
- BaseSheetSpanModel
- BaseSheetStyleModel
- CellRange
- CellRangeConverter
- DefaultSheetAxisModel
-
DefaultSheetDataModel
- Constructors
- Properties
-
Methods
- AddColumn
- AddColumns
- AddCustomFunction
- AddCustomName
- AddRow
- AddRowToDataSource
- AddRows
- AddUnboundRows
- Clear
- ClearCustomFunctions
- ClearCustomNames
- ClearData
- ClearFormulas
- CompareExpression
- Copy
- CreateDataSourceSelectArguments
- Deserialize
- EvaluateExpression
- FireChanged
- GetAggregationResult
- GetAggregationType
- GetArray
- GetChildDataModel
- GetChildRelation
- GetColumnIndex
- GetCustomFunction
- GetCustomFunctionEnumerator
- GetCustomName
- GetCustomNameEnumerator
- GetDataColumnCaption
- GetDataColumnFromModelColumn
- GetDataColumnName
- GetDataColumnType
- GetDataRow
- GetDataRowFromModelRow
- GetDataTable
- GetDataView
- GetExpression
- GetFormula
- GetItem
- GetKey
- GetListSource
- GetModelColumnFromDataColumn
- GetModelRowFromDataRow
- GetNonEmptyNotesColumnCount
- GetNonEmptyNotesRowCount
- GetNote
- GetObjectData
- GetTag
- GetUnboundValue
- GetValue
- GoalSeek
- IsColumnBound
- IsEditable
- IsEmpty
- IsRowBound
- IsRowUsed
- LoadFormulas
- Move
- NextNonEmptyColumnInRow
- NextNonEmptyRow
- OnAggregate
- OnChanged
- OnDataSourceViewChanged
- ParseFormula
- Recalculate
- RecalculateAll
- RemoveColumn
- RemoveColumns
- RemoveCustomFunction
- RemoveCustomName
- RemoveRow
- RemoveRows
- Serialize
- Serialize2
- SetAggregationType
- SetArray
- SetExpression
- SetFormula
- SetModelDataColumn
- SetNote
- SetTag
- SetValue
- Swap
- UnparseFormula
- Events
- DefaultSheetDataModel.DefaultSheetDataModelEnumerator
- DefaultSheetSelectionModel
- DefaultSheetSpanModel
- DefaultSheetStyleModel
- GeneralFormatter
- Group
- GroupDataModel
- GroupFooter
- InvalidExternalReferenceParseException
- ParseException
- PropertyChangingEventArgs
- RequestRowVisibleStatesEventArgs
- Serializer
- SheetAxisModelChangingEventArgs
- SheetAxisModelEventArgs
- SheetAxisProperty
- SheetDataModelEventArgs
- SheetGroupDataModelEventArgs
- SheetSelectionModelEventArgs
- SheetStyleModelEventArgs
- SpreadSerializer
- Enums
- Interfaces
- Delegates
-
Classes
- FarPoint.Web.Spread.Renderer
- FarPoint.Web.Spread.Extender Assembly
FarPoint.Web.Spread.Model.DefaultSheetDataModel.GetAggregationResult
GetAggregationResult Method
GetAggregationResult(int, int, int, int, AggregationType, string)
Calculates the value based on the aggregation type and formats the value with the aggregation format.
Declaration
public object GetAggregationResult(int row, int column, int rowCount, int columnCount, AggregationType aggType, string aggformula)Public Function GetAggregationResult(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, aggType As AggregationType, aggformula As String) As ObjectParameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| int | rowCount | Number of rows |
| int | columnCount | Number of columns |
| AggregationType | aggType | Aggregation type |
| string | aggformula | Aggregation formula |
Returns
| Type | Description |
|---|---|
| object | The calculated value in form of the aggregation format |