BestFitRows Property

Gets or sets whether row heights are adjusted to fit the tallest text height for printing.

Syntax

Visual Basic
C#

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

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

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

Property Value

true if the row heights are adjusted to fit the tallest text for printing; otherwise, false. The default value is false.

Example

This example sets the BestFitRows property.

SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "PDF File (.pdf)|*.pdf";
bool? useClick = saveFileDialog.ShowDialog();
if (useClick == true)
{
    var stream = saveFileDialog.OpenFile();

GrapeCity.Windows.SpreadSheet.Data.PrintInfo printset = new GrapeCity.Windows.SpreadSheet.Data.PrintInfo();
printset.BestFitRows = true;
printset.Centering = GrapeCity.Windows.SpreadSheet.Data.Centering.Both;
printset.ColumnEnd = 10;
printset.ColumnStart = 0;
gcSpreadSheet1.Sheets[0].PrintInfo = printset;
gcSpreadSheet1.SavePDF(stream, 0);

 stream.Dispose();
}

VB.NET

Dim saveFileDialog = New SaveFileDialog()
saveFileDialog.Filter = "PDF File(.pdf)|*.pdf"
Dim useClick As Boolean = saveFileDialog.ShowDialog()
If (useClick = True) Then
Dim stream = saveFileDialog.OpenFile()

Dim printset As New GrapeCity.Windows.SpreadSheet.Data.PrintInfo()
printset.BestFitRows = True
printset.Centering = GrapeCity.Windows.SpreadSheet.Data.Centering.Both
printset.ColumnEnd = 10
printset.ColumnStart = 0
GcSpreadSheet1.Sheets(0).PrintInfo = printset
GcSpreadSheet1.SavePDF(stream, 0)

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

PrintInfo Class
PrintInfo Members