Search results

IFormatSettings API in JavaScript (ES5) Pivotfieldlist API control

Allows specific fields used to display the values with specific format that used to be displayed in the pivot table. For example, to display a specific field with currency formatted values in the pivot table, the set the format property to be C.

Properties

altSymbol

string

Species which currency symbol to consider.

calendar

string

Specifies the calendar mode other than gregorian

currency

string

Specifies the currency code to be used for formatting.

format

string

Specifies custom number format for formatting.

isServerRendered

boolean

Enable server side date formating.

maximumFractionDigits

number

Specifies maximum fraction digits in formatted value.

maximumSignificantDigits

number

Specifies maximum significant digits in formatted value.

minimumFractionDigits

number

Specifies minimum fraction digits in formatted value.

minimumIntegerDigits

number

Specifies minimum integer digits in formatted value.

minimumSignificantDigits

number

Specifies minimum significant digits in formatted value.

name

string

It allows to set the field name to apply format settings.

skeleton

string

Specifies the skeleton for perform formatting.

type

string

Specifies the type of date formatting either date, dateTime or time.

useGrouping

boolean

Specifies whether to use grouping or not in formatted value,