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