IWorkNumberFormat
OfficeIMO.IWork
The recovered semantic numeric, temporal or text format of an iWork cell, independent of a destination format code.
Inheritance
- object
- IWorkNumberFormat
Usage
Explore 5 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 4
Accepted by parameters 1
- Method IWorkTableData.SetNumber
Methods
public static IWorkNumberFormat CreateNumber(int decimalPlaces, bool thousandsSeparator = false, IWorkNegativeNumberStyle negativeStyle = Minus) #Creates an explicit decimal format for a newly created numeric table cell.
Parameters
- decimalPlaces int
- The number of fractional digits, from zero through thirty.
- thousandsSeparator bool = false
- Whether to group digits using the receiving document's locale.
- negativeStyle OfficeIMO.IWork.IWorkNegativeNumberStyle = Minus
- How negative values appear.
Returns
IWorkNumberFormatpublic static IWorkNumberFormat CreatePercentage(int decimalPlaces, bool thousandsSeparator = false, IWorkNegativeNumberStyle negativeStyle = Minus) #Creates an explicit percentage format. The stored numeric value is multiplied by one hundred for display.
Parameters
- decimalPlaces int
- The number of fractional digits, from zero through thirty.
- thousandsSeparator bool = false
- Whether to group digits using the receiving document's locale.
- negativeStyle OfficeIMO.IWork.IWorkNegativeNumberStyle = Minus
- How negative values appear.
Returns
IWorkNumberFormatpublic static IWorkNumberFormat CreateScientific(int decimalPlaces) #Creates a scientific format with zero through thirty fractional mantissa digits, a minus sign and no grouping.
Parameters
- decimalPlaces int
Returns
IWorkNumberFormatInherited Methods
Properties
public IWorkNumberFormatKind Kind { get; } #Gets the source scalar display family.
public int? DecimalPlaces { get; } #Gets the explicit decimal count from zero through thirty, or null for Numbers' automatic mode, fractions, temporal or text formats. Scientific formats apply this count to the mantissa; fractions use FractionAccuracy instead.
public bool ThousandsSeparator { get; } #Gets whether the source requests digit grouping.
public IWorkNegativeNumberStyle NegativeStyle { get; } #Gets the source treatment of negative values.
public string? CurrencyCode { get; } #Gets the source three-letter uppercase currency identifier, or null for other numeric formats. This does not imply a symbol or locale.
public bool UseAccountingStyle { get; } #Gets whether the source currency format requests accounting alignment and parenthesized negative amounts.
public IWorkFractionAccuracy? FractionAccuracy { get; } #Gets the denominator precision for a fraction format, or null for other numeric families.
public IWorkDurationFormat? DurationFormat { get; } #Gets the qualified duration units and label style, or null for other families.
public IWorkDateTimeFormat? DateTimeFormat { get; } #Gets the qualified source date/time pattern, or null for other families.