AutoSize Property
Applies To
fpSpread control
Description
Sets or returns whether the fpSpread control automatically changes its size to the number of specified columns and rows or the size of the parent, whichever is smaller.
Syntax
BOOL CSpreadSheet::GetAutoSize( );
void CSpreadSheet::SetAutoSize(BOOL value);
[form.]fpSpread.AutoSize[ = boolean%]
Remarks
The default value for the AutoSize property is False.
This setting is applied to the entire workbook, including all sheets in the control.
When the AutoSize property is set to True, the control increases or decreases its height and width to display the specified number of visible or available columns or rows so it does not display a gray area.
When increasing or decreasing its size, if you have specified values for the VisibleCols and VisibleRows properties, the control sizes itself to the size that will display the number of columns and rows you have specified for these properties or the size of the parent, whichever is greater. If the VisibleCols and VisibleRows properties are set to 0, the control sizes itself to the number of columns and rows you have specified for the MaxCols and MaxRows properties or the size of the parent, whichever is smaller.
If the AutoSize property is set to True, the control changes its height on the bottom and its width on the right side. The control does not shift position to either the top or left. If you move the control toward the top or left after setting the AutoSize property or if you change the size of the parent, the control does not resize itself unless you set the AutoSize property to False and then back to True.
Spread Designer
Choose the Book menu, then the Environment menu, select the Environment tab, and then choose the Autosize On check box in the Book Settings dialog box.
Data Type
Integer (Boolean)
See Also
Displaying a Specified Number of Columns and Rows
MaxCols, MaxRows, VisibleCols, VisibleRows properties
DLL Correspondence
SSGetBool (SSB_AUTOSIZE), SSSetBool (SSB_AUTOSIZE) functions