Spread for ASP.NET 11 Product Documentation
AllowWrap Property (LabelCellType)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > LabelCellType Class : AllowWrap Property
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 LabelCellType
Dim value As Boolean
 
instance.AllowWrap = value
 
value = instance.AllowWrap
public bool AllowWrap {get; set;}

Property Value

Boolean: true to allow wrapping to multiple lines; false otherwise
Remarks

When this property is set to true, text is wrapped when it is wider that the width of the cell. When this property is set to false, text that is wider than the cell is not displayed in the cell.

Wrapping only occurs on word breaks.

Example
This example creates a LabelCellType object, allows its text to wrap if long enough and sets up the formatting for the text. It is assigned to the first cell in the sheet.
FarPoint.Web.Spread.LabelCellType lblcell=new FarPoint.Web.Spread.LabelCellType();
lblcell.AllowWrap=true;
int i=100;
string fstring=i.ToString("C");
lblcell.FormatString=fstring;
FpSpread1.ActiveSheetView.Cells[0,0].CellType=lblcell;
FpSpread1.ActiveSheetView.Cells[0,0].Text=fstring;
Dim lblcell As New FarPoint.Web.Spread.LabelCellType()
lblcell.AllowWrap=True
Dim i As Integer=100
Dim fstring As String=i.ToString("C")
lblcell.FormatString=fstring
FpSpread1.ActiveSheetView.Cells(0,0).CellType=lblcell
FpSpread1.ActiveSheetView.Cells(0,0).Text=fstring
See Also

Reference

LabelCellType Class
LabelCellType Members