jxl.write
Class NumberFormats

java.lang.Object
  jxl.write.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.

Constructor Summary

NumberFormats()

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

DEFAULT

public static final jxl.biff.DisplayFormat DEFAULT

The default format. This is equivalent to a number format of '#'

INTEGER

public static final jxl.biff.DisplayFormat INTEGER

Formatting for an integer number. This is equivalent to a DecimalFormat of "0"

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"

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"

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"

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_INTEGER

public static final jxl.biff.DisplayFormat ACCOUNTING_RED_INTEGER

As ACCOUNTING_INTEGER except that deficits appear coloured red

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_RED_FLOAT

public static final jxl.biff.DisplayFormat ACCOUNTING_RED_FLOAT

As ACCOUNTING_FLOAT except that deficits appear coloured red

PERCENT_INTEGER

public static final jxl.biff.DisplayFormat PERCENT_INTEGER

Formatting for an integer presented as a percentage 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%"

EXPONENTIAL

public static final jxl.biff.DisplayFormat EXPONENTIAL

Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00"

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

FORMAT1

public static final jxl.biff.DisplayFormat FORMAT1

Equivalent to a DecimalFormat "#,##0;(#,##0)"

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

FORMAT10

public static final jxl.biff.DisplayFormat FORMAT10

Equivalent to DecimalFormat "##0.0E0"

TEXT

public static final jxl.biff.DisplayFormat TEXT

Forces numbers to be interpreted as text

Constructor Detail

NumberFormats

public NumberFormats()