Spire.XLS API

Spire.XLS namespace

Spire.Xls.Core.Spreadsheet.PivotTables

XlsPivotField Class

XlsPivotField Properties

AutoSort Property

Axis Property

CanDragOff Property

CanDragToColumn Property

CanDragToData Property

CanDragToPage Property

CanDragToRow Property

IsDragToHide Property

IsFormulaField Property

IsMultiSelected Property

IsShowAllItems Property

ItemsPerPage Property

Name Property

NumberFormat Property

NumberFormatIndex Property

Parent Property

RepeatItemLabels Property

ShowBlankRow Property

ShowDataAs Property

ShowDropDown Property

ShowNewItemsInFilter Property

ShowNewItemsOnRefresh Property

ShowOutline Property

ShowPageBreak Property

ShowPropAsCaption Property

ShowToolTip Property

SortType Property

SubtotalCaption Property

Subtotals Property

SubtotalTop Property

XlsPivotField ItemsPerPage Property

Specifies the number of items showed per page in the PivotTable.

Namespace: Spire.Xls.Core.Spreadsheet.PivotTables
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

public int ItemsPerPage { get; set; }

Public Property ItemsPerPage As Integer
	Get
	Set

public:
property int ItemsPerPage {
	int get ();
	void set (int value);
}

member ItemsPerPage : int with get, set

Property Value

Type: Int32

Reference

XlsPivotField Class

Spire.Xls.Core.Spreadsheet.PivotTables Namespace

XlsPivotField AddLanguageSpecificTextSet("LSTE13737A0_0?cpp=::|nu=."); ItemsPerPage Property

Property Value

Reference

XlsPivotField ItemsPerPage Property