Spread Windows Forms 12.0 Product Documentation
GetPreferredPrintColumnWidth Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : GetPreferredPrintColumnWidth Method
Gets the width of the widest cell (based on text content) in the specified column on this sheet for printing to the specified graphics device.
Overload List
OverloadDescription
Gets the width of the widest cell (based on text content) in the specified column on this sheet for printing to the specified graphics device.  
Example
This example returns the width of the widest cell (based on text contents) in the first column on this sheet.
private void GetPrintWidth(Graphics g, float s, FarPoint.Win.Spread.SheetView sheet) 
{ 
    sheet = fpSpread1.ActiveSheet; s = sheet.GetPreferredPrintColumnWidth(g, 0); 
}

private void button1_Click(object sender, System.EventArgs e)
{
     Graphics g;
     g = fpSpread1.CreateGraphics();
     float sngl = 0;
     GetPrintWidth(g, sngl, fpSpread1.ActiveSheet); MessageBox.Show(sngl.ToString()); } 
Private Sub GetPrintWidth(ByVal g As Graphics, ByVal s As Single, ByVal sheet As FarPoint.Win.Spread.SheetView) 
     sheet = FpSpread1.ActiveSheet 
     s = sheet.GetPreferredPrintColumnWidth(g, 0) 
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
     Dim g As Graphics
     g = FpSpread1.CreateGraphics()
     Dim sngl As Single
     GetPrintWidth(g, sngl, FpSpread1.ActiveSheet)
     MessageBox.Show(sngl.ToString())
End Sub 
See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Printing