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 | LineSpace, Ellipsis, 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.
Call the PrintToPdf property in the PrintInfo class to print the specified sheet.
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) |
|