Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / RangeGroupSummaryRowBelow Property
Example


In This Topic
    RangeGroupSummaryRowBelow Property
    In This Topic
    Gets or sets whether the direction of the summary row is below the detail.
    Syntax
    'Declaration
     
    Public Property RangeGroupSummaryRowBelow As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim value As Boolean
     
    instance.RangeGroupSummaryRowBelow = value
     
    value = instance.RangeGroupSummaryRowBelow
    public bool RangeGroupSummaryRowBelow {get; set;}
    Example
    This example sets the RangeGroupSummaryColumnBelow property.
    fpSpread1.ActiveSheet.Rows.Count = 11;
    fpSpread1.ActiveSheet.Columns.Count = 6;
    fpSpread1.InterfaceRenderer = null;
    fpSpread1.ActiveSheet.RangeGroupBackgroundColor = Color.LightGreen;
    fpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced;
    fpSpread1.ActiveSheet.AddRangeGroup(0, 8, true);
    fpSpread1.ActiveSheet.AddRangeGroup(0, 5, true);
    fpSpread1.ActiveSheet.AddRangeGroup(1, 3, false);
    fpSpread1.ActiveSheet.AddRangeGroup(1, 2, false);
    fpSpread1.Sheets[0].RangeGroupSummaryRowBelow = true;
    fpSpread1.Sheets[0].RangeGroupSummaryColumnRight = true;
    FpSpread1.ActiveSheet.Rows.Count = 11
    FpSpread1.ActiveSheet.Columns.Count = 6
    FpSpread1.InterfaceRenderer = Nothing
    FpSpread1.ActiveSheet.RangeGroupBackgroundColor = Color.LightGreen
    FpSpread1.ActiveSheet.RangeGroupButtonStyle = FarPoint.Win.Spread.RangeGroupButtonStyle.Enhanced
    FpSpread1.ActiveSheet.AddRangeGroup(0, 8, True)
    FpSpread1.ActiveSheet.AddRangeGroup(0, 5, True)
    FpSpread1.ActiveSheet.AddRangeGroup(1, 3, False)
    FpSpread1.ActiveSheet.AddRangeGroup(1, 2, False)
    FpSpread1.Sheets(0).RangeGroupSummaryRowBelow = True
    FpSpread1.Sheets(0).RangeGroupSummaryColumnRight = True
    See Also