Share via


PivotItem.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 PivotItem
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

PivotItem Interface

PivotItem Members

Microsoft.Office.Interop.Excel Namespace