Spread Windows Forms 11.0 Product Documentation
AllowCellOverflow Property (FpSpread)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : AllowCellOverflow Property
Gets or sets whether data can overflow into adjacent empty cells in the component.
Syntax
'Declaration
 
Public Property AllowCellOverflow As Boolean
'Usage
 
Dim instance As FpSpread
Dim value As Boolean
 
instance.AllowCellOverflow = value
 
value = instance.AllowCellOverflow
public bool AllowCellOverflow {get; set;}

Property Value

Boolean: true to allow data to overflow into adjacent empty cells in the Spread component; false otherwise

Remarks

This property determines whether the display of the data can overflow into adjacent empty cells if the contents go beyond the width of the cell.

When this property is set to true, the following occurs:

This only occurs for empty cells. If the adjacent cell had data, only the contents within the limits of that cell are displayed.

Example
This example specifies if text is allowed to overflow to adjacent empty cells.
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
fpSpread1.AllowCellOverflow = true;
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
fpSpread1.AllowCellOverflow = True
See Also

Reference

FpSpread Class
FpSpread Members
AllowEditOverflow Property

User-Task Documentation

Allowing Cell Data to Overflow