PDF 3 charts and backgroud cells

Posted by: patrik on 18 October 2019, 7:23 pm EST

  • Posted 18 October 2019, 7:23 pm EST

    I use this code to PDF, but charts are not correct in the PDF.

    Dim SaveD1 As String
    SaveD.FileName = Me.Text
    SaveD.Filter = "PDF (*.PDF)|*.PDF" ' PDF
    SaveD1 = SaveD.ShowDialog()
    If SaveD1 <> 1 Then Exit Sub
    Dim printset As New FarPoint.Win.Spread.PrintInfo()
    printset.ShowBorder = False
    printset.PrintToPdf = True
    printset.PdfWriteMode = FarPoint.Win.Spread.PdfWriteMode.Append
    printset.PdfFileName = SaveD.FileName
    printset.ShowRowHeader = FarPoint.Win.Spread.PrintHeader.Hide
    printset.ShowColumnHeader = FarPoint.Win.Spread.PrintHeader.Hide
    printset.ShowColor = True
    printset.Margin.Right = 0 : printset.Margin.Left = 77
    printset.Margin.Top = 60
    printset.PrintType = FarPoint.Win.Spread.PrintType.All
    printset.ShowPrintDialog = False
    printset.Orientation = FarPoint.Win.Spread.PrintOrientation.Landscape
    printset.JobName = "Utskrift sker.."
    printset.BestFitCols = True

    'printset.SmartPrintPagesWide = 1
    'printset.SmartPrintPagesTall = 0
    printset.UseSmartPrint = True
    For Each SheetView In FpSpread1.Sheets
    SheetView.PrintInfo = printset
  • Replied 20 October 2019, 4:27 pm EST



    I am not able to replicate the issue with the latest build. Please refer to the attached project.

    If the problem still occurs, Could you please either modify the attached application or provide your own stripped-down project so that I can try reproducing the same behavior at my end and assist you further accordingly?


  • Replied 31 October 2019, 2:19 am EST

    This look good when see and export to excel.
    but PDF are not good.

  • Replied 31 October 2019, 4:30 pm EST


    Thanks for the sample.

    I am able to reproduce the issue at our end. I will escalate the issue to our development team(262373) and inform you once I get any reply from them.

  • Replied 13 November 2019, 10:33 pm EST


    Did you get any answer from development team?
  • Replied 14 November 2019, 3:31 pm EST

    Hello Patrik,

    I have asked the update from the development team.

  • Replied 15 December 2019, 1:54 am EST

    They come back to you yet?
  • Replied 10 January 2020, 12:25 am EST

    This problem are not solved in version 13.

    You get any information from development team?
  • Marked as Answer

    Replied 15 January 2020, 1:51 am EST

    Hello Patrick,

    We are very sorry for the delay!

    As pe reply from the dev, it is a limitation of spread. As a workaround, you can set chart position and size as absolute and then, use BestFit for printing.

  • Replied 20 January 2020, 8:28 am EST

    I not sure what I should do.
    Can you sample?
  • Replied 22 January 2020, 1:11 am EST


    I have forwarded your request to our development team.

  • Replied 1 March 2020, 5:14 am EST

    You not heard anything from development team?
  • Replied 3 March 2020, 9:19 pm EST


    We are deeply sorry for the inconvenience caused to you. Actually, there is no workaround for this situation. It is a limitation of Spread PDF export as discussed. The developers have investigated the issue thoroughly but it is a limitation that has no workaround. Once Again, I am sorry for all this.

  • Replied 14 March 2020, 3:14 am EST

    Thanks for your replay

    I not sure what is the "limitation".
    I need to know more, in what situation I can not use the PDF export.
  • Replied 16 March 2020, 8:47 pm EST


    I have forwarded your request to our development team.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels