 | StyleNumber |
Class representing a NumberFormat entry. The NumberFormat entry is used to define cell formats like currency or date
Inheritance HierarchyNamespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.4.5+3a069966d2787c42b695e5043a5e083b247634e3
SyntaxC#
public class NumberFormat : AbstractStyle
The StyleNumberFormat type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | StyleNumberFormat | Initializes a new instance of the StyleNumberFormat class |
Properties| Name | Description | |
|---|---|---|
 | CustomFormatCode | Gets or sets the raw custom format code in the notation of Excel. The code is not escaped automatically |
| 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 a value indicating whether 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) | Determines whether the specified object is equal to the current object. (Inherited from 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 |
| DEFAULT_NUMBER | Default format number as constant |
See Also