Handle Z format in GetGridColumnFormat

[DougHennig]

GetGridColumnFormat doesn't handle "Z" (display zero as blank) in the format for a numeric column. I would change this myself but I'm not sure how NumFmtsIndex works.

[ggreen86]

Doug--

Can you provide a column format example of the z-format usage? Thank you.

Greg

---

From: Doug Hennig @.> Sent: Tuesday, July 20, 2021 10:29 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Subject: [ggreen86/XLSX-Workbook-Class] Handle Z format in GetGridColumnFormat (#61)

GetGridColumnFormat doesn't handle "Z" (display zero as blank) in the format for a numeric column. I would change this myself but I'm not sure how NumFmtsIndex works.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/61, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33IFI4CGSK3AT3XTONLTYWB6JANCNFSM5AV5QRCQ.

[DougHennig]

Set Format to Z and InputMask to 999,999.99. Zeros will appear as blank in the grid.

[ggreen86]

Doug--

I have added the ability to hide zero values (not display) in the cell, but it is shown in the edit textbox. This is done by a new parameter being added to the methods for setting the ShowZeros property for the sheet during the workbook create for a grid or a table. There is also a method to setting it directly. See the Release Notes for R39 Beta 13.