# Understanding the Printing Options

Learn how to customize printing options for your spreadsheets with this comprehensive guide on setting properties and print settings for optimal results.

## Content

You can customize the printing by setting the properties of a [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.html) object and setting the [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.PrintInfo.html) property of a sheet to that object. The [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.html) object has the settings for customizing the printing of a sheet.
The [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.html) object provides the following properties for customizing the printing:

| **Property** | **Description** |
| -------- | ----------- |
| [AbortMessage](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.AbortMessage.html) | Gets or sets the message to display for the abort dialog. See [Displaying an Abort Message for the User](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printuser/spwin-printabortdialog). |
| [BestFitCols](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.BestFitCols.html) | Gets or sets whether column widths are adjusted to fit the longest string width for printing. See [Optimizing the Printing Using Size](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printoptimize/spwin-printbest). |
| [BestFitRows](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.BestFitRows.html) | Gets or sets whether row heights are adjusted to fit the tallest string height for printing. See [Optimizing the Printing Using Size](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printoptimize/spwin-printbest). |
| [Centering](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Centering.html) | Gets or sets whether to center the print out. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [Colors](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Colors.html) | Gets or sets the list of colors that can be used in a custom header or footer text. See [Customizing the Printed Page Header or Footer](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printheadfoot). |
| [ColStart](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ColStart.html) and [ColEnd](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ColEnd.html) | Used for printing a portion of the sheet. See [Printing a Range of Cells on a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printactions/spwin-printrange). |
| [FirstPageNumber](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.FirstPageNumber.html) | Gets or sets the page number to print on the first page. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [Footer](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Footer.html) | Used for providing footers on printed pages. See [Customizing the Printed Page Header or Footer](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printheadfoot). |
| [Header](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Header.html) | Used for providing headers on printed pages. See [Customizing the Printed Page Header or Footer](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printheadfoot). |
| [Images](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Images.html) | Gets or sets the list of images that can be used in a custom headers or footers. See [Customizing the Printed Page Header or Footer](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printheadfoot). |
| [JobName](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.JobName.html) | Gets or sets the name of the print job. See [Customizing the Print Job Settings](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printsettings). |
| [Margin](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Margin.html) | Gets or sets the margins for printing. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [Opacity](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Opacity.html) | Gets or sets the opacity used when printing this sheet; this is used to print a watermark first and then the sheet contents. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [Orientation](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Orientation.html) | Gets or sets the page orientation used for printing. See [Customizing the Print Job Settings](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printsettings). |
| [PageStart](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.PageStart.html) and [PageEnd](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.PageEnd.html) | Used for printing a page range. See [Printing Particular Pages](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printactions/spwin-printpages). |
| [PageOrder](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.PageOrder.html) | Gets or sets the order in which pages print. See [Customizing the Print Job Settings](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printsettings). |
| [PaperSize](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.PaperSize.html) | Gets or sets the paper size to use. See [Customizing the Print Job Settings](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printsettings). |
| [PaperSource](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.PaperSource.html) | Gets or sets the paper source to use. See [Customizing the Print Job Settings](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printsettings). |
| [Preview](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Preview.html) | Used to provide print preview. See [Providing a Preview of the Printing](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printuser/spwin-printpreview). |
| [Printer](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Printer.html) | Gets or sets the name of the printer to use for printing. See [Customizing the Print Job Settings](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printsettings). |
| [PrintNotes](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.PrintNotes.html) | Gets or sets whether to print the cell notes. See [Printing a Sheet with Cell Notes](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printactions/spwin-printnotes). |
| [PrintShapes](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.PrintShapes.html) | Gets or sets whether to print floating objects. See [Printing a Sheet with Shapes](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printactions/spwin-printshapes). |
| [PrintType](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.PrintType.html) | Gets or sets what is to be printed. See [Printing Particular Pages](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printactions/spwin-printpages). |
| [RepeatColStart](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.RepeatColStart.html) and [RepeatColEnd](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.RepeatColEnd.html) | Gets or sets whether to print the same set of columns on each page. See [Customizing the Printed Page Header or Footer](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printheadfoot). |
| [RepeatRowStart](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.RepeatRowStart.html) and [RepeatRowEnd](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.RepeatRowEnd.html) | Gets or sets whether to print the same set of rows on each page. See [Customizing the Printed Page Header or Footer](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printheadfoot). |
| [RowStart](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.RowStart.html) and [RowEnd](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.RowEnd.html) | Used for printing a portion of the sheet. See [Printing a Range of Cells on a Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printactions/spwin-printrange). |
| [ShowBorder](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ShowBorder.html) | Gets or sets whether to print a border around the sheet. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [ShowColor](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ShowColor.html) | Gets or sets whether to print the colors as they appear on the screen. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [ShowColumnHeader](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ShowColumnHeader.html) and [ShowRowHeader](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ShowRowHeader.html) | Gets or sets whether to print the column headers and row headers. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [ShowGrid](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ShowGrid.html) | Gets or sets whether to print the sheet grid lines. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [ShowPrintDialog](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ShowPrintDialog.html) | Gets or sets whether to display a print dialog before printing. See [Displaying a Print Dialog for the User](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printuser/spwin-printdialog). |
| [ShowShadows](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ShowShadows.html) | Gets or sets whether to print the header shadows. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [SmartPrintPagesTall](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.SmartPrintPagesTall.html) | Gets or sets how many pages tall to print. See [Optimizing the Printing Using Rules](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printoptimize/spwin-printsmart). |
| [SmartPrintPagesWide](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.SmartPrintPagesWide.html) | Gets or sets how many pages wide to print. See [Optimizing the Printing Using Rules](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printoptimize/spwin-printsmart). |
| [SmartPrintRules](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.SmartPrintRules.html) | Used for setting up the rules for optimizing the printing. See [Optimizing the Printing Using Rules](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printoptimize/spwin-printsmart). |
| [UseMax](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.UseMax.html) | Gets or sets whether to print only rows containing data. See [Printing an Area of the Sheet](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printactions/spwin-printarea). |
| [UseSmartPrint](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.UseSmartPrint.html) | Used for turning on the rules for optimizing the printing. See [Optimizing the Printing Using Rules](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printoptimize/spwin-printsmart). |
| [ZoomFactor](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ZoomFactor.html) | Gets or sets the zoom factor used for printing this sheet. See [Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout). |
| [EnhancePreview](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.EnhancePreview.html) | Gets or sets the state to show the enhanced Print Preview Dialog (like Excel). See [Customizing the Print Preview Dialog](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/CustomizingthePrintPreviewDialog). |
| [ShowPageSetupButton](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.ShowPageSetupButton.html) | Gets or sets the state to show the PageSetUpButton on toolbar of the Print Preview Dialog. See [Providing a Preview of the Printing](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printuser/spwin-printpreview). |
| [Duplex](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.Duplex.html) | Gets or sets whether to allow a user to print on both sides of the paper. See [Printing in Duplex Mode](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printactions/PrintingDuplexMode). |

