Class PivotCellInfo

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

Inheritance
System.Object
PivotCellInfo
Namespace: Syncfusion.PivotAnalysis.UWP
Assembly: Syncfusion.PivotAnalysis.UWP.dll
Syntax
public class PivotCellInfo : Object

Constructors

PivotCellInfo()

Initializes a new instance of the PivotCellInfo class.

Declaration
public PivotCellInfo()

Fields

ColumnIndex

Gets the column index of specific cell

Declaration
public int ColumnIndex
Field Value
Type Description
System.Int32

RowIndex

Gets the row index of specific cell

Declaration
public int RowIndex
Field Value
Type Description
System.Int32

Properties

CellRange

Gets or sets any covered range associated with this cell.

Declaration
public CoveredCellRange CellRange { get; set; }
Property Value
Type Description
CoveredCellRange

CellType

Gets or sets the cell type of this cell.

Declaration
public PivotCellType CellType { get; set; }
Property Value
Type Description
PivotCellType

DoubleValue

Gets the double value of the cell.

Declaration
public double DoubleValue { get; }
Property Value
Type Description
System.Double

ExpandableState

Gets/sets if the cell is expanded.

Declaration
public ExpandableState ExpandableState { get; set; }
Property Value
Type Description
ExpandableState

Format

Gets or sets the format for the cells.

Declaration
public string Format { get; set; }
Property Value
Type Description
System.String

FormattedText

Gets or sets the formatted text displayed in this cell.

Declaration
public string FormattedText { get; set; }
Property Value
Type Description
System.String

HasChildren

Gets or sets a value indicating whether this instance has children.

Declaration
public bool HasChildren { get; set; }
Property Value
Type Description
System.Boolean

true if this instance has children; otherwise, false.

Key

Gets or sets the key associated with this cell.

Declaration
public string Key { get; set; }
Property Value
Type Description
System.String

ParentCell

Gets or sets the parent cell.

Declaration
public PivotCellInfo ParentCell { get; set; }
Property Value
Type Description
PivotCellInfo

RawValues

Gets the RawValues of the particular PivotCellInfo.

Declaration
public List<object> RawValues { get; }
Property Value
Type Description
System.Collections.Generic.List<System.Object>

Summary

Gets or sets the summary for the cell.

Declaration
public SummaryBase Summary { get; set; }
Property Value
Type Description
SummaryBase

Tag

Gets or sets the name of the cell.

Declaration
public object Tag { get; set; }
Property Value
Type Description
System.Object

UniqueText

Gets or sets the unique text.

Declaration
public string UniqueText { get; set; }
Property Value
Type Description
System.String

Value

Gets or sets the value in the cell.

Declaration
public object Value { get; set; }
Property Value
Type Description
System.Object

Methods

Dispose()

Method to dispose the pivot cell information

Declaration
public void Dispose()

ToString()

Returns the formatted text.

Declaration
public override string ToString()
Returns
Type Description
System.String

Extension Methods