Spread 8.0 Documentation
SSGetAutoSizeVisible, SSSetAutoSizeVisible Functions
Support Options
DLL Reference > DLL Functions > SSGetAutoSizeVisible, SSSetAutoSizeVisible Functions

Glossary Item Box

SSGetAutoSizeVisible, SSSetAutoSizeVisible Functions


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Set or return the number of visible columns and rows in the sheet.

Syntax

C

void SSGetAutoSizeVisible(HWND hWnd, LPSS_COORD lpVisibleCols, LPSS_COORD lpVisibleRows);

void SSSetAutoSizeVisible(HWND hWnd, SS_COORD VisibleCols, SS_COORD VisibleRows);

C++

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

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