|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
System.Objectxl.write.NumberFormats
Static class which contains the available list of built in Number formats
Field Summary | |
static xl.biff.DisplayFormat |
ACCOUNTING_FLOAT
Formatting for an integer which is presented in accounting format |
static xl.biff.DisplayFormat |
ACCOUNTING_INTEGER
Formatting for an integer which is presented in accounting format |
static xl.biff.DisplayFormat |
ACCOUNTING_RED_FLOAT
As ACCOUNTING_FLOAT except that deficits appear colored red |
static xl.biff.DisplayFormat |
ACCOUNTING_RED_INTEGER
As ACCOUNTING_INTEGER except that deficits appear colored red |
static xl.biff.DisplayFormat |
DEFAULT
The default format. |
static xl.biff.DisplayFormat |
EXPONENTIAL
Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00" |
static xl.biff.DisplayFormat |
FLOAT
Formatting for a float. |
static xl.biff.DisplayFormat |
FORMAT1
Equivalent to a DecimalFormat "#,##0;(#,##0)" |
static xl.biff.DisplayFormat |
FORMAT10
Equivalent to DecimalFormat "##0.0E0" |
static xl.biff.DisplayFormat |
FORMAT2
Equivalent to FORMAT1 except deficits are colored red |
static xl.biff.DisplayFormat |
FORMAT3
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)" |
static xl.biff.DisplayFormat |
FORMAT4
Equivalent to FORMAT3 except deficits are colored red |
static xl.biff.DisplayFormat |
FORMAT5
Equivalent to DecimalFormat "#,##0;(#,##0)" |
static xl.biff.DisplayFormat |
FORMAT6
Equivalent to FORMAT5 except deficits are colored red |
static xl.biff.DisplayFormat |
FORMAT7
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)" |
static xl.biff.DisplayFormat |
FORMAT8
Equivalent to FORMAT7 except deficits are colored red |
static xl.biff.DisplayFormat |
FORMAT9
Equivalent to FORMAT7 |
static xl.biff.DisplayFormat |
FRACTION_ONE_DIGIT
Formatting for one digit fractions |
static xl.biff.DisplayFormat |
FRACTION_TWO_DIGITS
Formatting for two digit fractions |
static xl.biff.DisplayFormat |
INTEGER
Formatting for an integer number. |
static xl.biff.DisplayFormat |
PERCENT_FLOAT
Formatting for a float percentage Equivalent to a DecimalFormat "0.00%" |
static xl.biff.DisplayFormat |
PERCENT_INTEGER
Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%" |
static xl.biff.DisplayFormat |
TEXT
Forces numbers to be interpreted as text |
static xl.biff.DisplayFormat |
THOUSANDS_FLOAT
Formatting for a float that has a thousands separator. |
static xl.biff.DisplayFormat |
THOUSANDS_INTEGER
Formatting for an integer that has a thousands separator. |
Constructor Summary | |
NumberFormats()
|
Methods inherited from class System.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static readonly xl.biff.DisplayFormat DEFAULT
public static readonly xl.biff.DisplayFormat INTEGER
public static readonly xl.biff.DisplayFormat FLOAT
public static readonly xl.biff.DisplayFormat THOUSANDS_INTEGER
public static readonly xl.biff.DisplayFormat THOUSANDS_FLOAT
public static readonly xl.biff.DisplayFormat ACCOUNTING_INTEGER
public static readonly xl.biff.DisplayFormat ACCOUNTING_RED_INTEGER
public static readonly xl.biff.DisplayFormat ACCOUNTING_FLOAT
public static readonly xl.biff.DisplayFormat ACCOUNTING_RED_FLOAT
public static readonly xl.biff.DisplayFormat PERCENT_INTEGER
public static readonly xl.biff.DisplayFormat PERCENT_FLOAT
public static readonly xl.biff.DisplayFormat EXPONENTIAL
public static readonly xl.biff.DisplayFormat FRACTION_ONE_DIGIT
public static readonly xl.biff.DisplayFormat FRACTION_TWO_DIGITS
public static readonly xl.biff.DisplayFormat FORMAT1
public static readonly xl.biff.DisplayFormat FORMAT2
public static readonly xl.biff.DisplayFormat FORMAT3
public static readonly xl.biff.DisplayFormat FORMAT4
public static readonly xl.biff.DisplayFormat FORMAT5
public static readonly xl.biff.DisplayFormat FORMAT6
public static readonly xl.biff.DisplayFormat FORMAT7
public static readonly xl.biff.DisplayFormat FORMAT8
public static readonly xl.biff.DisplayFormat FORMAT9
public static readonly xl.biff.DisplayFormat FORMAT10
public static readonly xl.biff.DisplayFormat TEXT
Constructor Detail |
public NumberFormats()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |