public final class NumberFormats
extends java.lang.Object
Modifier and Type | Field | Description |
---|---|---|
static jxl.biff.DisplayFormat |
ACCOUNTING_FLOAT |
Formatting for an integer which is presented in accounting format
(ie.
|
static jxl.biff.DisplayFormat |
ACCOUNTING_INTEGER |
Formatting for an integer which is presented in accounting format
(ie.
|
static jxl.biff.DisplayFormat |
ACCOUNTING_RED_FLOAT |
As ACCOUNTING_FLOAT except that deficits appear coloured red
|
static jxl.biff.DisplayFormat |
ACCOUNTING_RED_INTEGER |
As ACCOUNTING_INTEGER except that deficits appear coloured red
|
static jxl.biff.DisplayFormat |
DEFAULT |
The default format.
|
static jxl.biff.DisplayFormat |
EXPONENTIAL |
Formatting for exponential or scientific notation
Equivalent to a DecimalFormat "0.00E00"
|
static jxl.biff.DisplayFormat |
FLOAT |
Formatting for a float.
|
static jxl.biff.DisplayFormat |
FORMAT1 |
Equivalent to a DecimalFormat "#,##0;(#,##0)"
|
static jxl.biff.DisplayFormat |
FORMAT10 |
Equivalent to DecimalFormat "##0.0E0"
|
static jxl.biff.DisplayFormat |
FORMAT2 |
Equivalent to FORMAT1 except deficits are coloured red
|
static jxl.biff.DisplayFormat |
FORMAT3 |
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
|
static jxl.biff.DisplayFormat |
FORMAT4 |
Equivalent to FORMAT3 except deficits are coloured red
|
static jxl.biff.DisplayFormat |
FORMAT5 |
Equivalent to DecimalFormat "#,##0;(#,##0)"
|
static jxl.biff.DisplayFormat |
FORMAT6 |
Equivalent to FORMAT5 except deficits are coloured red
|
static jxl.biff.DisplayFormat |
FORMAT7 |
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
|
static jxl.biff.DisplayFormat |
FORMAT8 |
Equivalent to FORMAT7 except deficits are coloured red
|
static jxl.biff.DisplayFormat |
FORMAT9 |
Equivalent to FORMAT7
|
static jxl.biff.DisplayFormat |
FRACTION_ONE_DIGIT |
Formatting for one digit fractions
|
static jxl.biff.DisplayFormat |
FRACTION_TWO_DIGITS |
Formatting for two digit fractions
|
static jxl.biff.DisplayFormat |
INTEGER |
Formatting for an integer number.
|
static jxl.biff.DisplayFormat |
PERCENT_FLOAT |
Formatting for a float percentage
Equivalent to a DecimalFormat "0.00%"
|
static jxl.biff.DisplayFormat |
PERCENT_INTEGER |
Formatting for an integer presented as a percentage
Equivalent to a DecimalFormat of "0%"
|
static jxl.biff.DisplayFormat |
TEXT |
Forces numbers to be interpreted as text
|
static jxl.biff.DisplayFormat |
THOUSANDS_FLOAT |
Formatting for a float that has a thousands separator.
|
static jxl.biff.DisplayFormat |
THOUSANDS_INTEGER |
Formatting for an integer that has a thousands separator.
|
Constructor | Description |
---|---|
NumberFormats() |
public static final jxl.biff.DisplayFormat DEFAULT
public static final jxl.biff.DisplayFormat INTEGER
public static final jxl.biff.DisplayFormat FLOAT
public static final jxl.biff.DisplayFormat THOUSANDS_INTEGER
public static final jxl.biff.DisplayFormat THOUSANDS_FLOAT
public static final jxl.biff.DisplayFormat ACCOUNTING_INTEGER
public static final jxl.biff.DisplayFormat ACCOUNTING_RED_INTEGER
public static final jxl.biff.DisplayFormat ACCOUNTING_FLOAT
public static final jxl.biff.DisplayFormat ACCOUNTING_RED_FLOAT
public static final jxl.biff.DisplayFormat PERCENT_INTEGER
public static final jxl.biff.DisplayFormat PERCENT_FLOAT
public static final jxl.biff.DisplayFormat EXPONENTIAL
public static final jxl.biff.DisplayFormat FRACTION_ONE_DIGIT
public static final jxl.biff.DisplayFormat FRACTION_TWO_DIGITS
public static final jxl.biff.DisplayFormat FORMAT1
public static final jxl.biff.DisplayFormat FORMAT2
public static final jxl.biff.DisplayFormat FORMAT3
public static final jxl.biff.DisplayFormat FORMAT4
public static final jxl.biff.DisplayFormat FORMAT5
public static final jxl.biff.DisplayFormat FORMAT6
public static final jxl.biff.DisplayFormat FORMAT7
public static final jxl.biff.DisplayFormat FORMAT8
public static final jxl.biff.DisplayFormat FORMAT9
public static final jxl.biff.DisplayFormat FORMAT10
public static final jxl.biff.DisplayFormat TEXT