Spread ASP.NET 6.0 Product Documentation
AggregationType Enumeration
See Also  Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace : AggregationType Enumeration


Glossary Item Box

Specifies the type of Aggregation on ranges of cells.

Syntax

Visual Basic (Declaration) 
Public Enum AggregationType 
   Inherits System.Enum
Visual Basic (Usage)Copy Code
Dim instance As AggregationType
C# 
public enum AggregationType : System.Enum 

Members

MemberDescription
AvgReturns the average of cells in a range.
CountCounts the number of cells in a range that contain numbers.
CountACounts the number of cells in a range that are not empty.
CustomCustom aggregation.
MaxReturns the maximum value of cells in a range.
MinIndicates that rowCount of the cells in the specified range of cells.
NoneIndicates that does't support aggregation for the sheet.
ProductMultiplies all the cells in a range and returns the product.
StDevReturns the standard deviation for a set of cells in a range.
StDevPCalculates standard deviation based on the entire population given as cells in a range.
SumSums values of cells in a range.
VarCalculates variance based on a sample of a population.
VarPCalculates variance based on the entire population.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.Model.AggregationType

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.