IFormatSettings

12 Sep 20251 minute to read

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.

ignoreCurrency boolean

Specifies whether to ignore currency symbol in formatted value,

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,