Namespace Syncfusion.XlsIO.Implementation.PivotAnalysis

Classes

Average Displays the Average of values

BinaryList Used to store the row header and column header values as BinaryList.

CountSummary Computes the count of double or integer values.

CoveredCellRange This class defines a set of four integers that define a covered range in the zero-based coordinate system of a PivotTable.

DecimalTotalSummary This class is used to computes the sum of decimal values.

DisplayIfDiscreteValuesEqual Displays the aggregated value in the PivotComputation column, if all the values are aggregated to be same else the value in PadString property is displayed.

DoubleAverageSummary This class is used to compute the average of double or integer values.

DoubleMaxSummary This class is used to compute the maximum of double or integer values.

DoubleMinSummary This class is used to compute the minimum of double or integer values.

DoubleStDevSummary This class is used to compute the standard deviation of double or integer values.

DoubleTotalSummary This class is used to compute the sum of double or integer values.

DoubleVarianceSummary This class is used to compute the variance of double or integer values.

DynamicPropertyDescriptor Class that holds the methods for setting the value for the variable.

ExpressionPropertyDescriptor Class that illustrates the expression field support along with filtering in PivotEngine.

ExtensionClass Class which has a method to determine whether the specified item is in the hidden group collection.

FieldInfo Gets the information about the PiovtFields.

FilterExpression This class encapsulates the information needed to define a filter.

FilterHelper This class encapsulates the support for computing filter values and expressions.

FilterItemElement Class that holds different filter items.

FilterItemsCollection Class that holds the collection of objects that are filtered.

HiddenGroup Class used to hold the properties of each hidden group.

IndexEngine Index Engine is used to load the collection of data faster than the PivotEngine. It makes use of the "EnableOnDemandCalculations" property. Unlike the PivotEngine, it loads the entire collection of data by including all the values in the list irrespective of Row and Column headers.

IntTotalSummary This class is used to compute the sum of integer values.

ListIndexInfo Class that holds primarily the information on one row in a PivotTable. Additionally, these calls can be used to hold information on the row/column header structures.

Max Displays the maximum value of given values

Min Displays the minimum value of given values

PivotCellInfo This class provides an information about a specific cell in a PivotTable.

PivotCellInfos Gets the information from the Pivot control.

PivotComputationInfo This class holds the information needed for the calculations that appear in a Pivot control. For each calculation seen, there is an associated PivotComputationInfo object that is added to the PivotComputationInfo collection.

PivotEngine This class encapsulates pivoting calculation support. To use it, first populate the PivotColumns and PivotRows collections to define the properties being pivoted. Then you populate the PivotCalculations collection to define the values you would like to see populated.

PivotEngine.CalcSortComparer This class used for sorting the Pivoted row/column.

PivotEngine.SortKeys Class that holds the properties which is used to handle single sort and multi sort in Grid.

PivotGridConstants Class that holds different Grid constants.

PivotItem Enacapulates the information needed to define a PivotItem, for either a row/column Pivot.

PivotSchemaChangedArgs Event argument for the PivotSchemaChangedArgs event.

SortComparer Class used to compare and sort the given collection.

StdDev Displays the standard deviation of given values

StdDevP Displays the standard deviation population of given values

Sum Displays the sum of values

SummaryBase This is an abstract class that defines the necessary functionality to do PivotCalculations.

SummaryPivotItem This class is primarily for internal use. It is used to generate the rows and columns that hold summaries of PivotCalculations.

Variance Displays the Variance of given values

VarianceP Displays the VarianceP of given values

Interfaces

IAdjustable Use this interface to enable shortcut calculations to adjust a summary when an underlying value changes. The idea is to avoid re-computing the summary from scratch. For example, if your summary computes the total of a set of values, you can quickly adjust this computed total when a value changes by subtracting the old value and adding the new value without having to re-compute the total from scratch. Not all types of calculations lend themselves to this shortcut behavior.

Enums

CalculationType Calculation type defines the view for a particular computational object (or value field).

DisplayOption Used to provide a list of display option.

ExpressionError Denotes the different error types.

FieldTypes Enum holding the field types.

GridLayout Specifies the layout for the Pivot control.

PivotCellType Enumerates the possible Pivot cell types.

RowType Enumeration provides option to select row type.

SchemaChangeHints Information on what changes have occurred in the Pivot Schema.

SummaryDisplayLevel Controls whether a summary calculation is to be displayed for all levels or only for the inner-most level.

SummaryType Enumerates the summary types available for calculations in the Pivot control. If you use the value "Custom" in a ComputationInfo object, then you are required to explicitly set the ComputationInfo.Summary value.

Delegates

GetValueDelegate Use to get the property value without using reflection.

PivotSchemaChangedEventHandler Event handler for the PivotSchemaChangedEventHandler event.