XlsPivotField Class

System Object
Spire.Xls.Core.Spreadsheet.PivotTables XlsPivotField
Spire.Xls PivotField

public class XlsPivotField : IPivotField, 
	ICloneParent

Public Class XlsPivotField
	Implements IPivotField, ICloneParent

public ref class XlsPivotField : IPivotField, 
	ICloneParent

type XlsPivotField =
class
interface IPivotField
interface ICloneParent
end

	Name	Description
	XlsPivotField	Initializes a new instance of the XlsPivotField class with the specified parent.

Top

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

Top

	Name	Description
	AddItemOption	Represents the index of item and itemoptions key pairs
	AddLabelFilter	Add label filter for pivot field, only for row and column field.
	AddValueFilter	Add value filter for pivot field, only for row and column field.
	Clone	Creates a new object that is a copy of the current instance.
	CreateGroup(DateTime, DateTime, PivotGroupByTypes )	Create group for current field.
	CreateGroup(Double, Double, Double)	Create group for current field.
	CreateGroup(DateTime, DateTime, PivotGroupByTypes , Int32)	Create group for current field.
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object .)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object .)
	GetHashCode	Serves as the default hash function. (Inherited from Object .)
	GetType	Gets the Type of the current instance. (Inherited from Object .)
	HideAllItem	Sets whether the all PivotItem in a data field is hidden. Must call after pivottable CalculateData function.
	HideDetail	Sets whether the PivotItems in a pivot field is hidden detail.That is collapse/expand this field. Must call after pivottable CalculateData function.
	HideItem(Int32, Boolean)	Sets whether the specific PivotItem in a data field is hidden. Must call after pivottable CalculateData function.
	HideItem(String, Boolean)	Sets whether the specific PivotItem in a data field is hidden. Must call after pivottable CalculateData function.
	HideItemDetail(Int32, Boolean)	Sets whether the specific PivotItem in a pivot field is hidden detail. Must call after pivottable CalculateData function.
	HideItemDetail(String, Boolean)	Sets whether the PivotItems in a pivot field is hidden detail.That is collapse/expand this field. Must call after pivottable CalculateData function.
	IsHiddenItem	Indicates whether the specific PivotItem is hidden. Must call after pivottable CalculateData function.
	IsHiddenItemDetail	Indicates whether the specific PivotItem is hidden detail. Must call after pivottable CalculateData function.
	MemberwiseClone	Creates a shallow copy of the current Object . (Inherited from Object .)
	Sort	Sort row fildes or col fields by data field.
	ToString	Returns a string that represents the current object. (Inherited from Object .)

Top

Reference

Spire.Xls.Core.Spreadsheet.PivotTables Namespace