Spread Windows Forms 11.0 Product Documentation
Repeating Rows or Columns on Printed Pages
Spread Windows Forms 11.0 Product Documentation > Developer's Guide > Managing Printing > Customizing the Appearance of the Printing > Repeating Rows or Columns on Printed Pages

You can specify that rows appear at the top of every printed page or specify that columns appear on the left side of every printed page. Use the RepeatRowStart, RepeatRowEnd, RepeatColStart, and RepeatColEnd properties of the PrintInfo object.

Using Code

  1. Use the repeat properties of the PrintInfo object.
  2. Use the PrintSheet method to print the sheet.

Example

This example sets the repeat options and uses a preview dialog.

C#
Copy Code
FarPoint.Win.Spread.PrintInfo printset = new FarPoint.Win.Spread.PrintInfo();
printset.RepeatColStart = 0;
printset.RepeatColEnd = 2;
printset.RepeatRowStart = 0;
printset.RepeatRowEnd = 2;
printset.Preview = true;
fpSpread1.Sheets[0].PrintInfo = printset;
fpSpread1.PrintSheet(0);
VB
Copy Code
Dim printset As New FarPoint.Win.Spread.PrintInfo
printset.RepeatColStart = 0
printset.RepeatColEnd = 2
printset.RepeatRowStart = 0
printset.RepeatRowEnd = 2
printset.Preview = True
fpSpread1.Sheets(0).PrintInfo = printset
fpSpread1.PrintSheet(0)
See Also