You can print a sheet to a Portable Document Format (PDF, version 1.4) file using the PrintToPdf method in the PrintInfo class. Use the PdfFileName property to specify the file name and location to which to save the file. Since PrintInfo objects are assigned to individual sheets, this method prints an individual sheet.

You can set a password with the PdfSecurity property.

The following cell type items are not printed to PDF:

To customize print settings, refer to Understanding the Printing Options and Customizing the Printed Page Header or Footer. To allow Spread to determine the best print settings, refer to Optimizing the Printing Using Rules.

Using Code

Call the PrintToPdf property in the PrintInfo class to print the specified sheet.

Example

This example code saves the sheet to a PDF file.

FarPoint.Win.Spread.PrintInfo printset = new FarPoint.Win.Spread.PrintInfo();
printset.PrintToPdf = true;
printset.PdfFileName = "D:\\results.pdf";
// Assign the printer settings and print
fpSpread1.Sheets[0].PrintInfo = printset;
fpSpread1.PrintSheet(0);

Dim printset As New FarPoint.Win.Spread.PrintInfo()
printset.PrintToPdf = True
printset.PdfFileName = "D:\results.pdf"
' Assign the printer settings and print
fpSpread1.Sheets(0).PrintInfo = printset
fpSpread1.PrintSheet(0)

Using the Spread Designer

1. Select the File menu.
2. Select Print.
3. Select PrintPDF.
4. Use the Save dialog to pick a location and specify a file name.