Custom format for 0 is ignored

[GrahamTheCoder]

Description

If I use custom format #,###;-#,###;- on a cell containing a 0, it should display -, but actually displays 0.

To Reproduce

1. Set the custom format of a cell to #,###;-#,###;-
2. Set the data value of that cell to 0
3. Observe rendered cell

Pre-made spredsheet (made in recent excel version): CustomFormatDashForZero.xlsx

_grid.Load(@"C:\path\to\CustomFormatDashForZero.xlsx", FileFormat._Auto);

Screenshots

Left: Excel Right: Reogrid

Edition

Which edition of ReoGrid do you using?

• WPF

Environment

• OS: Windows 10
• Language of OS: English

[GrahamTheCoder]

Official docs for this feature are available (found from https://github.com/unvell/ReoGrid/pull/336) https://support.office.com/en-us/article/number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68

[jingwood]

@GrahamTheCoder Thanks! I will try to fix this within some days.

[64237442]

I have the same problems， My data formats are: #,##0, Red