Spread Windows Forms 8.0 Product Documentation
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 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):

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

Allow the contents of a set of cells to overflow by setting the AllowCellOverflow property.

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

Allow the contents of a set of cells to overflow by setting the FpSpread AllowCellOverflow property.

Example

This example code sets the child sheet to allow cells to overflow. In code, you can additionally set the maximum overflow width to a particular value, such as 130 pixels in this example.

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.GetRootWorkbooksv.AllowCellOverflow = True
sv.SetMaximumCellOverflowWidth(130)

Using the Spread Designer

  1. Select the FarPoint 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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback