Example

The following example creates a sheet with 10 visible rows and 4 visible columns that sizes to display only complete rows and columns.

C++

// Set the number of visible rows
m_Spread.SetVisibleRows(10);
// Set the number of visible columns
m_Spread.SetVisibleCols(4);
// Allow autoresizing of control to fill parent
m_Spread.SetAutoSize(TRUE);

Visual Basic

' Set the number of visible rows
fpSpread1.VisibleRows = 10
' Set the number of visible columns
fpSpread1.VisibleCols = 4
' Allow autoresizing of control to fill parent
fpSpread1.AutoSize = True