Namespace EasyXLS.Constants

Class Format

System.Object

EasyXLS.Constants.Format

public class Format
extends System.Object

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

Constant Summary

Fields

Modifier and Type	Field	Description
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_AND_TIME_REGIONAL_SETTINGS	The value of the cell is displayed in the date format from regional settings with time included.
const System.String	FORMAT_DATE_REGIONAL_SETTINGS	The value of the cell is displayed in the date format from regional settings.
const System.String	FORMAT_DATE_TIME	The value of the cell is displayed in date-time format.
const System.String	FORMAT_DATE_TIME_REGIONAL_SETTINGS	The value of the cell is displayed in the date-time format from regional settings.
const System.String	FORMAT_DATE_WEEKDAY_REGIONAL_SETTINGS	The value of the cell is displayed in the date format from regional settings, including day of the week.
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

Constructors

Constructor	Description
Format()

Method Summary

Methods inherited from class System.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

FORMAT_GENERAL

public const final System.String FORMAT_GENERAL

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

See Also:

• Constant Values

FORMAT_INTEGER

public const final 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 final 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 final 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 final 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_REGIONAL_SETTINGS

public const final System.String FORMAT_DATE_REGIONAL_SETTINGS

The value of the cell is displayed in the date format from regional settings. Embedded value is "Short Date".

See Also:

• Constant Values

FORMAT_DATE_WEEKDAY_REGIONAL_SETTINGS

public const final System.String FORMAT_DATE_WEEKDAY_REGIONAL_SETTINGS

The value of the cell is displayed in the date format from regional settings, including day of the week. Embedded value is "[$-F800]dddd\,\ mmmm\ dd\,\ yyyy".

See Also:

• Constant Values

FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS

public const final System.String FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS

The value of the cell is displayed in the date format from regional settings with time included. Embedded value is "General Date".

See Also:

• Constant Values

FORMAT_DATE

public const final 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_REGIONAL_SETTINGS

public const final System.String FORMAT_DATE_TIME_REGIONAL_SETTINGS

The value of the cell is displayed in the date-time format from regional settings. Embedded value is "[$-F400]h:mm:ss\ AM/PM".

See Also:

• Constant Values

FORMAT_DATE_TIME

public const final 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 final 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 final 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 final 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 final 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 Details

Format

public Format()