PDF 3 charts and backgroud cells

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

    • Post Options:
    • Link

    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
            Next
            FpSpread1.PrintSheet(-1)
    
  • Posted 20 October 2019, 4:27 pm EST

    Hello,

    Hello,

    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?

    Thanks,

    Spread_chart_print.zip

  • Posted 31 October 2019, 2:19 am EST

    This look good when see and export to excel.

    but PDF are not good.

    Spread_chart_print_rev1.zip

  • Posted 31 October 2019, 4:30 pm EST

    Hello,

    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.

    Thanks.

  • Posted 13 November 2019, 10:33 pm EST

    Hi

    Did you get any answer from development team?

  • Posted 14 November 2019, 3:31 pm EST

    Hello Patrik,

    I have asked the update from the development team.

    Thanks,

    Mohit

  • Posted 15 December 2019, 1:54 am EST

    They come back to you yet?

  • Posted 10 January 2020, 12:25 am EST

    This problem are not solved in version 13.

    You get any information from development team?

  • Posted 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.

    Thanks,

    Mohit

  • Posted 20 January 2020, 8:28 am EST

    I not sure what I should do.

    Can you sample?

  • Posted 22 January 2020, 1:11 am EST

    Hello,

    I have forwarded your request to our development team.

    Thanks,

    Mohit

  • Posted 1 March 2020, 5:14 am EST

    You not heard anything from development team?

  • Posted 3 March 2020, 9:19 pm EST

    Hello,

    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.

    Thanks,

    Mohit

  • Posted 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.

  • Posted 16 March 2020, 8:47 pm EST

    Hello,

    I have forwarded your request to our development team.

    Thanks,

    Mohit

Need extra support?

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

Learn More

Forum Channels