Create Method (AutoSumCommand)

In This Topic

Creates the AutoSumCommand command from current selections of the specified worksheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function Create( _
   ByVal worksheet As IWorksheet, _
   Optional ByVal function As BuiltinFunction, _
   Optional ByVal shouldUseSubtotalFunction As Boolean _
) As AutoSumCommand

'Usage
 
Dim worksheet As IWorksheet
Dim function As BuiltinFunction
Dim shouldUseSubtotalFunction As Boolean
Dim value As AutoSumCommand
 
value = AutoSumCommand.Create(worksheet, function, shouldUseSubtotalFunction)

public static AutoSumCommand Create( 
   IWorksheet worksheet,
   BuiltinFunction function,
   bool shouldUseSubtotalFunction
)

Parameters

worksheet: The worksheet to add cells automatically.
function: The function to calculate total of cells.
shouldUseSubtotalFunction: true to generate SUBTOTAL formula; otherwise, false.

Reference

AutoSumCommand Class
AutoSumCommand Members