Spread Windows Forms 11.0 Product Documentation
Allowing Cell Data to Overflow
Spread Windows Forms 11.0 Product Documentation > Developer's Guide > Customizing Row, Column, and Cell Appearance > Customizing the Appearance of a Cell > Allowing Cell Data to Overflow

You can determine how the contents of a cell or a group of cells overflow into adjoining cells. If you allow cell contents to overflow:

An example of each of these is shown in the following figure.

Cell Overflow Examples

To set the overflow behavior, use the following members for the overall component (FpSpread class) or the child sheet (SpreadView class):

You can specify the amount of content that will overflow into adjacent cells by specifying the number of pixels of overflow allowed using the SetMaximumCellOverflowWidth method.

For more information on cell contents alignment, refer to Aligning Cell Contents.

Using the Properties Window

  1. At design time, in the Properties window, select the Spread component.
  2. Select (in the Behavior category) the AllowCellOverflow property or the AllowEditOverflow property.
  3. Select True from the drop-down list to allow cells to overflow, or select False to prohibit cells from overflowing.

Using a Shortcut

  1. Allow the contents of a set of cells to overflow by setting the AllowCellOverflow property.
  2. Specify the maximum amount of content allowed to overflow by calling the SetMaximumCellOverflowWidth method to specify the number of pixels allowed to overflow.

Example

This example code sets the component to allow cells to overflow but only up to the maximum of 130 pixels.

C#
Copy Code
fpSpread1.AllowCellOverflow = true;
fpSpread1.SetMaximumCellOverflowWidth(130);
VB
Copy Code
fpSpread1.AllowCellOverflow = True
fpSpread1.SetMaximumCellOverflowWidth(130)

Using Code

  1. Allow the contents of a set of cells to overflow by setting the FpSpread AllowCellOverflow property.
  2. Specify the maximum amount of content allowed to overflow by calling the SetMaximumCellOverflowWidth method to specify the number of pixels allowed to overflow.

Example

This example code sets the child sheet to allow cells to overflow up to a maximum width of 130.

C#
Copy Code
FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.AllowCellOverflow = true;
sv.SetMaximumCellOverflowWidth(130);
VB
Copy Code
Dim sv As FarPoint.Win.Spread.SpreadView = fpSpread1.GetRootWorkbook
sv.AllowCellOverflow = True
sv.SetMaximumCellOverflowWidth(130)

Using the Spread Designer

  1. Select the Spread component (or select Spread from the pull-down menu).
  2. In the property list for the component, in the Behavior category, select the AllowCellOverflow property or the AllowEditOverflow and select the value True.
  3. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.