Gets or sets whether data can overflow into adjacent empty cells in the component.

Syntax

Visual Basic (Declaration)
Public Property AllowCellOverflow As Boolean

Visual Basic (Usage)	Copy Code
Dim instance As FpSpread Dim value As Boolean instance.AllowCellOverflow = value value = instance.AllowCellOverflow

C#
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:

Left-aligned data in a cell overflows to the adjacent right cell.
Right-aligned data in a cell overflows to the adjacent left cell.
When data is centered in a cell, data overflows to both the left and right adjacent cells.

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.

C#	Copy Code
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;

Copy Code

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;

Visual Basic	Copy Code
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

Visual Basic

Copy Code

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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Syntax

Property Value

Remarks

Example

Requirements

See Also

Reference

User-Task Documentation

Spread Windows Forms 6.0 Product Documentation
AllowCellOverflow Property
See Also Example Support Options