Spread for ASP.NET 12 Product Documentation
Print Settings Imported
Spread for ASP.NET 12 Product Documentation > Import and Export Reference > Excel-Formatted File Import > Print Settings Imported

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.