Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Customizing Row or Column Interaction / Managing Outlines (Range Groups) of Rows and Columns / Customizing the Appearance of an Outline (Range Group)
In This Topic
    Customizing the Appearance of an Outline (Range Group)
    In This Topic

    You can customize the appearance of the outline (range group) using properties on the SheetView class or in an interface renderer.

    The two properties in the SheetView class that can be used to customize the appearance are:

    You can also use an EnhancedInterfaceRenderer to customize the appearance. The properties include:

    The line color also sets the color of the points in the outline. The following figure shows the results of the example code below where several of these properties are set.

    Outline Custom Appearance

    Notice that the outline background is different from the gray area of the spreadsheet.

    Using Code

    1. Create a new interface renderer to provide a custom look to outlines.
    2. Set the RangeGroupBackgroundColor to specify the color.
    3. Set the RangeGroupButtonBorderColor to specify the color for the button border.
    4. Set the RangeGroupLineColor to specify the group line color.
    5. Add the range groups with the AddRangeGroup method.

    Example

    This example creates an outline in the rows and in the columns and changes various colors. The result is shown in the preceding figure.

    C#
    Copy Code
    fpSpread1.ActiveSheet.Rows.Count = 11;
    fpSpread1.ActiveSheet.Columns.Count = 6;
    FarPoint.Win.Spread.EnhancedInterfaceRenderer outlinelook = new FarPoint.Win.Spread.EnhancedInterfaceRenderer();
    outlinelook.RangeGroupBackgroundColor = Color.LightGreen;
    outlinelook.RangeGroupButtonBorderColor = Color.Red;
    outlinelook.RangeGroupLineColor = Color.Blue;
    fpSpread1.InterfaceRenderer = outlinelook;
    fpSpread1.ActiveSheet.AddRangeGroup(0, 8, true);
    fpSpread1.ActiveSheet.AddRangeGroup(0, 5, true);
    fpSpread1.ActiveSheet.AddRangeGroup(1, 3, false);
    fpSpread1.ActiveSheet.AddRangeGroup(1, 2, false);
    
    VB
    Copy Code
    fpSpread1.ActiveSheet.Rows.Count = 11
    fpSpread1.ActiveSheet.Columns.Count = 6
    Dim outlinelook As New FarPoint.Win.Spread.EnhancedInterfaceRenderer
    outlinelook.RangeGroupBackgroundColor = Color.LightGreen
    outlinelook.RangeGroupButtonBorderColor = Color.Red
    outlinelook.RangeGroupLineColor = Color.Blue
    fpSpread1.InterfaceRenderer = outlinelook
    fpSpread1.ActiveSheet.AddRangeGroup(0, 8, True)
    fpSpread1.ActiveSheet.AddRangeGroup(0, 5, True)
    fpSpread1.ActiveSheet.AddRangeGroup(1, 3, False)
    fpSpread1.ActiveSheet.AddRangeGroup(1, 2, False)
    
    See Also