'Declaration Public Property BestFitCols As Boolean
'Usage Dim instance As PrintInfo Dim value As Boolean instance.BestFitCols = value value = instance.BestFitCols
public bool BestFitCols {get; set;}
'Declaration Public Property BestFitCols As Boolean
'Usage Dim instance As PrintInfo Dim value As Boolean instance.BestFitCols = value value = instance.BestFitCols
public bool BestFitCols {get; set;}
This property sets the width of columns. To size the rows to the tallest row height, use the BestFitRows property.
For information on the optimization rule (SmartPrintRule) that applies to using this property to optimize the printing, refer to BestFitColumnRule Class.
// 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);
' 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)