Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Spreadsheet Objects / Customizing Split Boxes
In This Topic
    Customizing Split Boxes
    In This Topic

    By default, the split boxes are shown and appear at the leading edge of each of the scroll bars, as shown in the figure below. When the end user clicks and drags the split box, the view is split into separate viewports. For more information on viewports, refer to Customizing Viewports.

    分割ボックスの表示

    You can customize the display and placement of the split boxes by using the following properties of the FpSpread class.

    Property Description
    ColumnSplitBoxAlignment property
    RowSplitBoxAlignment property
    Placement of split box relative to the scroll bar.Sets the value of SplitBoxAlignment enumeration.
    ColumnSplitBoxPolicy property
    RowSplitBoxPolicy property
    Whether or when to display the split box.Sets the value of SplitBoxPolicy enumeration.

    Sample Code

    In this example, the split box for the columns is at the leading edge of the scroll bar and is displayed as needed; for the rows, the split box is at the trailing edge of the scroll bar and is always displayed.

    C#
    Copy Code
    fpSpread1.ColumnSplitBoxAlignment = FarPoint.Win.Spread.SplitBoxAlignment.Leading;
    fpSpread1.RowSplitBoxAlignment = FarPoint.Win.Spread.SplitBoxAlignment.Trailing;
    fpSpread1.ColumnSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.AsNeeded;
    fpSpread1.RowSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.Always;
    
    Visual Basic
    Copy Code
    FpSpread1.ColumnSplitBoxAlignment = FarPoint.Win.Spread.SplitBoxAlignment.Leading
    FpSpread1.RowSplitBoxAlignment = FarPoint.Win.Spread.SplitBoxAlignment.Trailing
    FpSpread1.ColumnSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.AsNeeded
    FpSpread1.RowSplitBoxPolicy = FarPoint.Win.Spread.SplitBoxPolicy.Always
    

    Using the Spread Designer

    1. From the Settings menu, select SplitBox.
    2. In the Split Box tab, set the values for the ColumnSplitBoxAlignment, RowSplitBoxAlignment, ColumnSplitBoxPolicy, or RowSplitBoxPolicy property.
    3. Click OK.
    4. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.

    or

    1. Select the Spread component (or select Spread from the pull-down menu).
    2. In the property list for the component (in the Splitters category), select the ColumnSplitBoxAlignment, RowSplitBoxAlignment, ColumnSplitBoxPolicy, or RowSplitBoxPolicy property.
    3. Click the drop-down arrow to display the choices and select the value. Repeat this for each property.
    4. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.
    See Also