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 Formula Property

Specifies the formula for the calculated field

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 string Formula { get; set; }

Public Property Formula As String
	Get
	Set

public:
virtual property String^ Formula {
	String^ get () sealed;
	void set (String^ value) sealed;
}

abstract Formula : string with get, set
override Formula : string with get, set

Property Value

Type: String

Implements

IPivotField Formula

Reference

XlsPivotField Class

Spire.Xls.Core.Spreadsheet.PivotTables Namespace

XlsPivotField AddLanguageSpecificTextSet("LSTC4CEDF15_0?cpp=::|nu=."); Formula Property

Property Value

Implements

Reference

XlsPivotField Formula Property