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.2+7f12a949130e0be1e987e553d2d08c083176cdca

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