[]
        
(Showing Draft Content)

Print Settings Imported

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

ShowColumnHeader ShowRowHeader

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.

Header/Footer Image, Printing (page header/footer)

Images


Grid lines, printing

ShowGrid


Zoom; scaling

ZoomFactor


See Also

Workbook Settings Imported

Chart Settings Imported

Sheet Settings Imported

Row and Column Settings Imported

Cell Settings Imported

Border Styles Substituted

Formula Settings Imported