The following table summarizes how Spread exports print settings to 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.
| FarPoint.Web.Spread.PrintInfo | Excel Print Setting | Remarks |
|---|---|---|
| Page | ||
| Orientation | Orientation | |
| ZoomFactor | Adjust to | |
| UseSmartPrint | Fit to | |
| SmartPrintPagesTall | Fit to | |
| SmartPrintPagesWide | Fit to | |
| FirstPageNumber | First page number | |
| Margins | ||
| Top (PrintMargin class) | Top | |
| Left (PrintMargin class) | Left | |
| Right (PrintMargin class) | Right | |
| Bottom (PrintMargin class) | Bottom | |
| Header (PrintMargin class) | Header | |
| Footer (PrintMargin class) | Footer | |
| Centering | Center on page | |
| Header and Footer | ||
| Header | Header | |
| Footer | Footer | |
| Different odd and even pages | This setting is not available in Spread. | |
| Different first page | This setting is not available in Spread. | |
| Scale with document | This setting is not available in Spread. | |
| Align with page margins | This setting is not available in Spread. | |
| Sheet | ||
| RowStart, RowEnd, ColStart, and ColEnd | Print area | |
| RepeatRowStart and RepeatRowEnd | Print titles: Rows to repeat at top | |
| RepeatColStart and RepeatColEnd | Print titles: Column to repeat at left | |
| ShowGrid | Print gridlines | |
| ShowColor | Print black and white | |
| Print draft quality | This setting is not available in Spread. | |
| ShowColumnHeaders and ShowRowHeaders | Print column and row headings | |
| PrintNotes | Print comments | |
| Print cell errors | This setting is not available in Spread. | |
| PrintPageOrder | Page order |
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.
