jxl.write

Class NumberFormats


public final class NumberFormats
extends java.lang.Object

Static class which contains the available list of built in Number formats

Field Summary

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.

Field Details

ACCOUNTING_FLOAT

public static final jxl.biff.DisplayFormat ACCOUNTING_FLOAT
Formatting for an integer which is presented in accounting format (ie. deficits appear in parentheses) Equivalent to a DecimalFormat of "$#,##0;($#,##0)"

ACCOUNTING_INTEGER

public static final jxl.biff.DisplayFormat ACCOUNTING_INTEGER
Formatting for an integer which is presented in accounting format (ie. deficits appear in parentheses) Equivalent to a DecimalFormat of "$#,##0;($#,##0)"

ACCOUNTING_RED_FLOAT

public static final jxl.biff.DisplayFormat ACCOUNTING_RED_FLOAT
As ACCOUNTING_FLOAT except that deficits appear coloured red

ACCOUNTING_RED_INTEGER

public static final jxl.biff.DisplayFormat ACCOUNTING_RED_INTEGER
As ACCOUNTING_INTEGER except that deficits appear coloured red

DEFAULT

public static final jxl.biff.DisplayFormat DEFAULT
The default format. This is equivalent to a number format of '#'

EXPONENTIAL

public static final jxl.biff.DisplayFormat EXPONENTIAL
Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00"

FLOAT

public static final jxl.biff.DisplayFormat FLOAT
Formatting for a float. This formats number to two decimal places. It is equivalent to a DecimalFormat of "0.00"

FORMAT1

public static final jxl.biff.DisplayFormat FORMAT1
Equivalent to a DecimalFormat "#,##0;(#,##0)"

FORMAT10

public static final jxl.biff.DisplayFormat FORMAT10
Equivalent to DecimalFormat "##0.0E0"

FORMAT2

public static final jxl.biff.DisplayFormat FORMAT2
Equivalent to FORMAT1 except deficits are coloured red

FORMAT3

public static final jxl.biff.DisplayFormat FORMAT3
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"

FORMAT4

public static final jxl.biff.DisplayFormat FORMAT4
Equivalent to FORMAT3 except deficits are coloured red

FORMAT5

public static final jxl.biff.DisplayFormat FORMAT5
Equivalent to DecimalFormat "#,##0;(#,##0)"

FORMAT6

public static final jxl.biff.DisplayFormat FORMAT6
Equivalent to FORMAT5 except deficits are coloured red

FORMAT7

public static final jxl.biff.DisplayFormat FORMAT7
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"

FORMAT8

public static final jxl.biff.DisplayFormat FORMAT8
Equivalent to FORMAT7 except deficits are coloured red

FORMAT9

public static final jxl.biff.DisplayFormat FORMAT9
Equivalent to FORMAT7

FRACTION_ONE_DIGIT

public static final jxl.biff.DisplayFormat FRACTION_ONE_DIGIT
Formatting for one digit fractions

FRACTION_TWO_DIGITS

public static final jxl.biff.DisplayFormat FRACTION_TWO_DIGITS
Formatting for two digit fractions

INTEGER

public static final jxl.biff.DisplayFormat INTEGER
Formatting for an integer number. This is equivalent to a DecimalFormat of "0"

PERCENT_FLOAT

public static final jxl.biff.DisplayFormat PERCENT_FLOAT
Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"

PERCENT_INTEGER

public static final jxl.biff.DisplayFormat PERCENT_INTEGER
Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"

TEXT

public static final jxl.biff.DisplayFormat TEXT
Forces numbers to be interpreted as text

THOUSANDS_FLOAT

public static final jxl.biff.DisplayFormat THOUSANDS_FLOAT
Formatting for a float that has a thousands separator. Equivalent to a DecimalFormat of "#,##0.00"

THOUSANDS_INTEGER

public static final jxl.biff.DisplayFormat THOUSANDS_INTEGER
Formatting for an integer that has a thousands separator. Equivalent to a DecimalFormat of "#,##0"