Spread WPF 15
GrapeCity.Windows.SpreadSheet.Data Namespace / PrintInfo Class / BestFitColumns Property

In This Topic
    BestFitColumns Property
    In This Topic
    Gets or sets whether column widths are adjusted to fit the longest text width for printing.
    Public Property BestFitColumns As Boolean
    Dim instance As PrintInfo
    Dim value As Boolean
    instance.BestFitColumns = value
    value = instance.BestFitColumns
    public 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.
    This example uses 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);
    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)
    See Also