PrintType Property
Applies To
fpSpread control
Description
Sets or returns the type of print range used to print a sheet. This property is available at run time only.
Syntax
long CSpreadSheet::GetPrintType( );
void CSpreadSheet::SetPrintType(long value);
[form.]fpSpread.PrintType[ = setting%]
Remarks
The following settings are available:
Setting | Description | Constant |
---|---|---|
0 - All | (Default) Prints the entire sheet | PrintTypeAll |
1 - Cell Range | Prints the area specified by the Col, Col2, Row, and Row2 properties | PrintTypeCellRange |
2 - Current Page | Prints the visible area of the current page of the sheet | PrintTypeCurrentPage |
3 - Page Range | Prints the pages in the range specified by the PrintPageStart and PrintPageEnd properties | PrintTypePageRange |
This property is set at the sheet level. Set the Sheet property before setting this property if there are multiple sheets.
Set the PrintType property before you use the PrintSheet method to print the sheet.
You can use a variety of options to specify the range type for printing the sheet. Depending upon the range type you specify with the PrintType property, the following properties can be used to specify the range, as explained in the preceding table: PrintType, PrintPageStart, PrintPageEnd, Col, Row, Col2, and Row2 properties.
The setting of the PrintType property and the other print range properties might be overridden if the PrintUseDataMax property is set to True. When the PrintUseDataMax property is set to True, empty cells beyond the columns and rows containing data are not printed. You can return the number of the last column and row containing data using the DataColCnt and DataRowCnt properties.
Note: If you have set the ColsFrozen or RowsFrozen property to freeze columns or rows, the frozen columns or rows will also print with your range, even if they are not included in the range you specify. |
Spread Designer
Choose the Sheet menu, then the Print Properties menu, select the Print Properties tab, and then choose an option from the Range group box in the Print Properties dialog box.
Data Type
Integer (Enumerated)
See Also
Printing a Sheet in the Active View in Spread Designer
Specifying Print Options
Specifying a Print Range
Col, Col2, ColsFrozen, DataColCnt, DataRowCnt, PrintPageStart, PrintPageEnd, PrintUseDataMax, Row, Row2, RowsFrozen properties
PrintSheet method
DLL Correspondence
SSPrint function