Multiple font rendering issues

Aspose.Cells Product Family
1

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>
2

Hi,


Thank you for using Aspose.Cells.

I was able to reproduce the issue at my end with your sample code and source Excel file.

Our development team will look into this issue and we will let you know here about the resolution of this isssue once we have any update from our development team.The issue has been logged as: CELLSNET-40867.