PivotTableSortOptions Class

Namespace:

GemBox.Spreadsheet.PivotTables

Assembly:

GemBox.Spreadsheet.dll

Represents the sort options of a pivot field.

• C#
• VB.NET

public sealed class PivotTableSortOptions

Public NotInheritable Class PivotTableSortOptions

Inheritance:

System.Object

PivotTableSortOptions

Properties

DataField

Gets a data field that is used to sort the pivot field.

• C#
• VB.NET

public PivotField DataField { get; }

Public ReadOnly Property DataField As PivotField

Property Value

PivotField

Descending

Gets a value indicating whether the sort is descending.

• C#
• VB.NET

public bool Descending { get; }

Public ReadOnly Property Descending As Boolean

Property Value

System.Boolean

PivotItems

Gets the pivot items that specify the row (or column) that will be used to sort the pivot field.

• C#
• VB.NET

public ReadOnlyCollection<PivotItem> PivotItems { get; }

Public ReadOnly Property PivotItems As ReadOnlyCollection(Of PivotItem)

Property Value

System.Collections.ObjectModel.ReadOnlyCollection<PivotItem>