Spread 8.0 Documentation
PrintType Property
Support Options
ActiveX Reference > ActiveX Properties > PrintType Property

Glossary Item Box

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

C++

long CSpreadSheet::GetPrintType( );
void CSpreadSheet::SetPrintType(long value);

Visual Basic

[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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.