Share via


PivotField.StandardFormula Property

Returns or sets a String specifying formulas with standard English (United States) formatting. Read/write.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property StandardFormula As String
    Get
    Set
'Usage
Dim instance As PivotField
Dim value As String

value = instance.StandardFormula

instance.StandardFormula = value
string StandardFormula { get; set; }

Property Value

Type: System.String

Remarks

The StandardFormula property primarily affects item names with date or number formatting. It provides a way to specify or query a formula for a given calculated item.

The StandardFormula property is "international-friendly," whereas the Formula property is not.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace