Example
The following example checks to see if the border around cell B3 is solid. If the border is solid it sets the border around the C3 cell as red, dash dot.
C++
void CTestDlg::OnShowWindow(BOOL bShow, UINT nStatus)
{
CDialog::OnShowWindow(bShow,
// Make the border around cell B3 solid, dark blue
m_Spread1.SetCellBorder(2, 3, 2, 3, 16, RGB(0,0,255), CellBorderStyleSolid);
}
void CTestDlg::OnButton1()
{
VARIANT Color, Style;
m_Spread1.GetCellBorder(2, 3, 16, &Color, &Style);
if( 1 == Style.lVal )
m_Spread1.SetCellBorder(3, 3, 3, 3, 16, RGB(255,0,0), CellBorderStyleDashDotDot);
}
Visual Basic
Private Sub Form_Load()
' Make the border around cell B3 solid, dark blue
fpSpread1.SetCellBorder 2, 3, 2, 3, 16, &H800000, CellBorderStyleSolid
End Sub
Private Sub Command1_Click()
Dim Style As Variant
Dim Color As Variant
fpSpread1.GetCellBorder 2, 3, 16, Color, Style
If Style = 1 Then
fpSpread1.SetCellBorder 3, 3, 3, 3, 16, &HFF, CellBorderStyleDashDotDot
End If
End Sub