Class SerializablePivotGrid

Inheritance

System.Object

SerializablePivotGrid

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Syncfusion.Windows.Forms.PivotAnalysis.Serialization

Assembly: Syncfusion.PivotAnalysis.Windows.dll

Syntax

public class SerializablePivotGrid

Constructors

SerializablePivotGrid()

Declaration

public SerializablePivotGrid()

Properties

AllowFiltering

Gets or sets a value indicating whether to enable or disable the filter.

Declaration

public bool AllowFiltering { get; set; }

Property Value

Type
System.Boolean

AllowSelection

Gets or sets a value indicating whether to allow cell selection like-in Excel.

Declaration

public GridSelectionFlags AllowSelection { get; set; }

Property Value

Type
GridSelectionFlags

AllowSorting

Gets or sets a value indicating whether to enable or disable the sorting.

Declaration

public bool AllowSorting { get; set; }

Property Value

Type
System.Boolean

CollapsedFields

Gets or sets a value that indicates row and column index for hidden fields.

Declaration

public List<SerializableCollapsedField> CollapsedFields { get; set; }

Property Value

Type
System.Collections.Generic.List<SerializableCollapsedField>

ConditionalFormats

Gets or sets the collection of conditional formats.

Declaration

public List<PivotGridNewRuleConditionalFormat> ConditionalFormats { get; set; }

Property Value

Type
System.Collections.Generic.List<PivotGridNewRuleConditionalFormat>

EnableUpdating

Gets or sets a value indicating whether to enable or disable updating the cells.

Declaration

public bool EnableUpdating { get; set; }

Property Value

Type
System.Boolean

EnableValueEditing

Gets or sets a value indicating whether to enable or disable editing the cells.

Declaration

public bool EnableValueEditing { get; set; }

Property Value

Type
System.Boolean

FilterCollection

Gets or sets the filter collection of PivotGrid.

Declaration

public List<SerializableFilter> FilterCollection { get; set; }

Property Value

Type
System.Collections.Generic.List<SerializableFilter>

Filters

Gets or sets the filter expressions.

Declaration

public ObservableCollection<FilterExpression> Filters { get; set; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<FilterExpression>

FreezeHeaders

Gets or sets a value indicating whether the row and column headers should freeze or not.

Declaration

public bool FreezeHeaders { get; set; }

Property Value

Type
System.Boolean

PivotCalculations

Gets or sets the PivotCalculations.

Declaration

public ObservableCollection<PivotComputationInfo> PivotCalculations { get; set; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<PivotComputationInfo>

PivotColumns

Gets or sets the column based PivotItems.

Declaration

public ObservableCollection<PivotItem> PivotColumns { get; set; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<PivotItem>

PivotFields

Gets or sets the PivotFields.

Declaration

public ObservableCollection<PivotItem> PivotFields { get; set; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<PivotItem>

PivotRows

Gets or sets the row based PivotItems..

Declaration

public ObservableCollection<PivotItem> PivotRows { get; set; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<PivotItem>

RowPivotsOnly

Gets or sets a value indicating whether the PivotGrid control is used to analyze data with only rows or with rows and columns.

Declaration

public bool RowPivotsOnly { get; set; }

Property Value

Type
System.Boolean

ShowCalculationsAsColumns

Gets or sets a value indicating whether the calculations should appear as rows or columns. By default, calculations appear as columns.

Declaration

public bool ShowCalculationsAsColumns { get; set; }

Property Value

Type
System.Boolean

ShowGrandTotals

Gets or sets a value indicating whether the grand total calculations should be computed by the Engine.

Declaration

public bool ShowGrandTotals { get; set; }

Property Value

Type
System.Boolean

Remarks

The default value is true.

ShowGroupBar

Gets or sets a value indicating whether GroupingBar needs to be visible or not.

Declaration

public bool ShowGroupBar { get; set; }

Property Value

Type
System.Boolean

ShowPivotTableFieldList

Gets or sets a value indicating whether to show or hide the visibility of PivotSchemaDesigner.

Declaration

public bool ShowPivotTableFieldList { get; set; }

Property Value

Type
System.Boolean

ShowPivotValueChooser

Gets or sets a value indicating whether to show or hide the PivotCalculation values in RowPivotsOnly mode.

Declaration

public bool ShowPivotValueChooser { get; set; }

Property Value

Type
System.Boolean

ShowSubTotals

Gets or sets a value indicating whether sub-total calculations should be shown or hidden.

Declaration

public bool ShowSubTotals { get; set; }

Property Value

Type
System.Boolean

Remarks

The default value is true.

SortFields

Gets or sets the sort collection of PivotGrid.

Declaration

public List<SerializableSortField> SortFields { get; set; }

Property Value

Type
System.Collections.Generic.List<SerializableSortField>

VisualStyle

Gets or sets the theme of the control.

Declaration

public GridVisualStyles VisualStyle { get; set; }

Property Value

Type
GridVisualStyles