Spread for ASP.NET 9.0 Product Documentation
Setting Smart Print Options

Spread can automatically determine the best way to print your sheet. By using rules that you can choose, it can decide, for example, whether it is best to print your sheet on landscape- or portrait-oriented pages.

The properties that you use to configure smart printing are part of the PrintInfo class. These properties only have an effect when
content is saved to PDF.

The printing optimization rules, which you can turn on or off, can be customized by setting the properties of these rule objects:

Rule Object Description
LandscapeRule Determines whether to print the sheet in landscape or portrait orientation.
ScaleRule Determines the best scale at which to print the sheet, starting with 100% (Start Factor = 1), and decreasing at set intervals to a minimum size (End Factor).Default settings are Start Factor = 1, End Factor = 0.6, and Interval = 0.1.
BestFitColumnRule Determines how best to fit the columns in the sheet on the page

By default, optimizing the printing of the sheet uses the following logic:

You can customize how this logic is applied through the rule objects. If you customize the rule object, the default rules are ignored and only the custom rules are used for printing. You can set up a collection of these rules with the SmartPrintRulesCollection object and set whether to use these rules with the UseSmartPrint property and SmartPrintRule object.

Using Code

  1. Create a PrintInfo object.
  2. If you want to change how SmartPrint determines how best to print the sheet, create a new SmartPrintRulesCollection object.
  3. Set the UseSmartPrint property to true.
  4. Set the SheetView object PrintInfo property to the PrintInfo object you just created.

Example

This example code prints using customized print rules, set up in the SmartPrintRulesCollection object. In this example, if the sheet does fit on a page by shrinking columns to the longest text string, it prints with the columns shrunk. If it does not fit with the columns shrunk, it keeps them shrunk and tries to print in landscape orientation. If it does not fit with the columns shrunk and in landscape orientation, it keeps these settings and tries to scale the sheet, starting at 100%, then decreasing by 20% intervals down to 40%.

C#
Copy Code
// Create the print rules.
FarPoint.Web.Spread.SmartPrintRulesCollection printrules = new FarPoint.Web.Spread.SmartPrintRulesCollection();
printrules.Add(new FarPoint.Web.Spread.BestFitColumnRule(FarPoint.Web.Spread.ResetOption.None));
printrules.Add(new FarPoint.Web.Spread.LandscapeRule(FarPoint.Web.Spread.ResetOption.None));
printrules.Add(new FarPoint.Web.Spread.ScaleRule(FarPoint.Web.Spread.ResetOption.All, 1.0f, .4f, .2f));
// Create a PrintInfo object and set the properties.
FarPoint.Web.Spread.PrintInfo printset = new FarPoint.Web.Spread.PrintInfo();
printset.SmartPrintRules = printrules;
printset.UseSmartPrint = true;
fpSpread1.Sheets[0].PrintInfo = printset;
// Print the sheet.
fpSpread1.SavePdf("c:\\test.pdf");
VB
Copy Code
' Create the print rules.
Dim printrules As New FarPoint.Web.Spread.SmartPrintRulesCollection()
printrules.Add(New FarPoint.Web.Spread.BestFitColumnRule(FarPoint.Web.Spread.ResetOption.None))
printrules.Add(New FarPoint.Web.Spread.LandscapeRule(FarPoint.Web.Spread.ResetOption.None))
printrules.Add(New FarPoint.Web.Spread.ScaleRule(FarPoint.Web.Spread.ResetOption.All, 1.0F, 0.4F, 0.2F))
' Create a PrintInfo object and set the properties.
Dim printset As New FarPoint.Web.Spread.PrintInfo()
printset.SmartPrintRules = printrules
printset.UseSmartPrint = True
FpSpread1.Sheets(0).PrintInfo = printset
' Print the sheet.
FpSpread1.SavePdf("C:\test.pdf")
See Also

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback