Class PivotField
Inheritance
System.Object
PivotField
Assembly: DRIT.Spreadsheet.dll
Syntax
public class PivotField : object
Properties
AggregationFunction
Gets the aggregation function to apply in the subtotal of this field.
Declaration
public AggregationFunction AggregationFunction { get; }
Property Value
CustomName
Gets the custom name of the field.
Declaration
public string CustomName { get; }
Property Value
| Type |
Description |
| System.String |
|
DisplayCompact
Gets whether the application will display fields compactly in the sheet on which this PivotTable resides.
Declaration
public bool DisplayCompact { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
DisplaySubtotalsAtTop
Gets whether to display subtotals at the top of the group. Applies only when Outline its true.
Declaration
public bool DisplaySubtotalsAtTop { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
DragOff
Gets whether the field can be removed from the PivotTable.
Declaration
public bool DragOff { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
DragToColumn
Gets whether the field can be dragged to the column axis.
Declaration
public bool DragToColumn { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
DragToData
Gets whether the field can be dragged to the data region.
Declaration
public bool DragToData { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
DragToPage
Gets whether the field can be dragged to the page region.
Declaration
public bool DragToPage { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
DragToRow
Gets whether the field can be dragged to the row axis.
Declaration
public bool DragToRow { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
IncludeNewItemsInFilter
Gets whether manual filter is in inclusive mode
Declaration
public bool IncludeNewItemsInFilter { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
Index
Gets the index of the field in the PivotFields collection.
Declaration
public int Index { get; }
Property Value
| Type |
Description |
| System.Int32 |
|
InsertBlankRow
Gets whether to insert a blank row after each item.
Declaration
public bool InsertBlankRow { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
InsertPageBreak
Gets whether to insert a page break after each item.
Declaration
public bool InsertPageBreak { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
MultipleItemSelectionAllowed
Gets whether the field can have multiple items selected in the page field.
Declaration
public bool MultipleItemSelectionAllowed { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
Name
Gets the source name of the field.
Declaration
public string Name { get; }
Property Value
| Type |
Description |
| System.String |
|
Represents the custom display format of numbers and dates.
Declaration
public Format NumberFormat { get; }
Property Value
PivotItems
Declaration
public PivotItemCollection PivotItems { get; }
Property Value
ShowAllItems
Gets whether to show all items for this field.
Declaration
public bool ShowAllItems { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
Gets whether the items in this field should be shown in Outline form.
Declaration
public bool ShowInOutlineForm { get; }
Property Value
| Type |
Description |
| System.Boolean |
|
ShowValuesAs
Gets the custom calculation to use for the field.
Declaration
public PivotFieldCustomCalculation ShowValuesAs { get; }
Property Value