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.

Need extra support?

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

Learn More

Forum Channels