Spread Windows Forms 11.0 Product Documentation
Printing to PDF
Spread Windows Forms 11.0 Product Documentation > Developer's Guide > Managing Printing > Specifying What to Print > Printing to PDF

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:

Cell Type Description
GcTextBoxCellType LineSpaceEllipsis, or DisplayAlignment
Any Gc cell type Side button appearance
GcDateTimeCellType Field appearance
GcNumberCellType Field appearance
GcTimeSpanCellType Field appearance
GcMaskCellType Field appearance
GcCharMaskCellType Character box appearance
GcComboBoxCellType Image appearance or ellipsis

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.

C#
Copy Code
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);
VB
Copy Code
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.
See Also