## Using the Properties Window

1. At design time, in the **Properties** window, select the Spread component.
2. Select the **Sheets** property.
3. Click the button to display the **SheetView Collection Editor**.
4. In the **Members** list, select the sheet for which to set the print options.
5. In the properties list, double-click the **PrintInfo** property to display the settings for the **PrintInfo** class.
6. Set the properties listed above as needed to set your print options.
7. Click **OK** to close the editor.

## Using a Shortcut

1. Create and set properties for a [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.html) object.
2. Set the Sheet shortcut object [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.PrintInfo.html) property to the [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.html) object you just created.

**Example**
This example code creates a [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.html) object, sets properties to specify to not print grid lines or row headers, and to print only cells with data in them.

```csharp
// Create PrintInfo object and set properties.
FarPoint.Win.Spread.PrintInfo printset = new FarPoint.Win.Spread.PrintInfo();
printset.ShowGrid = false;
printset.ShowRowHeader = FarPoint.Win.Spread.PrintHeader.Hide;
printset.UseMax = true;
// Set the PrintInfo property for the first sheet.
fpSpread1.Sheets[0].PrintInfo = printset;
// Print the sheet.
fpSpread1.PrintSheet(0);
```

```vbnet
' Create PrintInfo object and set properties.
Dim printset As New FarPoint.Win.Spread.PrintInfo()
printset.ShowGrid = False
printset.ShowRowHeader = FarPoint.Win.Spread.PrintHeader.Hide
printset.UseMax = True
' Set the PrintInfo property for the first sheet.
fpSpread1.Sheets(0).PrintInfo = printset
' Print the sheet.
fpSpread1.PrintSheet(0)
```

## Using Code

1. Create and set properties for a [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.html) object.
2. Set the SheetView object [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.SheetView.PrintInfo.html) property to the [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.html) object you just created.

**Example**
This example code creates a [PrintInfo](/spreadnet/api/latest/online-win/FarPoint.Win.Spread/FarPoint.Win.Spread.PrintInfo.html) object, sets properties to specify to not print grid lines or row headers, and to print only cells with data in them.

```csharp
// Create PrintInfo object and set properties.
FarPoint.Win.Spread.PrintInfo printset = new FarPoint.Win.Spread.PrintInfo();
printset.ShowGrid = false;
printset.ShowRowHeader = FarPoint.Win.Spread.PrintHeader.Hide;
printset.UseMax = true;
// Create SheetView object and assign it to the first sheet.
FarPoint.Win.Spread.SheetView SheetToPrint = new FarPoint.Win.Spread.SheetView();
SheetToPrint.PrintInfo = printset;
fpSpread1.Sheets[0] = SheetToPrint;
// Print the sheet.
fpSpread1.PrintSheet(0);
```

```vbnet
' Create PrintInfo object and set properties.
Dim printset As New FarPoint.Win.Spread.PrintInfo()
printset.ShowGrid = False
printset.ShowRowHeader = FarPoint.Win.Spread.PrintHeader.Hide
printset.UseMax = True
' Create SheetView object and assign it to the first sheet.
Dim SheetToPrint As New FarPoint.Win.Spread.SheetView()
SheetToPrint.PrintInfo = printset
fpSpread1.Sheets(0) = SheetToPrint
' Print the sheet.
fpSpread1.PrintSheet(0)
```

## Using the Spread Designer

1. Select the sheet tab for the sheet for which you want to set print settings.
2. Select the **Page Layout** option.
3. Select the PrintTitles icon, choose **General**.
    The **Sheet Print** dialog appears.
4. Set the print options using the **General**, **Output**, **Header/Footer**, **SmartPrint**, **Pagination**, and **Margins** tab options.
5. Click **OK** to close the **Sheet Print Options** dialog.
6. From the **File** menu choose **Apply and Exit** to apply your changes to the component and exit Spread Designer.

## See Also

[Customizing the Print Job Settings](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printsettings)
[Customizing the Printed Page Layout](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printlayout)
[Customizing the Printed Page Header or Footer](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printheadfoot)
[Customizing the Print Preview Dialog](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/CustomizingthePrintPreviewDialog)
[Repeating Rows or Columns on Printed Pages](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printrepeatrange)
[Adding a Page Break](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-pagebreaks)
[Adding a Watermark to a Printed Page](/spreadnet/docs/latest/online-win/overview/spwin-devguide/spwin-printing/spwin-printcustomize/spwin-printwatermark)