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_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

      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

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