Gets or sets whether column widths are adjusted to fit the longest string width for printing.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property BestFitCols As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As PrintInfo
Dim value As Boolean
instance.BestFitCols = value
value = instance.BestFitCols |
| C# | |
|---|
public bool BestFitCols {get; set;} |
Property Value
Boolean:
true to automatically adjust column widths;
false otherwise
Remarks
Example
This example shows how to define the settings for optimizing the printing.
| C# | Copy Code |
|---|
// Typically you would use one type of optimization; they are all shown here for illustration only
// Define the printer settings for optimization
FarPoint.Win.Spread.PrintInfo printset = new FarPoint.Win.Spread.PrintInfo();
FarPoint.Win.Spread.SmartPrintRulesCollection prules = new FarPoint.Win.Spread.SmartPrintRulesCollection();
// ... use best fit of columns and rows
printset.BestFitCols = true;
printset.BestFitRows = true;
// ... or check by page size
printset.SmartPrintPagesTall = 1;
printset.SmartPrintPagesWide = 1;
// ... or use the rules defined
prules.Add(new FarPoint.Win.Spread.BestFitColumnRule(FarPoint.Win.Spread.ResetOption.None));
prules.Add(new FarPoint.Win.Spread.LandscapeRule(FarPoint.Win.Spread.ResetOption.Current));
prules.Add(new FarPoint.Win.Spread.ScaleRule(FarPoint.Win.Spread.ResetOption.None, 1, 0.6, 0.1));
printset.SmartPrintRules = prules;
printset.UseSmartPrint = true;
// Assign the printer settings to the sheet and print it
fpSpread1.Sheets[0].PrintInfo = printset;
fpSpread1.PrintSheet(0); |
| Visual Basic | Copy Code |
|---|
' Typically you would use one type of optimization; they are all shown here for illustration only
' Define the printer settings for optimization
Dim printset As New FarPoint.Win.Spread.PrintInfo()
Dim prules As New FarPoint.Win.Spread.SmartPrintRulesCollection
' ... use best fit of columns and rows
printset.BestFitCols = True
printset.BestFitRows = True
' ... or check by page size
printset.SmartPrintPagesTall = 1
printset.SmartPrintPagesWide = 1
' ... or use the rules defined
prules.Add(New FarPoint.Win.Spread.BestFitColumnRule(FarPoint.Win.Spread.ResetOption.None))
prules.Add(New FarPoint.Win.Spread.LandscapeRule(FarPoint.Win.Spread.ResetOption.Current))
prules.Add(New FarPoint.Win.Spread.ScaleRule(FarPoint.Win.Spread.ResetOption.None, 1, 0.6, 0.1))
printset.SmartPrintRules = prules
printset.UseSmartPrint = True
' Assign the printer settings to the sheet and print it
FpSpread1.Sheets(0).PrintInfo = printset
FpSpread1.PrintSheet(0) |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
