PDF Output

Posted by: peted on 8 September 2017, 1:02 pm EST

  • Posted 8 September 2017, 1:02 pm EST

    We are looking at Spread to develop an app that controls spreadsheet functionality and produce PDF output. Unfortunately, the PDF quality is not as good as we hoped. Please see the attached:


    Master_AHU.xls is the original Excel file
    Spread PDF output 1.PDF is the PDF when this file is loaded into Spread
    Spread PDF output 3.pdf is the PDF when this file is built in Spread
    AHU1.xml is the Spread version of the built file.


    The code for producing the PDF is:


    Dim printset As New FarPoint.Win.Spread.PrintInfo()


    Dim strFilename As String


    Dim strPath As String


    Dim i As Integer


    strPath = GetExecutablePath()


    strFilename = strPDFFilename


    While Dir(strPath & strFilename) <> ""


    i = i + 1


    strFilename = strPDFName & " " & i & ".pdf"


    End While


    printset.PrintToPdf = True


    printset.PdfFileName = strPath & strFilename


    ' Assign the printer settings and print


    FpSpread1.Sheets(0).PrintInfo = printset


    FpSpread1.PrintSheet(0)


    Is there anything that we can do to improve the PDF quality?


    Thanks
    Pete


    2008/02/Files to Farpoint.zip
  • Replied 8 September 2017, 1:02 pm EST

    Pete,


    I see the differences between output1 and output3, but I did not understand the differences in how these files were created. It sounded like one of them load the xls file and printed and the other loaded the xml file and printed. If this is the case, how were the xml and xls files created?

  • Replied 8 September 2017, 1:02 pm EST

    Scott


    Output one was produced by opening the xls (which was created in Excel)  in Spread and then printing the PDF.


    Output 3 was produced by programmatically building the spreadsheet in Spread and then printing the PDF.


    Pete

  • Replied 8 September 2017, 1:02 pm EST

    Pete,


    I have reported this as a bug (#22055) for the development team to fix for the next maintenance release.

Need extra support?

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

Learn More

Forum Channels