PreferredSizeRowOptions Enumeration

Specifies the options when getting the preferred height for the row.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum PreferredSizeRowOptions 
   Inherits System.Enum

'Usage
 
Dim instance As PreferredSizeRowOptions

public enum PreferredSizeRowOptions : System.Enum

Members

Member	Description
ExcludeHeaders	Specifies to ignore headers
ExcludeSpans	Specifies to ignore spans
IncludeAll	Specifies to Include all automatic fit options
Off	Specifies to turn off automatic fit for the row height

Example

This example uses the PreferredSizeRowOptions enumerations.

fpSpread1.ActiveSheet.ColumnHeader.Cells[0,2].Text = "Column Header Text";
fpSpread1.ActiveSheet.Cells[1, 1].Text = "Text in cell (1, 1)";
FarPoint.Win.Spread.CellType.TextCellType textcell = new FarPoint.Win.Spread.CellType.TextCellType();
textcell.WordWrap = true;
fpSpread1.ActiveSheet.Cells[2, 2].CellType = textcell;
fpSpread1.ActiveSheet.Cells[2, 2].Text = "Spread Windows Forms and the Funnel Chart";
fpSpread1.AutoFitColumnOptions = FarPoint.Win.Spread.PreferredSizeColumnOptions.ExcludeHeaders | FarPoint.Win.Spread.PreferredSizeColumnOptions.ExcludeSpans;
fpSpread1.AutoFitRowOptions = FarPoint.Win.Spread.PreferredSizeRowOptions.ExcludeHeaders;

private void button1_Click(object sender, EventArgs e)
        {
float size;
size = fpSpread1.ActiveSheet.GetPreferredColumnWidth(2, FarPoint.Win.Spread.PreferredSizeColumnOptions.ExcludeHeaders | FarPoint.Win.Spread.PreferredSizeColumnOptions.ExcludeSpans);
textBox1.Text = size.ToString();
        }

Visual Basic

FpSpread1.ActiveSheet.ColumnHeader.Cells(0, 2).Text = "Column Header Text"
FpSpread1.ActiveSheet.Cells(1, 1).Text = "Text in cell (1, 1)"
Dim textcell As New FarPoint.Win.Spread.CellType.TextCellType()
textcell.WordWrap = True
FpSpread1.ActiveSheet.Cells(2, 2).CellType = textcell
FpSpread1.ActiveSheet.Cells(2, 2).Text = "Spread Windows Forms and the Funnel Chart"
FpSpread1.AutoFitColumnOptions = FarPoint.Win.Spread.PreferredSizeColumnOptions.ExcludeHeaders Or FarPoint.Win.Spread.PreferredSizeColumnOptions.ExcludeSpans
FpSpread1.AutoFitRowOptions = FarPoint.Win.Spread.PreferredSizeRowOptions.ExcludeHeaders

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim size As Integer
size = FpSpread1.ActiveSheet.GetPreferredRowHeight(2, FarPoint.Win.Spread.PreferredSizeRowOptions.ExcludeHeaders)
TextBox1.Text = size
End Sub

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.PreferredSizeRowOptions

Reference

FarPoint.Win.Spread Namespace