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 custom
Custom Format (ID 164 and higher)format_1
Format: 0format_10
Format: 0.00%format_11
Format: 0.00E+00format_12
Format: # ?format_13
Format: # ??format_14
Format: m/d/yyyyformat_15
Format: d-mmm-yyformat_16
Format: d-mmmformat_17
Format: mmm-yyformat_18
Format: mm AM/PMformat_19
Format: h:mm:ss AM/PMformat_2
Format: 0.00format_20
Format: h:mmformat_21
Format: h:mm:ssformat_22
Format: m/d/yyyy h:mmformat_3
Format: #,##0format_37
Format: #,##0_);(#,##0)format_38
Format: #,##0_);[Red](#,##0)format_39
Format: #,##0.00_);(#,##0.00)format_4
Format: #,##0.00format_40
Format: #,##0.00_);[Red](#,##0.00)format_45
Format: mm:ssformat_46
Format: [h]:mm:ssformat_47
Format: mm:ss.0format_48
Format: ##0.0E+0format_49
Format: #format_5
Format: $#,##0_);($#,##0)format_6
Format: $#,##0_);[Red]($#,##0)format_7
Format: $#,##0.00_);($#,##0.00)format_8
Format: $#,##0.00_);[Red]($#,##0.00)format_9
Format: 0%none
No format / Default
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description int
getValue()
Gets the numeric value of the enum entrystatic NumberFormat.FormatNumber
valueOf(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
-
-