NumberFormatterOptions
Formatter Options for Numeric Columns
TypeScript
export interface NumberFormatterOptions extendsExtends
BaseFormatterOptions
Properties
| Property | Description |
|---|---|
| Abs | Returns absolute value of cell value |
| Ceiling | Returns smallest integer greater than cell value |
| Content | Replaces cell value with supplied value (that can contain Template Literals) |
| Empty | Show nothing in cell (but underlying value remains) |
| Floor | Returns largest integer cell value |
| FractionDigits | Number of digits to show in Fractions (up to 20) |
| FractionSeparator | Separator to use in fractions |
| IntegerDigits | Number of digits to show for Integers (up to 20) |
| IntegerSeparator | Separator to use in Integers |
| Multiplier | Multiplier to use on cell value |
| Parentheses | Shows negative numbers in parentheses |
| Prefix | Prefix to use before cell value |
| Round | Rounds cell value |
| Suffix | Suffix to use after cell value |
| Truncate | Truncates cell value |
Property Details
Abs
Returns absolute value of cell value
TypeScript
Abs?: boolean;Property Value
boolean
Ceiling
Returns smallest integer greater than cell value
TypeScript
Ceiling?: boolean;Property Value
boolean
Content
Replaces cell value with supplied value (that can contain Template Literals)
TypeScript
Content?: string | number;Property Value
string | number
Empty
Show nothing in cell (but underlying value remains)
TypeScript
Empty?: boolean;Property Value
boolean
Floor
Returns largest integer cell value
TypeScript
Floor?: boolean;Property Value
boolean
FractionDigits
Number of digits to show in Fractions (up to 20)
TypeScript
FractionDigits?: number;Property Value
number
FractionSeparator
Separator to use in fractions
TypeScript
FractionSeparator?: string;Property Value
string
IntegerDigits
Number of digits to show for Integers (up to 20)
TypeScript
IntegerDigits?: number;Property Value
number
IntegerSeparator
Separator to use in Integers
TypeScript
IntegerSeparator?: string;Property Value
string
Multiplier
Multiplier to use on cell value
TypeScript
Multiplier?: number;Property Value
number
Parentheses
Shows negative numbers in parentheses
TypeScript
Parentheses?: boolean;Property Value
boolean
Prefix
Prefix to use before cell value
TypeScript
Prefix?: string;Property Value
string
Round
Rounds cell value
TypeScript
Round?: boolean;Property Value
boolean
Suffix
Suffix to use after cell value
TypeScript
Suffix?: string;Property Value
string
Truncate
Truncates cell value
TypeScript
Truncate?: boolean;Property Value
boolean