Package jxl.write

Class 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 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

      Constructors 
      Constructor Description
      NumberFormats()  

    • Method Summary

      • 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()