PrintUseDataMax Property
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
BOOL CSpreadSheet::GetPrintUseDataMax( );
void CSpreadSheet::SetPrintUseDataMax(BOOL value);
[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