Package jxl.write
Class NumberFormats
java.lang.Object
jxl.write.NumberFormats
Static class which contains the available list of built in Number formats
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final jxl.biff.DisplayFormat
Formatting for an integer which is presented in accounting format (ie.static final jxl.biff.DisplayFormat
Formatting for an integer which is presented in accounting format (ie.static final jxl.biff.DisplayFormat
As ACCOUNTING_FLOAT except that deficits appear coloured redstatic final jxl.biff.DisplayFormat
As ACCOUNTING_INTEGER except that deficits appear coloured redstatic final jxl.biff.DisplayFormat
The default format.static final jxl.biff.DisplayFormat
Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00"static final jxl.biff.DisplayFormat
Formatting for a float.static final jxl.biff.DisplayFormat
Equivalent to a DecimalFormat "#,##0;(#,##0)"static final jxl.biff.DisplayFormat
Equivalent to DecimalFormat "##0.0E0"static final jxl.biff.DisplayFormat
Equivalent to FORMAT1 except deficits are coloured redstatic final jxl.biff.DisplayFormat
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"static final jxl.biff.DisplayFormat
Equivalent to FORMAT3 except deficits are coloured redstatic final jxl.biff.DisplayFormat
Equivalent to DecimalFormat "#,##0;(#,##0)"static final jxl.biff.DisplayFormat
Equivalent to FORMAT5 except deficits are coloured redstatic final jxl.biff.DisplayFormat
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"static final jxl.biff.DisplayFormat
Equivalent to FORMAT7 except deficits are coloured redstatic final jxl.biff.DisplayFormat
Equivalent to FORMAT7static final jxl.biff.DisplayFormat
Formatting for one digit fractionsstatic final jxl.biff.DisplayFormat
Formatting for two digit fractionsstatic final jxl.biff.DisplayFormat
Formatting for an integer number.static final jxl.biff.DisplayFormat
Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"static final jxl.biff.DisplayFormat
Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"static final jxl.biff.DisplayFormat
Forces numbers to be interpreted as textstatic final jxl.biff.DisplayFormat
Formatting for a float that has a thousands separator.static final jxl.biff.DisplayFormat
Formatting for an integer that has a thousands separator. -
Constructor Summary
Constructors -
Method Summary
-
Field Details
-
DEFAULT
public static final jxl.biff.DisplayFormat DEFAULTThe default format. This is equivalent to a number format of '#' -
INTEGER
public static final jxl.biff.DisplayFormat INTEGERFormatting for an integer number. This is equivalent to a DecimalFormat of "0" -
FLOAT
public static final jxl.biff.DisplayFormat FLOATFormatting 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_INTEGERFormatting for an integer that has a thousands separator. Equivalent to a DecimalFormat of "#,##0" -
THOUSANDS_FLOAT
public static final jxl.biff.DisplayFormat THOUSANDS_FLOATFormatting for a float that has a thousands separator. Equivalent to a DecimalFormat of "#,##0.00" -
ACCOUNTING_INTEGER
public static final jxl.biff.DisplayFormat ACCOUNTING_INTEGERFormatting 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_INTEGERAs ACCOUNTING_INTEGER except that deficits appear coloured red -
ACCOUNTING_FLOAT
public static final jxl.biff.DisplayFormat ACCOUNTING_FLOATFormatting 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_FLOATAs ACCOUNTING_FLOAT except that deficits appear coloured red -
PERCENT_INTEGER
public static final jxl.biff.DisplayFormat PERCENT_INTEGERFormatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%" -
PERCENT_FLOAT
public static final jxl.biff.DisplayFormat PERCENT_FLOATFormatting for a float percentage Equivalent to a DecimalFormat "0.00%" -
EXPONENTIAL
public static final jxl.biff.DisplayFormat EXPONENTIALFormatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00" -
FRACTION_ONE_DIGIT
public static final jxl.biff.DisplayFormat FRACTION_ONE_DIGITFormatting for one digit fractions -
FRACTION_TWO_DIGITS
public static final jxl.biff.DisplayFormat FRACTION_TWO_DIGITSFormatting for two digit fractions -
FORMAT1
public static final jxl.biff.DisplayFormat FORMAT1Equivalent to a DecimalFormat "#,##0;(#,##0)" -
FORMAT2
public static final jxl.biff.DisplayFormat FORMAT2Equivalent to FORMAT1 except deficits are coloured red -
FORMAT3
public static final jxl.biff.DisplayFormat FORMAT3Equivalent to DecimalFormat "#,##0.00;(#,##0.00)" -
FORMAT4
public static final jxl.biff.DisplayFormat FORMAT4Equivalent to FORMAT3 except deficits are coloured red -
FORMAT5
public static final jxl.biff.DisplayFormat FORMAT5Equivalent to DecimalFormat "#,##0;(#,##0)" -
FORMAT6
public static final jxl.biff.DisplayFormat FORMAT6Equivalent to FORMAT5 except deficits are coloured red -
FORMAT7
public static final jxl.biff.DisplayFormat FORMAT7Equivalent to DecimalFormat "#,##0.00;(#,##0.00)" -
FORMAT8
public static final jxl.biff.DisplayFormat FORMAT8Equivalent to FORMAT7 except deficits are coloured red -
FORMAT9
public static final jxl.biff.DisplayFormat FORMAT9Equivalent to FORMAT7 -
FORMAT10
public static final jxl.biff.DisplayFormat FORMAT10Equivalent to DecimalFormat "##0.0E0" -
TEXT
public static final jxl.biff.DisplayFormat TEXTForces numbers to be interpreted as text
-
-
Constructor Details
-
NumberFormats
public NumberFormats()
-