Spread Windows Forms 12.0 Product Documentation
AllowCellOverflow Property (FpSpread)

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.
Public Property AllowCellOverflow As Boolean
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


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.

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;
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
fpSpread1.AllowCellOverflow = True
See Also


FpSpread Class
FpSpread Members
AllowEditOverflow Property

User-Task Documentation

Allowing Cell Data to Overflow