The following table summarizes how Spread imports print settings from an Excel-formatted file. The properties listed in the table are in the PrintInfo class, unless otherwise noted. For more information, see the Assembly Reference.
| Excel Print Setting | FarPoint.Web.Spread.PrintInfo | Remarks |
|---|---|---|
| Page | ||
| Orientation | Orientation | |
| Adjust to | ZoomFactor | |
| Fit to | UseSmartPrint | |
| Fit to | SmartPrintPagesTall | |
| Fit to | SmartPrintPagesWide | |
| First page number | FirstPageNumber | |
| Margins | ||
| Top | Top (PrintMargin class) | |
| Left | Left (PrintMargin class) | |
| Right | Right (PrintMargin class) | |
| Bottom | Bottom (PrintMargin class) | |
| Header | Header (PrintMargin class) | |
| Footer | Footer (PrintMargin class) | |
| Center on page | Centering | |
| Header and Footer | ||
| Header | Header | |
| Footer | Footer | |
| Different odd and even pages | This setting is not imported. | |
| Different first page | This setting is not imported. | |
| Scale with document | This setting is not imported. | |
| Align with page margins | This setting is not imported. | |
| Sheet | ||
| Print area | RowStart, RowEnd, ColStart, and ColEnd | |
| Print titles: Rows to repeat at top | RepeatRowStart and RepeatRowEnd | |
| Print titles: Column to repeat at left | RepeatColStart and RepeatColEnd | |
| Print gridlines | ShowGrid | |
| Print black and white | ShowColor | |
| Print draft quality | This setting is not imported. | |
| Print column and row headings | ShowColumnHeaders and ShowRowHeaders | |
| Print comments | PrintNotes | |
| Print cell errors | This setting is not imported. | |
| Page order | PrintPageOrder |
Paper Size
The following paper sizes are supported if a file is imported from an Excel-formatted file and then saved to an Excel-formatted file (Letter, Legal, Executive, A3, A4, B4, B5, Envelope #10, Envelope DL, Envelope C5, Envelope B5, and Envelope Monarch).
Printer Type
Information about the type of printer (such as name) is not imported.