ComponentOne FlexPivot for WinForms
C1.Win.C1FlexGrid.4.8 Assembly / C1.Win.C1FlexGrid Namespace / C1FlexGrid Class / BeforeSubtotal Event

In This Topic
    BeforeSubtotal Event (C1FlexGrid)
    In This Topic
    Fires before each subtotal row is added to the grid.
    Syntax
    'Declaration
     
    Public Event BeforeSubtotal As SubtotalEventHandler
    public event SubtotalEventHandler BeforeSubtotal
    Event Data

    The event handler receives an argument of type SubtotalEventArgs containing data related to this event. The following SubtotalEventArgs properties provide information specific to this event.

    PropertyDescription
    Gets or sets the calculated aggregate value for the group.  
    Gets the index of the bottom row in the group.  
    Whether to cancel the creation of the new subtotal row.  
    Gets or sets the text to insert in the new subtotal row.  
    Gets the AggregateEnum value that specifies the type of aggregate to calculate..  
    Gets the index of the first column in the range used to detect group breaks.  
    Gets the index of the last column in the range used to detect group breaks.  
    Gets a value that determines whether the subtotal row is a new row or the subtotal is being added to an existing subtotal row.  
    Outline level to assign to the new subtotal rows.  
    Gets the index of the new subtotal row.  
    Gets or sets the CellStyle to be applied to the new subotal row.  
    Gets the index of the top row in the group.  
    Gets the index of the column that contains values being aggregated.  
    Remarks

    Subtotal rows are added when the C1.Win.C1FlexGrid.C1FlexGridBase.Subtotal(C1.Win.C1FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.C1FlexGrid.AggregateFlags,C1.Win.C1FlexGrid.RowColFlags) method is invoked.

    The event handler may prevent the grid from adding a particular row, or it may customize the caption, style, and aggregate value used in the new subtotal row.

    See Also