Spread 8.0 Documentation
SSGetMaxCols, SSSetMaxCols Functions
Support Options
DLL Reference > DLL Functions > SSGetMaxCols, SSSetMaxCols Functions

Glossary Item Box

SSGetMaxCols, SSSetMaxCols Functions


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Set or return the maximum number of usable columns in the sheet.

Syntax

C

SS_COORD SSGetMaxCols(HWND hWnd);

void SSSetMaxCols(HWND hWnd, SS_COORD MaxCols);

C++

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

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