Package ch.rabanti.picoxlsx4j.style
Enum NumberFormat.FormatNumber
- java.lang.Object
-
- java.lang.Enum<NumberFormat.FormatNumber>
-
- ch.rabanti.picoxlsx4j.style.NumberFormat.FormatNumber
-
- All Implemented Interfaces:
Serializable,Comparable<NumberFormat.FormatNumber>
- Enclosing class:
- NumberFormat
public static enum NumberFormat.FormatNumber extends Enum<NumberFormat.FormatNumber>
Enum for predefined number formatsThere are other predefined formats (e.g. 43 and 44) that are not listed. The declaration of such formats is done in the number formats section of the style document, whereas the officially listed ones are implicitly used and not declared in the style document
-
-
Enum Constant Summary
Enum Constants Enum Constant Description customCustom Format (ID 164 and higher)format_1Format: 0format_10Format: 0.00%format_11Format: 0.00E+00format_12Format: # ?format_13Format: # ??format_14Format: m/d/yyyyformat_15Format: d-mmm-yyformat_16Format: d-mmmformat_17Format: mmm-yyformat_18Format: mm AM/PMformat_19Format: h:mm:ss AM/PMformat_2Format: 0.00format_20Format: h:mmformat_21Format: h:mm:ssformat_22Format: m/d/yyyy h:mmformat_3Format: #,##0format_37Format: #,##0_);(#,##0)format_38Format: #,##0_);[Red](#,##0)format_39Format: #,##0.00_);(#,##0.00)format_4Format: #,##0.00format_40Format: #,##0.00_);[Red](#,##0.00)format_45Format: mm:ssformat_46Format: [h]:mm:ssformat_47Format: mm:ss.0format_48Format: ##0.0E+0format_49Format: #format_5Format: $#,##0_);($#,##0)format_6Format: $#,##0_);[Red]($#,##0)format_7Format: $#,##0.00_);($#,##0.00)format_8Format: $#,##0.00_);[Red]($#,##0.00)format_9Format: 0%noneNo format / Default
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description intgetValue()Gets the numeric value of the enum entrystatic NumberFormat.FormatNumbervalueOf(String name)Returns the enum constant of this type with the specified name.static NumberFormat.FormatNumber[]values()Returns an array containing the constants of this enum type, in the order they are declared.
-
-
-
Enum Constant Detail
-
none
public static final NumberFormat.FormatNumber none
No format / Default
-
format_1
public static final NumberFormat.FormatNumber format_1
Format: 0
-
format_2
public static final NumberFormat.FormatNumber format_2
Format: 0.00
-
format_3
public static final NumberFormat.FormatNumber format_3
Format: #,##0
-
format_4
public static final NumberFormat.FormatNumber format_4
Format: #,##0.00
-
format_5
public static final NumberFormat.FormatNumber format_5
Format: $#,##0_);($#,##0)
-
format_6
public static final NumberFormat.FormatNumber format_6
Format: $#,##0_);[Red]($#,##0)
-
format_7
public static final NumberFormat.FormatNumber format_7
Format: $#,##0.00_);($#,##0.00)
-
format_8
public static final NumberFormat.FormatNumber format_8
Format: $#,##0.00_);[Red]($#,##0.00)
-
format_9
public static final NumberFormat.FormatNumber format_9
Format: 0%
-
format_10
public static final NumberFormat.FormatNumber format_10
Format: 0.00%
-
format_11
public static final NumberFormat.FormatNumber format_11
Format: 0.00E+00
-
format_12
public static final NumberFormat.FormatNumber format_12
Format: # ?/?
-
format_13
public static final NumberFormat.FormatNumber format_13
Format: # ??/??
-
format_14
public static final NumberFormat.FormatNumber format_14
Format: m/d/yyyy
-
format_15
public static final NumberFormat.FormatNumber format_15
Format: d-mmm-yy
-
format_16
public static final NumberFormat.FormatNumber format_16
Format: d-mmm
-
format_17
public static final NumberFormat.FormatNumber format_17
Format: mmm-yy
-
format_18
public static final NumberFormat.FormatNumber format_18
Format: mm AM/PM
-
format_19
public static final NumberFormat.FormatNumber format_19
Format: h:mm:ss AM/PM
-
format_20
public static final NumberFormat.FormatNumber format_20
Format: h:mm
-
format_21
public static final NumberFormat.FormatNumber format_21
Format: h:mm:ss
-
format_22
public static final NumberFormat.FormatNumber format_22
Format: m/d/yyyy h:mm
-
format_37
public static final NumberFormat.FormatNumber format_37
Format: #,##0_);(#,##0)
-
format_38
public static final NumberFormat.FormatNumber format_38
Format: #,##0_);[Red](#,##0)
-
format_39
public static final NumberFormat.FormatNumber format_39
Format: #,##0.00_);(#,##0.00)
-
format_40
public static final NumberFormat.FormatNumber format_40
Format: #,##0.00_);[Red](#,##0.00)
-
format_45
public static final NumberFormat.FormatNumber format_45
Format: mm:ss
-
format_46
public static final NumberFormat.FormatNumber format_46
Format: [h]:mm:ss
-
format_47
public static final NumberFormat.FormatNumber format_47
Format: mm:ss.0
-
format_48
public static final NumberFormat.FormatNumber format_48
Format: ##0.0E+0
-
format_49
public static final NumberFormat.FormatNumber format_49
Format: #
-
custom
public static final NumberFormat.FormatNumber custom
Custom Format (ID 164 and higher)
-
-
Method Detail
-
values
public static NumberFormat.FormatNumber[] values()
Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:for (NumberFormat.FormatNumber c : NumberFormat.FormatNumber.values()) System.out.println(c);
- Returns:
- an array containing the constants of this enum type, in the order they are declared
-
valueOf
public static NumberFormat.FormatNumber valueOf(String name)
Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)- Parameters:
name- the name of the enum constant to be returned.- Returns:
- the enum constant with the specified name
- Throws:
IllegalArgumentException- if this enum type has no constant with the specified nameNullPointerException- if the argument is null
-
getValue
public int getValue()
Gets the numeric value of the enum entry- Returns:
- Numeric value of the enum entry
-
-