Click or drag to resize

XlsPivotField Properties

The XlsPivotField type exposes the following members.

Properties
Name Description
Public property AutoSort
Preserves the sorting elements of the field
Public property Axis
Gets/sets field axis.
Public property CanDragOff
User can remove field from view.
Public property CanDragToColumn
User can drag field to column area.
Public property CanDragToData
True if the specified field can be dragged to the data position. The default value is True.
Public property CanDragToPage
User can drag field to page area.
Public property CanDragToRow
User can drag field to row area.
Public property Caption
Specifies the unique name of the member property to be used as a caption for the field and field items.
Public property Compact
Specifies a boolean value that indicates whether the application will display fields compactly in the sheet on which this PivotTable resides
Public property CustomName
Gets/sets pivot field custom name.
Public property DataField
Gets/sets value indicating whether this is data field.
Public property Formula
Specifies the formula for the calculated field
Public property IsAutoShow
Autoshow is enabled.
Public property IsDataField
Gets/sets value indicating whether this is data field.
Public property IsDragToHide
User can remove field from fiew.
Public property IsFormulaField
Indicates whether this field is formula field
Public property IsMultiSelected
Specifies a boolean value that indicates whether the field can have multiple items selected in the page field.
Public property IsShowAllItems
Show all items for this field.
Public property ItemsPerPage
Specifies the number of items showed per page in the PivotTable.
Public property Name
Returns pivot field name. Read-only.
Public property NumberFormat
Gets/sets number format.
Public property NumberFormatIndex
Gets / sets number format index.
Public property Parent
Gets the parent PivotTableFields object of the current instance.
Public property RepeatItemLabels
True if the field repeat item labels.
Public property ShowBlankRow
True if a blank row is inserted after the specified row field in a PivotTable report.
Public property ShowDataAs
Gets or sets the show data as.
Public property ShowDropDown
True if the flag for the specified PivotTable field or PivotTable item is set to "drilled" (expanded, or visible).
Public property ShowNewItemsInFilter
Specifies a boolean value that indicates whether manual filter is in inclusive mode.
Public property ShowNewItemsOnRefresh
Specifies a boolean value that indicates whether new items that appear after a refresh should be hidden by default.
Public property ShowOutline
Specifies a boolean value that indicates whether the items in this field should be shown in Outline form. If the parameter is true, the field layout is "Show item labels in outline form". If the parameter is false, the field layout is "Show item labels in tabular form".
Public property ShowPageBreak
True if a page break is inserted after each field.
Public property ShowPropAsCaption
Specifies a boolean value that indicates whether to show the property as a member caption.
Public property ShowToolTip
Specifies a boolean value that indicates whether to show the member property value in a tooltip on the appropriate PivotTable cells.
Public property SortType
Specifies the type of sort that is applied to this field.
Public property SubtotalCaption
Specifies the custom text that is displayed for the subtotals caption.
Public property Subtotals
Gets or sets type of field subtotals.
Public property SubtotalTop
Get or set whether show
Top
See Also