SSGetMaxCols, SSSetMaxCols Functions
Applies To
fpSpread DLL control
Description
Set or return the maximum number of usable columns in the sheet.
Syntax
SS_COORD SSGetMaxCols(HWND hWnd);
void SSSetMaxCols(HWND hWnd, SS_COORD MaxCols);
SS_COORD TSpread::GetMaxCols( );
void TSpread::SetMaxCols(SS_COORD MaxCols);
Parameters
The SSGetMaxCols function has the following parameter:
| Parameter | Description |
| hWnd | Window handle of the fpSpread control |
The SSSetMaxCols function has the following parameters:
| Parameter | Description |
| hWnd | Window handle of the fpSpread control |
| MaxCols | Number of columns allowed in sheet |
Remarks
This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.
The maximum value can be any value from zero through two billion. You can change the maximum number of columns at any time.
| Caution: If you decrease the maximum number of columns, any data or formats in the columns beyond the new setting are lost. |
To increase the maximum number of columns when a column is inserted, first use the SSSetMaxCols function to increment the maximum number of columns by one, then use the SSInsCol function to insert the column.
Return Value
SSGetMaxCols: Maximum number of columns in the sheet.
See Also
Setting the Maximum Number of Columns and Rows
SSGetMaxRows, SSInsCol, SSSetMaxRows, SSSetSheet functions
ActiveX Correspondence
MaxCols property