Home > Net >  Using NPOI how to set the default cell style?
Using NPOI how to set the default cell style?

Time:05-20

Using NPOI already has a period of time, always with a very good, but recently met such a problem: using NPOI created XLSX file in WPS open and use the print preview everything is normal, the use of Excel 2019 print preview will appear width is not enough, the print page number increase, and set up good line height also right,

After repeated inspection, found that the problem is above the default font of the two software, by opening the file after modification "conventional" cell style, can be solved using on the WPS "conventional" cell style of the font of "tahoma", and Excel2019 open is a "line", all the font is not set the cell to the default font are "lines", if you use the WPS open and save use Excel2019 open will again after everything is normal,

Don't know is there any way to solve this problem, while creating XLSX file set the default font of each cell,
  •  Tags:  
  • C#
  • Related