CalculatedFields.Add(String, String, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 PivotFieldParameters
- Name
- String
Required String. The name of the field.
- Formula
- String
Required String. The formula for the field.
- UseStandardFormula
- 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).