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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
