Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
Office client development
Office 2007
Excel 2007
Excel 2007 Developer Reference
Excel Object Model Reference
PivotField Object
Properties
AllItemsVisible Property
Application Property
AutoShowCount Property
AutoShowField Property
AutoShowRange Property
AutoShowType Property
AutoSortCustomSubtotal Property
AutoSortField Property
AutoSortOrder Property
AutoSortPivotLine Property
BaseField Property
BaseItem Property
Calculation Property
Caption Property
ChildField Property
ChildItems Property
Creator Property
CubeField Property
CurrentPage Property
CurrentPageList Property
CurrentPageName Property
DatabaseSort Property
DataRange Property
DataType Property
DisplayAsCaption Property
DisplayAsTooltip Property
DisplayInReport Property
DragToColumn Property
DragToData Property
DragToHide Property
DragToPage Property
DragToRow Property
DrilledDown Property
EnableItemSelection Property
EnableMultiplePageItems Property
Formula Property
Function Property
GroupLevel Property
Hidden Property
HiddenItems Property
HiddenItemsList Property
IncludeNewItemsInFilter Property
IsCalculated Property
IsMemberProperty Property
LabelRange Property
LayoutBlankLine Property
LayoutCompactRow Property
LayoutForm Property
LayoutPageBreak Property
LayoutSubtotalLocation Property
MemberPropertyCaption Property
MemoryUsed Property
Name Property
NumberFormat Property
Orientation Property
Parent Property
ParentField Property
ParentItems Property
PivotFilters Property
Position Property
PropertyOrder Property
PropertyParentField Property
ServerBased Property
ShowAllItems Property
ShowDetail Property
ShowingInAxis Property
SourceCaption Property
SourceName Property
StandardFormula Property
SubtotalName Property
Subtotals Property
TotalLevels Property
UseMemberPropertyAsCaption Property
Value Property
VisibleItems Property
VisibleItemsList Property
Expand Minimize
This topic has not yet been rated - Rate this topic

PivotField.StandardFormula Property

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

Syntax

expression.StandardFormula

expression   A variable that represents a PivotField object.

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.

Example

This example adds 10 to the Decimals field and displays it as a calculated item in the data field. The example assumes that a PivotTable exists on the active worksheet and that a field titled "Decimals" exists in the data table.

Visual Basic for Applications
Sub UseStandardFomula()

    Dim pvtTable As PivotTable
    Set pvtTable = ActiveSheet.PivotTables(1)

    ' Change calculated field of decimals by adding '10'.
    pvtTable.CalculatedFields.Item(1).StandardFormula = "Decimals + 10"

End Sub

See Also


Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.