PrintType Property

---

See Also    DLL    Example

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