NumberFormatCustomFormatCode Property

Gets or sets the raw custom format code in the notation of Excel. The code is not escaped or un-escaped (on workbook loading)

Namespace: NanoXLSX.Styles
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc

Syntax

Copy

public string CustomFormatCode { get; set; }

Property Value

String

Exceptions

Exception	Condition
FormatException	Throws a FormatException if passed value is null or empty

Remarks

Currently, there is no auto-escaping applied to custom format strings. For instance, to add a white space, internally it is escaped by a backspace (\ ). To get a valid custom format code, this escaping must be applied manually, according to OOXML specs: Part 1 - Fundamentals And Markup Language Reference, Chapter 18.8.31

Reference

NumberFormat Class

NanoXLSX.Styles Namespace