Class ExcelDxfNumberFormat
A numberformat in a differential formatting record
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.Style.Dxf
Assembly: EPPlus.dll
Syntax
public class ExcelDxfNumberFormat : DxfStyleBase<ExcelDxfNumberFormat>Properties
Format
The number format
Declaration
public string Format { get; set; }Property Value
| Type | Description |
|---|---|
| System.String |
HasValue
If the object has a value
Declaration
protected override bool HasValue { get; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Overrides
OfficeOpenXml.Style.Dxf.DxfStyleBase<OfficeOpenXml.Style.Dxf.ExcelDxfNumberFormat>.HasValue
Id
The id
Declaration
protected override string Id { get; }Property Value
| Type | Description |
|---|---|
| System.String |
Overrides
OfficeOpenXml.Style.Dxf.DxfStyleBase<OfficeOpenXml.Style.Dxf.ExcelDxfNumberFormat>.Id
NumFmtID
Id for number format
Build in ID's
0 General 1 0 2 0.00 3 #,##0 4 #,##0.00 9 0% 10 0.00% 11 0.00E+00 12 # ?/? 13 # ??/?? 14 mm-dd-yy 15 d-mmm-yy 16 d-mmm 17 mmm-yy 18 h:mm AM/PM 19 h:mm:ss AM/PM 20 h:mm 21 h:mm:ss 22 m/d/yy h:mm 37 #,##0 ;(#,##0) 38 #,##0 ;Red 39 #,##0.00;(#,##0.00) 40 #,##0.00;Red 45 mm:ss 46 [h]:mm:ss 47 mmss.0 48 ##0.0E+0 49 @
Declaration
public int NumFmtID { get; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
Methods
Clone()
Clone the object
Declaration
protected override ExcelDxfNumberFormat Clone()Returns
| Type | Description |
|---|---|
| ExcelDxfNumberFormat | A new instance of the object |
Overrides
OfficeOpenXml.Style.Dxf.DxfStyleBase<OfficeOpenXml.Style.Dxf.ExcelDxfNumberFormat>.Clone()
CreateNodes(XmlHelper, String)
Creates the the xml node
Declaration
protected override void CreateNodes(XmlHelper helper, string path)Parameters
| Type | Name | Description |
|---|---|---|
| XmlHelper | helper | The xml helper |
| System.String | path | The X Path |
Overrides
OfficeOpenXml.Style.Dxf.DxfStyleBase<OfficeOpenXml.Style.Dxf.ExcelDxfNumberFormat>.CreateNodes(OfficeOpenXml.XmlHelper, System.String)