Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Printing / Specifying What to Print / Printing to PDF
In This Topic
    Printing to PDF
    In This Topic

    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