Spread for ASP.NET 7.0 Product Documentation
AllowWrap Property
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > HyperLinkCellType Class : AllowWrap Property


Glossary Item Box

Gets or sets whether the cell allows text to wrap to multiple lines. Wrapping only occurs on word breaks.

Syntax

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

Example

This example sets the AllowWrap property.
C#Copy Code
FarPoint.Web.Spread.ComboBoxCellType cb = new FarPoint.Web.Spread.ComboBoxCellType();
FarPoint.Web.Spread.ListItem[] items = new FarPoint.Web.Spread.ListItem[3];
FarPoint.Web.Spread.ListItem item = new FarPoint.Web.Spread.ListItem();
item.Text = "This is a test of show ellipsis";
item.Value = "1";
items[0] = item;
item = new FarPoint.Web.Spread.ListItem();
item.Text = "B";
item.Value = "2";
items[1] = item;
cb.ListItems = items;
cb.AllowWrap = true;
cb.ShowEllipsis = false;
FpSpread1.ActiveSheetView.Cells[0,0].CellType = cb;
FpSpread1.ActiveSheetView.Cells[0,0].Value = "1";
    
FarPoint.Web.Spread.ButtonCellType btest = new FarPoint.Web.Spread.ButtonCellType();
btest.ButtonType = FarPoint.Web.Spread.ButtonType.LinkButton;
btest.AllowWrap = false;
btest.ShowEllipsis = true;
btest.Text = "this is a test of allow wrap";
FpSpread1.Sheets[0].Cells[0, 1].CellType = btest;
    
string linkURL = "http://www.FarPointSpread.com";
string linkTarget = "_blank";
FarPoint.Web.Spread.HyperLinkCellType linkcell = new FarPoint.Web.Spread.HyperLinkCellType();
linkcell.NavigateUrl = linkURL;
linkcell.Target = linkTarget;
linkcell.AllowWrap = false;
linkcell.ShowEllipsis = true;
FpSpread1.Sheets[0].Cells[1, 1].CellType = linkcell;
Visual BasicCopy Code
Dim cb As New FarPoint.Web.Spread.ComboBoxCellType
Dim items(2) As FarPoint.Web.Spread.ListItem
Dim item As New FarPoint.Web.Spread.ListItem
item.Text = "This is a test of show ellipsis"
item.Value = "1"
items(0) = item
item = New FarPoint.Web.Spread.ListItem
item.Text = "B"
item.Value = "2"
items(1) = item
cb.ListItems = items
cb.AllowWrap = True
cb.ShowEllipsis = False
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = cb
FpSpread1.ActiveSheetView.Cells(0, 0).Value = "1"

Dim btest As New FarPoint.Web.Spread.ButtonCellType
btest.ButtonType = FarPoint.Web.Spread.ButtonType.LinkButton
btest.AllowWrap = False
btest.ShowEllipsis = True
btest.Text = "this is a test of allow wrap"
FpSpread1.Sheets(0).Cells(0, 1).CellType = btest

Dim linkURL As String = "http://www.FarPointSpread.com"
Dim linkTarget As String = "_blank"
Dim linkcell As New FarPoint.Web.Spread.HyperLinkCellType()
linkcell.NavigateUrl = linkURL
linkcell.Target = linkTarget
linkcell.AllowWrap = False
linkcell.ShowEllipsis = True
FpSpread1.Sheets(0).Cells(1, 1).CellType = linkcell

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

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