Class PivotFieldSortSetting

Class PivotFieldSortSetting

Namespace: Aspose.Cells.Pivot
Assembly: Aspose.Cells.dll (25.2.0)

Represents the setting of sorting pivot fields.

public class PivotFieldSortSetting

Inheritance

objectPivotFieldSortSetting

Inherited Members

object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Properties

Cell

Sorts by the values in which row or column.

public string Cell { get; }

Property Value

string

FieldIndex

Represents the index of the field sorted by. -1 means sorting the PivotField by the labels,others means sorting by the data field.

public int FieldIndex { get; }

Property Value

int

IsSimpleSort

Indicates whether a simple data sort operation will be applied.

public bool IsSimpleSort { get; }

Property Value

bool

Remarks

The default value is true.

IsSortByLabels

Indicates whether sorting the field by itself or data field.

public bool IsSortByLabels { get; }

Property Value

bool

LineTypeSortedBy

The pivot line type sorted by.

public PivotLineType LineTypeSortedBy { get; }

Property Value

PivotLineType

Remarks

Only works when not sorting this field by labels.

SortType

Represents the Aspose.Cells.SortOrder.

public SortOrder SortType { get; }

Property Value

SortOrder