The following list summarizes the print settings that are imported when Spread imports data from an Excel file. These are all properties of the PrintInfo class.
| Excel Setting | Related Spread Property | Remarks |
|---|---|---|
| Black and white, or color | ShowColor | |
| Centering | Centering | |
| Ending Column | ColEnd | |
| Ending Row | RowEnd | |
| Fit Height | SmartPrintPagesTall | |
| Fit Width | SmartPrintPagesWide | |
| Footer (page footer) | Footer | |
| Header (page header) | Header | |
| Margins (page margins) | Margin | |
| Orientation (page orientation) | Orientation | |
| Page order | PageOrder | |
| Paper size for printing | PaperSize | Gets and sets the basic paper sizes: Letter, Legal, Executive, A4, Envelope #10, Envelope DL, Envelope C5, Envelope B5, Envelope Monarch |
| Starting Column | ColStart | |
| Starting Row | RowStart | |
|
Headers, printing |
Excel allows users either to print both the column and row headers or to not print any headers. Therefore, if the Excel file is set to print both column and row headers, the ShowColumnHeader and ShowRowHeader properties in Spread are set to True. |
|
| Grid lines, printing | ShowGrid | |
| Zoom; scaling | ZoomFactor |