[]
Initializes a new instance of a SubtotalEventArgs object.
public SubtotalEventArgs(AggregateEnum function, int level, int groupFrom, int groupTo, int totalOn, string caption, int newRowIndex, bool isNewRow, int top, int bottom, object aggregateValue, CellStyle style)
Public Sub New([function] As AggregateEnum, level As Integer, groupFrom As Integer, groupTo As Integer, totalOn As Integer, caption As String, newRowIndex As Integer, isNewRow As Boolean, top As Integer, bottom As Integer, aggregateValue As Object, style As CellStyle)
| Type | Name | Description |
|---|---|---|
| AggregateEnum | function | AggregateEnum value that specifies the type of aggregate to calculate. |
| int | level | Outline level to assign to the new subtotal rows. This parameter allows the creation of multi-level subtotals and affects the display of the outline tree. |
| int | groupFrom | First column in the range used to detect group breaks. |
| int | groupTo | Last column in the range used to detect group breaks. |
| int | totalOn | Column that contains values being aggregated. |
| string | caption | Text to insert in the new subtotal row. |
| int | newRowIndex | Index of the new subtotal row. |
| bool | isNewRow | Whether the subtotal row is a new row or the subtotal is being added to an existing subtotal row. |
| int | top | Index of the top row in the group. |
| int | bottom | Index of the bottom row in the group. |
| object | aggregateValue | Calculated aggregate value for the group. |
| CellStyle | style | CellStyle to be applied to the new subotal row. |