We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Convert Excel to Pdf, Chart series are bold in PDF

Hello,

I have code which converts the Excel file to PDF. I am using Aspose 18.6.0 version.
My excel contains some line charts. But Once I convert excel to PDF I observe that series lines are bold in PDF. Please the attached image.
PDF output screenshot.png (11.8 KB)

Here is my Code snippet :

private static byte[] GetPDFBytes(Workbook wb)
{
foreach (Worksheet ws in wb.Worksheets)
{
if (ws.IsVisible)
{
ws.PageSetup.PaperSize = PaperSizeType.PaperLetter;
ws.PageSetup.Orientation = PageOrientationType.Landscape;
ws.PageSetup.RightMarginInch = 0.25;
ws.PageSetup.TopMarginInch = 0.25;
ws.PageSetup.LeftMarginInch = 0.25;
ws.PageSetup.BottomMarginInch = 0.25;
ws.PageSetup.HeaderMarginInch = 0.3;
ws.PageSetup.FooterMarginInch = 0.3;
}
}

            PdfSaveOptions pdfSaveOptions = new PdfSaveOptions(SaveFormat.Pdf);
            pdfSaveOptions.OnePagePerSheet = true;
            using (MemoryStream PDFStream = new MemoryStream())
            {
                wb.Save(PDFStream, pdfSaveOptions);
                wb.Save(@"C:\TEMP\PDFOutput.pdf", pdfSaveOptions);
                return PDFStream.ToArray();
            }

    }

Also attached the Excel template and PDF output
SampleApplication.zip (173.0 KB)

Please let me know how to resolve the issue so that excel and pdf look similar.

Thanks,
Sarthak

@spathak,

Thanks for your query.
We have tried this sample code and template using latest version Aspose.Cells for .NET 18.8.2 but could not observe any issue. Please download following versions and test the scenario again. It should resolve your issue.

Aspose.Cells18.8.2 For .Net2_AuthenticodeSigned.Zip
Aspose.Cells18.8.2 For .Net4.0.Zip
Comparison.png (131.4 KB)

In your given output also.
Comparison.png (131.4 KB)

See, I am talking about the issue like :
PDF output screenshot.png (35.6 KB)

This difference is still there in latest version of Aspose.

@spathak,

We were able to notice the difference but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

 CELLSNET-46317 - Difference in chart series

@spathak,

We have investigated further and noticed that the generated reports are same. Please refer the attachment. 1683.zip (141.9 KB)