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.
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
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