Spread for ASP.NET 8.0 Product Documentation
AllowWrap Property (ButtonCellType)
Example 


Gets or sets whether the cell allows text to wrap to multiple lines. Wrapping only occurs on word breaks.
Syntax
'Declaration
 
Public Property AllowWrap As Boolean
'Usage
 
Dim instance As ButtonCellType
Dim value As Boolean
 
instance.AllowWrap = value
 
value = instance.AllowWrap
public bool AllowWrap {get; set;}
Remarks
The AllowWrap property requires that the ButtonType property be set to link button.
Example
This example sets the AllowWrap property.
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;
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

Reference

ButtonCellType Class
ButtonCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.