Package jxl.write

Class NumberFormats

java.lang.Object
jxl.write.NumberFormats

public final class NumberFormats extends Object
Static class which contains the available list of built in Number formats
  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    static 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 red
    static final jxl.biff.DisplayFormat
    As ACCOUNTING_INTEGER except that deficits appear coloured red
    static 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 red
    static final jxl.biff.DisplayFormat
    Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
    static final jxl.biff.DisplayFormat
    Equivalent to FORMAT3 except deficits are coloured red
    static final jxl.biff.DisplayFormat
    Equivalent to DecimalFormat "#,##0;(#,##0)"
    static final jxl.biff.DisplayFormat
    Equivalent to FORMAT5 except deficits are coloured red
    static final jxl.biff.DisplayFormat
    Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
    static final jxl.biff.DisplayFormat
    Equivalent to FORMAT7 except deficits are coloured red
    static final jxl.biff.DisplayFormat
    Equivalent to FORMAT7
    static final jxl.biff.DisplayFormat
    Formatting for one digit fractions
    static final jxl.biff.DisplayFormat
    Formatting for two digit fractions
    static 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 text
    static 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
    Constructor
    Description
     
  • Method Summary

    Methods inherited from class java.lang.Object

    equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
  • Field Details

    • 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 Details

    • NumberFormats

      public NumberFormats()