xl.write
Class NumberFormats

System.Object
  extended byxl.write.NumberFormats

public sealed class NumberFormats
extends System.Object

Static class which contains the available list of built in Number formats


Field Summary
static xl.biff.DisplayFormat ACCOUNTING_FLOAT
          Formatting for an integer which is presented in accounting format
static xl.biff.DisplayFormat ACCOUNTING_INTEGER
          Formatting for an integer which is presented in accounting format
static xl.biff.DisplayFormat ACCOUNTING_RED_FLOAT
          As ACCOUNTING_FLOAT except that deficits appear colored red
static xl.biff.DisplayFormat ACCOUNTING_RED_INTEGER
          As ACCOUNTING_INTEGER except that deficits appear colored red
static xl.biff.DisplayFormat DEFAULT
          The default format.
static xl.biff.DisplayFormat EXPONENTIAL
          Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00"
static xl.biff.DisplayFormat FLOAT
          Formatting for a float.
static xl.biff.DisplayFormat FORMAT1
          Equivalent to a DecimalFormat "#,##0;(#,##0)"
static xl.biff.DisplayFormat FORMAT10
          Equivalent to DecimalFormat "##0.0E0"
static xl.biff.DisplayFormat FORMAT2
          Equivalent to FORMAT1 except deficits are colored red
static xl.biff.DisplayFormat FORMAT3
          Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
static xl.biff.DisplayFormat FORMAT4
          Equivalent to FORMAT3 except deficits are colored red
static xl.biff.DisplayFormat FORMAT5
          Equivalent to DecimalFormat "#,##0;(#,##0)"
static xl.biff.DisplayFormat FORMAT6
          Equivalent to FORMAT5 except deficits are colored red
static xl.biff.DisplayFormat FORMAT7
          Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"
static xl.biff.DisplayFormat FORMAT8
          Equivalent to FORMAT7 except deficits are colored red
static xl.biff.DisplayFormat FORMAT9
          Equivalent to FORMAT7
static xl.biff.DisplayFormat FRACTION_ONE_DIGIT
          Formatting for one digit fractions
static xl.biff.DisplayFormat FRACTION_TWO_DIGITS
          Formatting for two digit fractions
static xl.biff.DisplayFormat INTEGER
          Formatting for an integer number.
static xl.biff.DisplayFormat PERCENT_FLOAT
          Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"
static xl.biff.DisplayFormat PERCENT_INTEGER
          Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"
static xl.biff.DisplayFormat TEXT
          Forces numbers to be interpreted as text
static xl.biff.DisplayFormat THOUSANDS_FLOAT
          Formatting for a float that has a thousands separator.
static xl.biff.DisplayFormat THOUSANDS_INTEGER
          Formatting for an integer that has a thousands separator.
 
Constructor Summary
NumberFormats()
           
 
Methods inherited from class System.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

DEFAULT

public static readonly xl.biff.DisplayFormat DEFAULT
The default format. This is equivalent to a number format of '#'


INTEGER

public static readonly xl.biff.DisplayFormat INTEGER
Formatting for an integer number. This is equivalent to a DecimalFormat of "0"


FLOAT

public static readonly xl.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 readonly xl.biff.DisplayFormat THOUSANDS_INTEGER
Formatting for an integer that has a thousands separator. Equivalent to a DecimalFormat of "#,##0"


THOUSANDS_FLOAT

public static readonly xl.biff.DisplayFormat THOUSANDS_FLOAT
Formatting for a float that has a thousands separator. Equivalent to a DecimalFormat of "#,##0.00"


ACCOUNTING_INTEGER

public static readonly xl.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 readonly xl.biff.DisplayFormat ACCOUNTING_RED_INTEGER
As ACCOUNTING_INTEGER except that deficits appear colored red


ACCOUNTING_FLOAT

public static readonly xl.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 readonly xl.biff.DisplayFormat ACCOUNTING_RED_FLOAT
As ACCOUNTING_FLOAT except that deficits appear colored red


PERCENT_INTEGER

public static readonly xl.biff.DisplayFormat PERCENT_INTEGER
Formatting for an integer presented as a percentage Equivalent to a DecimalFormat of "0%"


PERCENT_FLOAT

public static readonly xl.biff.DisplayFormat PERCENT_FLOAT
Formatting for a float percentage Equivalent to a DecimalFormat "0.00%"


EXPONENTIAL

public static readonly xl.biff.DisplayFormat EXPONENTIAL
Formatting for exponential or scientific notation Equivalent to a DecimalFormat "0.00E00"


FRACTION_ONE_DIGIT

public static readonly xl.biff.DisplayFormat FRACTION_ONE_DIGIT
Formatting for one digit fractions


FRACTION_TWO_DIGITS

public static readonly xl.biff.DisplayFormat FRACTION_TWO_DIGITS
Formatting for two digit fractions


FORMAT1

public static readonly xl.biff.DisplayFormat FORMAT1
Equivalent to a DecimalFormat "#,##0;(#,##0)"


FORMAT2

public static readonly xl.biff.DisplayFormat FORMAT2
Equivalent to FORMAT1 except deficits are colored red


FORMAT3

public static readonly xl.biff.DisplayFormat FORMAT3
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"


FORMAT4

public static readonly xl.biff.DisplayFormat FORMAT4
Equivalent to FORMAT3 except deficits are colored red


FORMAT5

public static readonly xl.biff.DisplayFormat FORMAT5
Equivalent to DecimalFormat "#,##0;(#,##0)"


FORMAT6

public static readonly xl.biff.DisplayFormat FORMAT6
Equivalent to FORMAT5 except deficits are colored red


FORMAT7

public static readonly xl.biff.DisplayFormat FORMAT7
Equivalent to DecimalFormat "#,##0.00;(#,##0.00)"


FORMAT8

public static readonly xl.biff.DisplayFormat FORMAT8
Equivalent to FORMAT7 except deficits are colored red


FORMAT9

public static readonly xl.biff.DisplayFormat FORMAT9
Equivalent to FORMAT7


FORMAT10

public static readonly xl.biff.DisplayFormat FORMAT10
Equivalent to DecimalFormat "##0.0E0"


TEXT

public static readonly xl.biff.DisplayFormat TEXT
Forces numbers to be interpreted as text

Constructor Detail

NumberFormats

public NumberFormats()