Class AxisSet

Allows you to configure the pivot cell information retrieved from the data source.

Inheritance
System.Object
AxisSet
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.EJ2.Pivot
Assembly: Syncfusion.EJ2.Pivot.dll
Syntax
public class AxisSet

Constructors

AxisSet()

Declaration
public AxisSet()

Properties

ActualText

It allows to set the actual text.

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

ActualValue

It allows to set actual value of the cell.

Declaration
public double ActualValue { get; set; }
Property Value
Type
System.Double

Axis

It allows to set the axis name of the member.

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

ColIndex

It allows to set column index to the cell.

Declaration
public int ColIndex { get; set; }
Property Value
Type
System.Int32

ColOrdinal

It allows to set column ordinal of the cell.

Declaration
public int ColOrdinal { get; set; }
Property Value
Type
System.Int32

ColSpan

It allows to set column span to the cell.

Declaration
public int ColSpan { get; set; }
Property Value
Type
System.Int32

ColumnHeaders

Specifies the column header of a value cell.

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

CssClass

It allows to custom class names to the cell.

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

DateText

It allows set the formatted date string of the cell.

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

It allows to set the visibility of hyperlink to the cell.

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

FormattedText

It allows to set the formatted text.

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

HasChild

It allows to set whether the member has children or not.

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

Hierarchy

It allows to set whether the member field is a attribute hierarchy or not.

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

Index

Specifies its position collections in data source.

Declaration
public List<int> Index { get; set; }
Property Value
Type
System.Collections.Generic.List<System.Int32>

IndexObject

Specifies its position collections in data source with indexed object.

Declaration
public SortedList<int, int> IndexObject { get; set; }
Property Value
Type
System.Collections.Generic.SortedList<System.Int32, System.Int32>

IsDrilled

It allows to set whether the member is driled or not.

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

IsGrandSum

Specifies whether the cell is grand summary or not.

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

IsLevelFiltered

Specifies whether the level of the cell is filtered or not.

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

IsNamedSet

It allows to set whether field is a namedset or not.

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

IsSum

Specifies whether the cell is summary or not.

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

Level

It allows to set level of the member.

Declaration
public int Level { get; set; }
Property Value
Type
System.Int32

LevelUniqueName

It allows to set the parent unique name.

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

Members

It allows to set the child members collection of the specific member.

Declaration
public List<AxisSet> Members { get; set; }
Property Value
Type
System.Collections.Generic.List<AxisSet>

MemberType

It allows to set member type.

Declaration
public int MemberType { get; set; }
Property Value
Type
System.Int32

Ordinal

It allows to set the cell ordinal.

Declaration
public int Ordinal { get; set; }
Property Value
Type
System.Int32

ParentUniqueName

It allows to set the parent unique name.

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

RowHeaders

Specifies the row header of a value cell.

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

RowIndex

It allows to set row index to the cell.

Declaration
public int RowIndex { get; set; }
Property Value
Type
System.Int32

RowOrdinal

It allows to set row ordinal of the cell.

Declaration
public int RowOrdinal { get; set; }
Property Value
Type
System.Int32

RowSpan

It allows to set row span to the cell.

Declaration
public int RowSpan { get; set; }
Property Value
Type
System.Int32

ShowSubTotals

It allows enable/disable sub totals.

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

Style

It allows to set the style information for conditional formatting.

Declaration
public Style Style { get; set; }
Property Value
Type
Style

Type

It allows to set the member type.

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

Value

It allows to set value of the cell.

Declaration
public double? Value { get; set; }
Property Value
Type
System.Nullable<System.Double>

ValueSort

Specifies the data collection which is to be framed for value sorted members.

Declaration
public Dictionary<string, object> ValueSort { get; set; }
Property Value
Type
System.Collections.Generic.Dictionary<System.String, System.Object>