CalculatedFields.Add(String, String, Object) CalculatedFields.Add(String, String, Object) Method

Definition

Creates a new calculated field. Returns a PivotField object.

public Microsoft.Office.Interop.Excel.PivotField Add (string Name, string Formula, object UseStandardFormula);
Public Function Add (Name As String, Formula As String, Optional UseStandardFormula As Object) As PivotField
Parameters
Name
String String

Required String. The name of the field.

Formula
String String

Required String. The formula for the field.

UseStandardFormula
Object Object

Optional Object. False (default) for upward compatibility. True for strings contained in any arguments that are field names (will be interpreted as having been formatted in standard U.S. English instead of local settings).

Returns

Applies to