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 load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as 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 load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as 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 ]