 | StyleNumber |
Enum for predefined number formats
Inheritance HierarchyNamespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.2.1+e0edc719a6aeecf6c989e5a57750c75d6f3175bb
SyntaxC#
public sealed class FormatNumber : Enum
The StyleNumberFormatFormatNumber type exposes the following members.
Methods| Name | Description | |
|---|---|---|
 | CompareTo | Compares this instance to a specified object and returns an indication of their relative values. (Inherited from Enum) |
| Equals | Returns a value indicating whether this instance is equal to a specified object. (Inherited from Enum) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetHashCode | Returns the hash code for the value of this instance. (Inherited from Enum) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| GetTypeCode | Returns the type code of the underlying type of this enumeration member. (Inherited from Enum) |
| HasFlag | Determines whether one or more bit fields are set in the current instance. (Inherited from Enum) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| ToString | Converts the value of this instance to its equivalent string representation. (Inherited from Enum) |
| ToString(IFormatProvider) | Obsolete. This method overload is obsolete; use ToString. (Inherited from Enum) |
| ToString(String) | Converts the value of this instance to its equivalent string representation using the specified format. (Inherited from Enum) |
| ToString(String, IFormatProvider) | Obsolete. This method overload is obsolete; use ToString(String). (Inherited from Enum) |
Fields| Name | Description | |
|---|---|---|
  | custom | Custom Format (ID 164 and higher) |
| format_1 | Format: 0 |
| format_10 | Format: 0.00% |
| format_11 | Format: 0.00E+00 |
| format_12 | Format: # ?/? |
| format_13 | Format: # ??/?? |
| format_14 | Format: m/d/yyyy |
| format_15 | Format: d-mmm-yy |
| format_16 | Format: d-mmm |
| format_17 | Format: mmm-yy |
| format_18 | Format: mm AM/PM |
| format_19 | Format: h:mm:ss AM/PM |
| format_2 | Format: 0.00 |
| format_20 | Format: h:mm |
| format_21 | Format: h:mm:ss |
| format_22 | Format: m/d/yyyy h:mm |
| format_3 | Format: #,##0 |
| format_37 | Format: #,##0_);(#,##0) |
| format_38 | Format: #,##0_);[Red](#,##0) |
| format_39 | Format: #,##0.00_);(#,##0.00) |
| format_4 | Format: #,##0.00 |
| format_40 | Format: #,##0.00_);[Red](#,##0.00) |
| format_45 | Format: mm:ss |
| format_46 | Format: [h]:mm:ss |
| format_47 | Format: mm:ss.0 |
| format_48 | Format: ##0.0E+0 |
| format_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 |
| value__ |
RemarksThere 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
See Also