OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 27

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version Current

changes.mady.by.user Anonymous

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Introducedin
8.34
8.34
Description

Excerpt

The PivotTableField represents a single field in a Pivot Table.  This can be a row label, column label, data field (or value field) or a page field (or report filter).  To get a PivotTableField object, use a FieldCollection.

...

Properties

DisplayName

SortOptions

Name

Description

BaseField

Excerpt Include
EW8:PivotTableField.BaseFieldEW8:PivotTableField.BaseField
nopaneltrue

BaseItemIndex

Excerpt Include
EW8:PivotTableField.BaseItemIndexEW8:PivotTableField.BaseItemIndex
nopaneltrue

BaseItemNext

Excerpt Include
EW8:PivotTableField.BaseItemNextEW8:PivotTableField.BaseItemNext
nopaneltrue

BaseItemPrevious

Excerpt Include
EW8:PivotTableField.BaseItemPreviousEW8:PivotTableField.BaseItemPrevious
nopaneltrue
Excerpt Include
EW8:PivotTableField.DisplayNameEW8:
PivotTableField.DisplayName
nopaneltrue

DisplaySubtotalsAtTop

Excerpt Include
EW8:PivotTableField.DisplaySubtotalsAtTopEW8:
PivotTableField.DisplaySubtotalsAtTop
nopaneltrue

FieldType

Excerpt Include
EW8:PivotTableField.FieldTypeEW8:
PivotTableField.FieldType
nopaneltrue

IsCalculatedField IsValuesLabel

Excerpt Include
EW8:PivotTableField.IsCalculatedFieldIsValuesLabelEW8:
PivotTableField.IsCalculatedFieldIsValuesLabel
nopaneltrue

NumberFormat

Excerpt Include
EW8:PivotTableField.NumberFormatEW8:
PivotTableField.NumberFormat
nopaneltrue

Position ShowValueAs

Excerpt Include
EW8:PivotTableField.PositionEW8:PivotTableField.PositionShowValueAs
ShowValueAs
nopaneltrue

ShowValueAsType

Excerpt Include
EW8:PivotTableField.ShowValueAsTypeEW8:PivotTableField.ShowValueAsType
nopaneltrue
Excerpt Include
EW8:SortOptionsEW8:
SortOptions
nopaneltrue

SummarizeBy

Excerpt Include
EW8:PivotTableField.SummarizeByEW8:
PivotTableField.SummarizeBy
nopaneltrue

SummarizeByType

Excerpt Include
EW8:PivotTableField.SummarizeByTypeEW8:
PivotTableField.SummarizeByType
nopaneltrue

Source

Excerpt Include
EW8:PivotTableField.SourceEW8:
PivotTableField.Source
nopaneltrue
Methods

...

Name

...

Description

...

SetShowValueAs()

...