Package 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
Fields 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 redstatic jxl.biff.DisplayFormat
ACCOUNTING_RED_INTEGER
As ACCOUNTING_INTEGER except that deficits appear coloured redstatic 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 redstatic jxl.biff.DisplayFormat
FORMAT3
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"static jxl.biff.DisplayFormat
FORMAT4
Equivalent to FORMAT3 except deficits are coloured redstatic jxl.biff.DisplayFormat
FORMAT5
Equivalent to DecimalFormat "#,##0;(#,##0)"static jxl.biff.DisplayFormat
FORMAT6
Equivalent to FORMAT5 except deficits are coloured redstatic jxl.biff.DisplayFormat
FORMAT7
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"static jxl.biff.DisplayFormat
FORMAT8
Equivalent to FORMAT7 except deficits are coloured redstatic jxl.biff.DisplayFormat
FORMAT9
Equivalent to FORMAT7static jxl.biff.DisplayFormat
FRACTION_ONE_DIGIT
Formatting for one digit fractionsstatic jxl.biff.DisplayFormat
FRACTION_TWO_DIGITS
Formatting for two digit fractionsstatic 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 textstatic 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
Constructors Constructor Description NumberFormats()
-
-
-
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
-
-