Spread Windows Forms 9.0 Product Documentation
GetPreferredPrintColumnWidth Method
Example 


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
GetPreferredPrintColumnWidthGets 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 
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Printing

 

 


Copyright © GrapeCity, inc. All rights reserved.