GetPreferredCellSize Method

Gets the desired size of the given cell on this sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Function GetPreferredCellSize( _
   ByVal row As Integer, _
   ByVal col As Integer _
) As Size

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim col As Integer
Dim value As Size
 
value = instance.GetPreferredCellSize(row, col)

public Size GetPreferredCellSize( 
   int row,
   int col
)

Parameters

row: Row index
col: Column index

Return Value

Integer number of pixels of the size of the specified cell

Example

This example illustrates the use of this member by returning the preferred size for the specified cell.

System.Drawing.Size sz;
fpSpread1.ActiveSheet.SetValue(0, 0, "Let's get the preferred size");
sz = fpSpread1.ActiveSheet.GetPreferredCellSize(0,0);
listBox1.Items.Add(sz.ToString());

Visual Basic

Dim sz As System.Drawing.Size
FpSpread1.ActiveSheet.SetValue(0, 0, "Let's get the preferred size")
sz = FpSpread1.ActiveSheet.GetPreferredCellSize(0, 0)
ListBox1.Items.Add(sz.ToString())

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

Reference

SheetView Class
SheetView Members
GetPreferredColumnWidth Method
GetPreferredRowHeight Method

User-Task Documentation

Resizing the Row or Column to Fit the Data