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:

• Left-aligned text in a cell overflows to the adjacent right cell.
• Right-aligned text in a cell overflows to the adjacent left cell.
• Centered text in a cell overflows to both the left and right adjacent cells.

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

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

• AllowCellOverflow
• GetMaximumCellOverflowWidth
• SetMaximumCellOverflowWidth
• AllowEditOverflow

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.

fpSpread1.AllowCellOverflow = true;
fpSpread1.SetMaximumCellOverflowWidth(130);

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.

FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();sv.AllowCellOverflow = true;
sv.SetMaximumCellOverflowWidth(130);

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.