ActiveXLS.Constants
Class Format

System.Object
  ActiveXLS.Constants.Format

public class Format

extends System.Object

This class contains the constants for number and date format when formatting cells.

Constant Summary

const System.String	FORMAT_AS_HALVES The value of the cell is displayed as a fraction /2.
const System.String	FORMAT_AS_QUARTERS The value of the cell is displayed as a fraction /4.
const System.String	FORMAT_AS_TENTHS The value of the cell is displayed as a fraction /10.
const System.String	FORMAT_CURRENCY The value of the cell is displayed as a float having 2 decimals preceded by the "$" symbol.
const System.String	FORMAT_DATE The value of the cell is displayed in date format.
const System.String	FORMAT_DATE_TIME The value of the cell is displayed in date-time format.
const System.String	FORMAT_FLOAT_2DECIMALS The value of the cell is displayed as a float having 2 decimals.
const System.String	FORMAT_FLOAT_2DECIMALS_PERCENT The value of the cell is displayed as a float having 2 decimals followed by the percent symbol.
const System.String	FORMAT_GENERAL General format of a cell value.
const System.String	FORMAT_INTEGER The value of the cell is displayed as an integer.
const System.String	FORMAT_INTEGER_PERCENT The value of the cell is displayed as an integer followed by the percent symbol.

Constructor Summary

Format()

Constant Detail

FORMAT_GENERAL

public const System.String FORMAT_GENERAL

General format of a cell value. Embedded value is "General".

See Also:

Constant Values

FORMAT_INTEGER

public const System.String FORMAT_INTEGER

The value of the cell is displayed as an integer. Embedded value is "0".

See Also:

Constant Values

FORMAT_FLOAT_2DECIMALS

public const System.String FORMAT_FLOAT_2DECIMALS

The value of the cell is displayed as a float having 2 decimals. Embedded value is "0.00".

See Also:

Constant Values

FORMAT_INTEGER_PERCENT

public const System.String FORMAT_INTEGER_PERCENT

The value of the cell is displayed as an integer followed by the percent symbol. Embedded value is "0%".

See Also:

Constant Values

FORMAT_FLOAT_2DECIMALS_PERCENT

public const System.String FORMAT_FLOAT_2DECIMALS_PERCENT

The value of the cell is displayed as a float having 2 decimals followed by the percent symbol. Embedded value is "0.00%".

See Also:

Constant Values

FORMAT_DATE

public const System.String FORMAT_DATE

The value of the cell is displayed in date format. Embedded value is "MM/dd/yyyy".

See Also:

Constant Values

FORMAT_DATE_TIME

public const System.String FORMAT_DATE_TIME

The value of the cell is displayed in date-time format. Embedded value is "MM/dd/yyyy HH:mm:ss".

See Also:

Constant Values

FORMAT_CURRENCY

public const System.String FORMAT_CURRENCY

The value of the cell is displayed as a float having 2 decimals preceded by the "$" symbol. Embedded value is "$0.00".

See Also:

Constant Values

FORMAT_AS_HALVES

public const System.String FORMAT_AS_HALVES

The value of the cell is displayed as a fraction /2. Embedded value is "# ?/2".

See Also:

Constant Values

FORMAT_AS_QUARTERS

public const System.String FORMAT_AS_QUARTERS

The value of the cell is displayed as a fraction /4. Embedded value is "# ?/4".

See Also:

Constant Values

FORMAT_AS_TENTHS

public const System.String FORMAT_AS_TENTHS

The value of the cell is displayed as a fraction /10. Embedded value is "# ?/10".

See Also:

Constant Values

Constructor Detail

Format

public Format()