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 | |
| Paper size | This setting is not imported. | |
| 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 |
Information about the type of printer (such as name) is not imported.
Return to Excel-Formatted File Import overview.