Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/
Class

IWorkNumberFormat

OfficeIMO.IWork

Namespace
OfficeIMO.IWork
Assembly
OfficeIMO.IWork
Source revision
5e5a2dda74b3 with working tree changes
Modifiers
sealed

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.

Accepted by parameters 1

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 required
The number of fractional digits, from zero through thirty.
thousandsSeparator bool = false optional
Whether to group digits using the receiving document's locale.
negativeStyle OfficeIMO.IWork.IWorkNegativeNumberStyle = Minus optional
How negative values appear.
public 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 required
The number of fractional digits, from zero through thirty.
thousandsSeparator bool = false optional
Whether to group digits using the receiving document's locale.
negativeStyle OfficeIMO.IWork.IWorkNegativeNumberStyle = Minus optional
How negative values appear.
public 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 required

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.