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


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
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FpSpread Class
FpSpread Members
AllowEditOverflow Property

User-Task Documentation

Allowing Cell Data to Overflow

 

 


Copyright © GrapeCity, inc. All rights reserved.