'Declaration
 
Public Function New( _
   ByVal function As AggregateEnum, _
   ByVal level As Integer, _
   ByVal groupFrom As Integer, _
   ByVal groupTo As Integer, _
   ByVal totalOn As Integer, _
   ByVal caption As String, _
   ByVal newRowIndex As Integer, _
   ByVal isNewRow As Boolean, _
   ByVal top As Integer, _
   ByVal bottom As Integer, _
   ByVal aggregateValue As Object, _
   ByVal style As CellStyle _
)

'Usage
 
Dim function As AggregateEnum
Dim level As Integer
Dim groupFrom As Integer
Dim groupTo As Integer
Dim totalOn As Integer
Dim caption As String
Dim newRowIndex As Integer
Dim isNewRow As Boolean
Dim top As Integer
Dim bottom As Integer
Dim aggregateValue As Object
Dim style As CellStyle
 
Dim instance As New SubtotalEventArgs(function, level, groupFrom, groupTo, totalOn, caption, newRowIndex, isNewRow, top, bottom, aggregateValue, style)

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:
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
)

Parameters

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.

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SubtotalEventArgs Class
SubtotalEventArgs Members