Search results

FormatSettings API in JavaScript (ES5) Pivot Table 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

currency

string

It allows to specify the currency code to be used for formatting.

format

string

It allows to specify custom number format for formatting.

maximumFractionDigits

number

It allows to specify maximum fraction digits to the formatted value.

maximumSignificantDigits

number

It allows to specify maximum significant digits to the formatted value.

minimumFractionDigits

number

It allows to specify minimum fraction digits to the formatted value.

minimumIntegerDigits

number

It allows to specify minimum integer digits to the formatted value.

minimumSignificantDigits

number

It allows to specify minimum significant digits to the formatted value.

name

string

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

skeleton

string

It allows to specify the skeleton such as full, medium, long, short, etc. to perform date formatting.

It is applicable only for date type formatting.

type

string

It allows to specify the type of date formatting either date, dateTime or time.

useGrouping

boolean

It allows to use grouping to the formatted value,

Defaults to true