You can customize the printing by setting the properties of a PrintInfo object and setting the PrintInfo property of a sheet to that object. The PrintInfo object has the settings for customizing the printing of a sheet.

The PrintInfo object provides the following properties for customizing the printing:

Using the Properties Window

1. At design time, in the Properties window, select the Spread component.
2. Select the Sheets property.
3. Click the button to display the SheetView Collection Editor.
4. In the Members list, select the sheet for which to set the print options.
5. In the properties list, double-click the PrintInfo property to display the settings for the PrintInfo class.
6. Set the properties listed above as needed to set your print options.
7. Click OK to close the editor.

Using a Shortcut

1. Create and set properties for a PrintInfo object.
2. Set the Sheet shortcut object PrintInfo property to the PrintInfo object you just created.

Example

This example code creates a PrintInfo object, sets properties to specify to not print grid lines or row headers, and to print only cells with data in them.

// Create PrintInfo object and set properties.
FarPoint.Win.Spread.PrintInfo printset = new FarPoint.Win.Spread.PrintInfo();
printset.ShowGrid = false;
printset.ShowRowHeader = FarPoint.Win.Spread.PrintHeader.Hide;
printset.UseMax = true;
// Set the PrintInfo property for the first sheet.
fpSpread1.Sheets[0].PrintInfo = printset;
// Print the sheet.
fpSpread1.PrintSheet(0);

' Create PrintInfo object and set properties.
Dim printset As New FarPoint.Win.Spread.PrintInfo()
printset.ShowGrid = False
printset.ShowRowHeader = FarPoint.Win.Spread.PrintHeader.Hide
printset.UseMax = True
' Set the PrintInfo property for the first sheet.
FpSpread1.Sheets(0).PrintInfo = printset
' Print the sheet.
FpSpread1.PrintSheet(0)

Using Code

1. Create and set properties for a PrintInfo object.
2. Set the SheetView object PrintInfo property to the PrintInfo object you just created.

Example

This example code creates a PrintInfo object, sets properties to specify to not print grid lines or row headers, and to print only cells with data in them.

// Create PrintInfo object and set properties.
FarPoint.Win.Spread.PrintInfo printset = new FarPoint.Win.Spread.PrintInfo();
printset.ShowGrid = false;
printset.ShowRowHeader = FarPoint.Win.Spread.PrintHeader.Hide;
printset.UseMax = true;
// Create SheetView object and assign it to the first sheet.
FarPoint.Win.Spread.SheetView SheetToPrint = new FarPoint.Win.Spread.SheetView();
SheetToPrint.PrintInfo = printset;
fpSpread1.Sheets[0] = SheetToPrint;
// Print the sheet.
fpSpread1.PrintSheet(0);

' Create PrintInfo object and set properties.
Dim printset As New FarPoint.Win.Spread.PrintInfo()
printset.ShowGrid = False
printset.ShowRowHeader = FarPoint.Win.Spread.PrintHeader.Hide
printset.UseMax = True
' Create SheetView object and assign it to the first sheet.
Dim SheetToPrint As New FarPoint.Win.Spread.SheetView()
SheetToPrint.PrintInfo = printset
FpSpread1.Sheets(0) = SheetToPrint
' Print the sheet.
FpSpread1.PrintSheet(0)

Using the Spread Designer

1. Select the sheet tab for the sheet for which you want to set print settings.
2. Select the Page Layout option.
3. Select the PrintTitles icon, choose General.

   The Sheet Print dialog appears.

4. Set the print options using the General, Output, Header/Footer, SmartPrint, Pagination, and Margins tab options.
5. Click OK to close the Sheet Print Options dialog.
6. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.

Copyright © GrapeCity, inc. All rights reserved.