BestFitColumns Property

Gets or sets whether column widths are adjusted to fit the longest text width for printing.

Syntax

Visual Basic
C#

'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property BestFitColumns As System.Boolean

'Usage
 
Dim instance As PrintInfo
Dim value As System.Boolean
 
instance.BestFitColumns = value
 
value = instance.BestFitColumns

[System.ComponentModel.DefaultValue()]
public System.bool BestFitColumns {get; set;}

Property Value

true if the column widths are adjusted to fit the longest text for printing; otherwise, false. The default value is false.

Example

This example sets the BestFitColumns property.

string fileName;
fileName = "c:\\zipfile\\test.pdf";
System.IO.Stream stream;
stream = System.IO.File.Create(fileName);

GrapeCity.Windows.SpreadSheet.Data.PrintInfo printtest;
printtest = gcSpreadSheet1.Sheets[0].PrintInfo;
printtest.FooterCenter = "This is Page &P";
printtest.HeaderCenter = "Test &UPrint";
printtest.BestFitColumns = true;
printtest.UseMax = true;

GrapeCity.Windows.SpreadSheet.Data.PdfExportSettings test;
test = new GrapeCity.Windows.SpreadSheet.Data.PdfExportSettings();
test.Title = "Print PDF";
test.Author = "GrapeCity, Inc.";
test.DisplayDocTitle = true;
test.FitWindow = true;
gcSpreadSheet1.SavePDF(stream, test, 0);

VB.NET

Dim fileName As String
fileName = "c:\zipfile\test.pdf"
Dim stream As System.IO.Stream
stream = System.IO.File.Create(fileName)

Dim printtest As GrapeCity.Windows.SpreadSheet.Data.PrintInfo
printtest = GcSpreadSheet1.Sheets(0).PrintInfo
printtest.FooterCenter = "This is Page &P"
printtest.HeaderCenter = "Test &UPrint"
printtest.BestFitColumns = True
printtest.UseMax = True

Dim test As GrapeCity.Windows.SpreadSheet.Data.PdfExportSettings
test = New GrapeCity.Windows.SpreadSheet.Data.PdfExportSettings()
test.Title = "Print PDF"
test.Author = "GrapeCity, Inc."
test.DisplayDocTitle = True
test.FitWindow = True
GcSpreadSheet1.SavePDF(stream, test, 0)

Reference

PrintInfo Class
PrintInfo Members