Namespace EasyXLS.Constants

Class 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

    • Field 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_REGIONAL_SETTINGS

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