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

Glossary Item Box

PrintUseDataMax Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns whether a sheet prints empty cells beyond the last column and row containing data. This property is available at run time only.

Syntax

C++

BOOL CSpreadSheet::GetPrintUseDataMax( );
void CSpreadSheet::SetPrintUseDataMax(BOOL value);

Visual Basic

[form.]fpSpread.PrintUseDataMax[ = boolean%]

Remarks

Set the PrintUseDataMax property to True to print only the portion of the a sheet that contains data and to save time and paper.

The default value for the PrintUseDataMax property is True. When the PrintUseDataMax property is set to True, empty cells beyond the columns and rows containing data are not printed. When the PrintUseDataMax property is set to False, the number of rows and columns that print is defined by the PrintType, PrintPageStart, PrintPageEnd, Col, Row, Col2, and Row2 properties.

Set the PrintUseDataMax property before you use the PrintSheet method to print the sheet.

This property is set at the sheet level. Set the Sheet property before setting this property if there are multiple sheets.

Spread Designer

Choose the Sheet menu, then the Print Properties menu, select the Print Properties tab, and then choose the Data Cells Only check box in the Print group box in the Print Properties dialog box.

Data Type

Integer (Boolean)

See Also

Print Properties
Using Virtual Mode
Printing the Portion of the Sheet with Data
Specifying a Print Range

Col, Col2, PrintPageEnd, PrintPageStart, PrintType, Row, Row2 properties

PrintSheet method

DLL Correspondence

SSPrint function

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