-
Spread Windows Forms Product Documentation
- Getting Started
-
Developer's Guide
- Understanding the Product
- Working with the Component
- Spreadsheet Objects
- Ribbon Control
- Sheets
- Rows and Columns
- Headers
- Cells
- Cell Types
- Data Binding
- Customizing the Sheet Appearance
- Customizing Interaction in Cells
- Tables
- Understanding the Underlying Models
- Customizing Row or Column Interaction
- Formulas in Cells
- Sparklines
- Keyboard Interaction
- Events from User Actions
- File Operations
- Storing Excel Summary and View
- Printing
- Chart Control
- Customizing Drawing
- Touch Support with the Component
- Spread Designer Guide
- Assembly Reference
- Import and Export Reference
- Version Comparison Reference
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.
Use the PrintSheet method to print the sheet.
Example
This example sets the repeat options and uses a preview dialog.
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);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
Understanding the Printing Options
Customizing the Print Job Settings
Customizing the Printed Page Layout
Customizing the Printed Page Header or Footer