Initializes a new instance of a
SubtotalEventArgs object.
シンタックス
'宣言
Public Function New( _
ByVal As AggregateEnum, _
ByVal As System.Integer, _
ByVal As System.Integer, _
ByVal As System.Integer, _
ByVal As System.Integer, _
ByVal As System.String, _
ByVal As System.Integer, _
ByVal As System.Boolean, _
ByVal As System.Integer, _
ByVal As System.Integer, _
ByVal As System.Object, _
ByVal As CellStyle _
)
public SubtotalEventArgs(
AggregateEnum ,
System.int ,
System.int ,
System.int ,
System.int ,
System.string ,
System.int ,
System.bool ,
System.int ,
System.int ,
System.object ,
CellStyle
)
パラメータ
- function
- AggregateEnum value that specifies the type of aggregate to calculate.
- 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.
- groupFrom
- First column in the range used to detect group breaks.
- groupTo
- Last column in the range used to detect group breaks.
- totalOn
- Column that contains values being aggregated.
- caption
- Text to insert in the new subtotal row.
- newRowIndex
- Index of the new subtotal row.
- isNewRow
- Whether the subtotal row is a new row or the subtotal is being added to an existing subtotal row.
- top
- Index of the top row in the group.
- bottom
- Index of the bottom row in the group.
- aggregateValue
- Calculated aggregate value for the group.
- style
- CellStyle to be applied to the new subotal row.
参照