Example
The following example loads an existing .SS7 file (TEAMS.SS7) with data and header text. The control is set up to optimize viewing and editing the data, including only displaying scroll bars when needed, scrolling the sheet in response to the user moving the vertical scroll bar, and allowing the user to copy and paste row headers.
To access the file used in this sample, change the path in the code to the path for your product installation's \SAMPLES\FILES directory.
C++
void CmyWnd::MyFunc()
{
// Load file with data and header text
m_Spread1.LoadFromFile("C:\\Samples\\Files\\teams.ss7");
// Specify the maximum number of columns and rows
m_Spread1.SetMaxCols(2);
m_Spread1.SetMaxRows(29);
// Specify the column widths
m_Spread1.SetColWidth(0,10);
m_Spread1.SetColWidth(-1,15);
// Left-align the row header text
m_Spread1.SetCol(0);
m_Spread1.SetRow(-1);
m_Spread1.SetTypeHAlign(TypeHAlignLeft);
// Center-align the text in the data columns
m_Spread1.SetBlockMode(True);
m_Spread1.SetCol(1);
m_Spread1.SetRow(-1);
m_Spread1.SetCol2(2);
m_Spread1.SetTypeHAlign(TypeHAlignCenter);
m_Spread1.SetBlockMode(False);
// Allow users to copy and paste row headers
m_Spread1.SetClipboardOptions(ClipboardOptionsCopyRowHeaders | ClipboardOptionsPasteRowHeaders);
// Do not display the scroll bars unless necessary
m_Spread1.SetScrollBarExtMode(True);
// Have the vertical scroll bar scroll the sheet
m_Spread1.SetScrollBarTrack(ScrollBarTrackVertical);
}
Visual Basic
Sub Form_Load()
' Load file with data and header text
fpSpread1.LoadFromFile("C:\Samples\Files\teams.ss7")
' Specify the maximum number of columns and rows
fpSpread1.MaxCols = 2
fpSpread1.MaxRows = 29
' Specify the column widths
fpSpread1.ColWidth(0) = 10
fpSpread1.ColWidth(-1) = 15
' Left-align the row header text
fpSpread1.Col = 0
fpSpread1.Row = -1
fpSpread1.TypeHAlign = TypeHAlignLeft
' Center-align the text in the data columns
fpSpread1.BlockMode = True
fpSpread1.Col = 1
fpSpread1.Row = -1
fpSpread1.Col2 = 2
fpSpread1.TypeHAlign = TypeHAlignCenter
fpSpread1.BlockMode = False
' Allow users to copy and paste row headers
fpSpread1.ClipboardOptions = ClipboardOptionsCopyRowHeaders or ClipboardOptionsPasteRowHeaders
' Do not display the scroll bars unless necessary
fpSpread1.ScrollBarExtMode = True
' Have the vertical scroll bar scroll the sheet
fpSpread1.ScrollBarTrack = ScrollBarTrackVertical
End Sub