 | Number |
Class representing a NumberFormat entry. The NumberFormat entry is used to define cell formats like currency or date
Inheritance HierarchyNamespace: NanoXLSX.Styles
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.7+3223c8b99fcd3402b4ae016daa480abac16f8a9f
SyntaxC#
public class NumberFormat : AbstractStyle
The NumberFormat type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
  | NumberFormat | |
 | NumberFormat | Default constructor |
Properties| Name | Description | |
|---|---|---|
 | CustomFormatCode | Gets or sets the raw custom format code in the notation of Excel. The code is not escaped or un-escaped (on workbook loading) |
| CustomFormatID | Gets or sets the format number of the custom format. Must be higher or equal then predefined custom number (164) |
| InternalID |
Gets or sets the internal ID for sorting purpose in the Excel style document (nullable)
(Inherited from AbstractStyle) |
| IsCustomFormat | Gets whether the number format is a custom format (higher or equals 164). If true, the format is custom |
| Number | Gets or sets the format number. Set this to custom (164) in case of custom number formats |
Methods| Name | Description | |
|---|---|---|
| CompareTo |
Method to compare two objects for sorting purpose
(Inherited from AbstractStyle) |
| Copy |
Method to copy the current object to a new one without casting
(Overrides AbstractStyleCopy) |
| CopyNumberFormat | Method to copy the current object to a new one with casting |
 | CopyPropertiesT |
Internal method to copy altered properties from a source object. The decision whether a property is copied is dependent on a untouched reference object
(Inherited from AbstractStyle) |
| Equals(AbstractStyle) |
Method to compare two objects for sorting purpose
(Inherited from AbstractStyle) |
| Equals(Object) |
Returns whether two instances are the same
(Overrides ObjectEquals(Object)) |
| 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 a hash code for this instance.
(Overrides ObjectGetHashCode) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| IsDateFormat | Determines whether a defined style format number represents a date (or date and time) |
| IsTimeFormat | Determines whether a defined style format number represents a time) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| ToString |
Override toString method
(Overrides ObjectToString) |
| TryParseFormatNumber | Tries to parse registered format numbers. If the parsing fails, it is assumed that the number is a custom format number (164 or higher) and 'custom' is returned |
Fields| Name | Description | |
|---|---|---|
 | CUSTOMFORMAT_START_NUMBER | Start ID for custom number formats as constant (value 164) |
| DEFAULT_NUMBER | Default format number as constant |
See Also