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"
printset.PdfFileName = strPath & strFilename
' Assign the printer settings and print
FpSpread1.Sheets(0).PrintInfo = printset
Is there anything that we can do to improve the PDF quality?
2008/02/Files to Farpoint.zip