Excel has new default font Aptos, NPOI should not set a default FontName

[desdoades]

Since last year Microsoft changed the default font of Excel (and other programs) to Aptos.

This means many users already have Aptos while others still have Calibri and some users might even have changed the default font to something else.

This rises the question why NPOI uses a DEFAULT_FONT_NAME constant (which is currently Calibri) at all. It can be found in XSSFFont.cs

As an example, HorizontalAlignment works perfectly fine the way I would expect it to work. When I dont set it for a CellStyle the Excel default is used.

So my request is to remove DEFAULT_FONT_NAME and if a Font has not set a FontName just use whatever Excel wants to show.

[tonyqus]

It's hard for NPOI to detect what default font name should be used. NPOI only touch xls/xlsx. It doesn't know what version of Excel the user will use to open this Excel.

Since last year Microsoft changed the default font of Excel (and other programs) to Aptos.

Do you have document on this?

[desdoades]

It's hard for NPOI to detect what default font name should be used. NPOI only touch xls/xlsx. It doesn't know what version of Excel the user will use to open this Excel.

I know. Thats why I suggest to not set a default font name at all and let Excel decide, just like with my example with HorizontalAlignment. Or is that technically impossible?

Do you have document on this?

Here and here for example.

This is how it looks in my Windows 11 Office 365 current Excel:

[tonyqus]

Leaving font not set can be a potential problem for any cells in the Excel. I'm not so sure because Excel client itself should make sure that there must be a default font set for any cell. If NPOI don't set, Excel may throw error or show this file is invalid.