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

Use the repeat properties of the PrintInfo object.

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);

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)

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)