Excel.Interfaces.NumberFormatInfoLoadOptions interface

Defines the culturally appropriate format of displaying numbers. This is based on current system culture settings.

Remarks

[ API set: ExcelApi 1.11 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

currencySymbol

Gets the currency symbol for currency values. This is based on current system settings.

numberDecimalSeparator

Gets the string used as the decimal separator for numeric values. This is based on current system settings.

numberGroupSeparator

Gets the string used to separate groups of digits to the left of the decimal for numeric values. This is based on current system settings.

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

currencySymbol

Gets the currency symbol for currency values. This is based on current system settings.

currencySymbol?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.17 ]

numberDecimalSeparator

Gets the string used as the decimal separator for numeric values. This is based on current system settings.

numberDecimalSeparator?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.11 ]

numberGroupSeparator

Gets the string used to separate groups of digits to the left of the decimal for numeric values. This is based on current system settings.

numberGroupSeparator?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.11 ]