Spread Windows Forms 6.0 Product Documentation
Multiline Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > RichTextCellType Class : Multiline Property


Glossary Item Box

Gets or sets whether multiple lines of text are allowed.

Syntax

Visual Basic (Declaration) 
Public Property Multiline As Boolean
Visual Basic (Usage)Copy Code
Dim instance As RichTextCellType
Dim value As Boolean
 
instance.Multiline = value
 
value = instance.Multiline
C# 
public bool Multiline {get; set;}

Property Value

Boolean: true if multiple lines of text are allowed; false otherwise

Remarks

When set to true, multiple lines are allowed, but text is not automatically wrapped to new lines when the number of characters exceeds the width of the cell. To wrap lines of text automatically, set the WordWrap property. Otherwise, to wrap lines of text, be sure to type in carriage-return characters to force the text to the new lines.

If the Multiline property is set to true, the row height returned by the GetPreferredRowHeight might be smaller than what is necessary to display the entire cell if there are multiple font sizes and styles on each line.

To always display a scroll bar (ForcedBoth, ForcedHorizontal, or ForcedVertical enumeration settings) in a rich text cell, you must set the Multiline property to true. Refer to the ScrollBars property.

Example

This example loads a rich-text-formatted file into the cell.
C#Copy Code
FarPoint.Win.Spread.CellType.RichTextCellType rtb;

private void Form1Load(object sender, System.EventArgs e)
{
      rtb = new FarPoint.Win.Spread.CellType.RichTextCellType();
      rtb.Multiline = true;
      fpSpread1.ActiveSheet.Cells[0, 0].CellType = rtb;
      System.IO.StreamReader file = new System.IO.StreamReader(Application.StartupPath + "\\test.rtf");
      string words = file.ReadToEnd();
      fpSpread1.ActiveSheet.Cells[0, 0].Value = words;
}
Visual BasicCopy Code
Dim rtb As New FarPoint.Win.Spread.CellType.RichTextCellType

Private Sub Form1Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
      rtb.Multiline = True
      FpSpread1.ActiveSheet.Cells(0, 0).CellType = rtb
      Dim file As New System.IO.StreamReader(Application.StartupPath & "\test.rtf")
      Dim words As String = file.ReadToEnd()
      FpSpread1.ActiveSheet.Cells(0, 0).Value = words
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.