Example

The following example sets a print page break before column 15 or row 10 whichever comes first.

C++

if (m_Spread.GetCol() == 15);
m_Spread.SetColPageBreak(TRUE);
else if (m_Spread.GetRow() == 10);
m_Spread.SetRowPageBreak(TRUE);

Visual Basic

If fpSpread1.Col() = 15 Then
    fpSpread1.ColPageBreak = True
Else
    If fpSpread1.Row() = 10 Then
        fpSpread1.RowPageBreak = True
    End If
End If