jexcelapi_2_3_10 Documentation: Class NumberFormats

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: INNER | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

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

Inner Class Summary

private static class NumberFormats.BuiltInFormat
          Inner class which holds the format index

Field Summary

static DisplayFormat ACCOUNTING_FLOAT
          Formatting for an integer which is presented in accounting format (ie.

static DisplayFormat ACCOUNTING_INTEGER
          Formatting for an integer which is presented in accounting format (ie.

static DisplayFormat ACCOUNTING_RED_FLOAT
          As ACCOUNTING_FLOAT except that deficits appear coloured red

static DisplayFormat ACCOUNTING_RED_INTEGER
          As ACCOUNTING_INTEGER except that deficits appear coloured red

static DisplayFormat DEFAULT
          The default format.

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

static DisplayFormat FLOAT
          Formatting for a float.

static DisplayFormat FORMAT1
          Equivalent to a DecimalFormat "#,##0;(#,##0)"

static DisplayFormat FORMAT10
          Equivalent to DecimalFormat "##0.0E0"

static DisplayFormat FORMAT2
          Equivalent to FORMAT1 except deficits are coloured red

static DisplayFormat FORMAT3
          Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"

static DisplayFormat FORMAT4
          Equivalent to FORMAT3 except deficits are coloured red

static DisplayFormat FORMAT5
          Equivalent to DecimalFormat "#,##0;(#,##0)"

static DisplayFormat FORMAT6
          Equivalent to FORMAT5 except deficits are coloured red

static DisplayFormat FORMAT7
          Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"

static DisplayFormat FORMAT8
          Equivalent to FORMAT7 except deficits are coloured red

static DisplayFormat FORMAT9
          Equivalent to FORMAT7

static DisplayFormat INTEGER
          Formatting for an integer number.

static DisplayFormat PERCENT_FLOAT
          Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"

static DisplayFormat PERCENT_INTEGER
          Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"

static DisplayFormat TEXT
          Forces numbers to be interpreted as text

static DisplayFormat THOUSANDS_FLOAT
          Formatting for a float that has a thousands separator.

static DisplayFormat THOUSANDS_INTEGER
          Formatting for an integer that has a thousands separator.

Constructor Summary

NumberFormats()


Methods inherited from class java.lang.Object

, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait

Field Detail

DEFAULT

public static DisplayFormat DEFAULT

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

INTEGER

public static DisplayFormat INTEGER

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

FLOAT

public static 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 DisplayFormat THOUSANDS_INTEGER

Formatting for an integer that has a thousands separator. Equivalent to a DecimalFormat of "#,##0"

THOUSANDS_FLOAT

public static DisplayFormat THOUSANDS_FLOAT

Formatting for a float that has a thousands separator. Equivalent to a DecimalFormat of "#,##0.00"

ACCOUNTING_INTEGER

public static 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 DisplayFormat ACCOUNTING_RED_INTEGER

As ACCOUNTING_INTEGER except that deficits appear coloured red

ACCOUNTING_FLOAT

public static 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 DisplayFormat ACCOUNTING_RED_FLOAT

As ACCOUNTING_FLOAT except that deficits appear coloured red

PERCENT_INTEGER

public static DisplayFormat PERCENT_INTEGER

Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"

PERCENT_FLOAT

public static DisplayFormat PERCENT_FLOAT

Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"

EXPONENTIAL

public static DisplayFormat EXPONENTIAL

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

FORMAT1

public static DisplayFormat FORMAT1

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

FORMAT2

public static DisplayFormat FORMAT2

Equivalent to FORMAT1 except deficits are coloured red

FORMAT3

public static DisplayFormat FORMAT3

Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"

FORMAT4

public static DisplayFormat FORMAT4

Equivalent to FORMAT3 except deficits are coloured red

FORMAT5

public static DisplayFormat FORMAT5

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

FORMAT6

public static DisplayFormat FORMAT6

Equivalent to FORMAT5 except deficits are coloured red

FORMAT7

public static DisplayFormat FORMAT7