SSGetAutoSizeVisible, SSSetAutoSizeVisible Functions
Applies To
fpSpread DLL control
Description
Set or return the number of visible columns and rows in the sheet.
Syntax
void SSGetAutoSizeVisible(HWND hWnd, LPSS_COORD lpVisibleCols, LPSS_COORD lpVisibleRows);
void SSSetAutoSizeVisible(HWND hWnd, SS_COORD VisibleCols, SS_COORD VisibleRows);
void TSpread::GetAutoSizeVisible(LPSS_COORD lpVisibleCols, LPSS_COORD lpVisibleRows);
void TSpread::SetAutoSizeVisible(SS_COORD VisibleCols, SS_COORD VisibleRows);
Parameters
The SSGetAutoSizeVisible function has the following parameters:
| Parameter | Description |
|---|---|
| hWnd | Window handle of the fpSpread control |
| lpVisibleCols | Pointer to the variable that receives the number of visible columns |
| lpVisibleRows | Pointer to the variable that receives the number of visible rows |
The SSSetAutoSizeVisible function has the following parameters:
| Parameter | Description |
|---|---|
| hWnd | Window handle of the fpSpread control |
| VisibleCols | Number of visible columns |
| VisibleRows | Number of visible rows |
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.
Use the SSSetAutoSizeVisible function to prevent the sheet from displaying partial columns and rows. The SSGetAutoSizeVisible function returns the number of columns and rows currently displayed in the lpVisibleCols and lpVisibleRows parameters.
Place the control in autosize mode using the SSSetBool function with the SSB_AUTOSIZE option. When the control is in this mode, it automatically resizes itself to completely display the specified number of columns and rows each time the window is resized.
If the control size is larger than the dialog, the control clips to the edge of the dialog. To prevent this in an MDI window, resize the control, call the SSGetClientRect function to get the size of the control, and then redraw the window. This keeps the window sized correctly for the control.
This feature is similar to the Windows list box style LBS_NOINTEGRALHEIGHT.
See Also
Displaying a Specified Number of Columns and Rows
SSGetClientRect, SSGetVisible, SSSetBool, SSSetSheet, SSShowCol, SSShowRow functions
ActiveX Correspondence
VisibleCols, VisibleRows properties