Hello,
We are experiencing multiple issues regarding rendering fonts with different styles, using the latest version of Aspose.Cells (v7.3.0), please check the attached files:
- Double underline is not preserved (cells B3, C3 and C5)
- Courier font not rendered correctly, Calibri font is used instead (cell C2)
- Times New Roman text underline not rendered correctly (cell B5)
- Vertical alignment is not correct (cells C2, C4, B5, C5)
Here is the code used to reproduce the issues:
var workbook = new Workbook(@“FontSettings.xlsx”);<span style="color:blue;">var</span> imageOptions = <span style="color:blue;">new</span> <span style="color:#2b91af;">ImageOrPrintOptions</span> { Quality = 100, VerticalResolution = 200, HorizontalResolution = 200, PrintingPage = <span style="color:#2b91af;">PrintingPageType</span>.IgnoreBlank, ImageFormat = <span style="color:#2b91af;">ImageFormat</span>.Png, OnePagePerSheet = <span style="color:blue;">true</span> }; <span style="color:blue;">var</span> worksheet = workbook.Worksheets[0]; worksheet.PageSetup.PrintArea = <span style="color:blue;">string</span>.Format(<span style="color:#a31515;">"a1:d6"</span>); worksheet.PageSetup.TopMargin = 0; worksheet.PageSetup.LeftMargin = 0; worksheet.PageSetup.RightMargin = 0; worksheet.PageSetup.BottomMargin = 0; <span style="color:blue;">var</span> sheetRender = <span style="color:blue;">new</span> <span style="color:#2b91af;">SheetRender</span>(worksheet, imageOptions); sheetRender.ToImage(0, <span style="color:#a31515;">@"FontSettings.png"</span>);<br><br><br>Thank you,<br>Bogdan Rusu,<br>IBM Romania.<br><br><br></pre>