Page tree

Versions Compared

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.4
8.4
Description

Excerpt

The ShowValueAsType class contains the Excel value field show value as types supported by ExcelWriter.

Signature
C#
C#
 public sealed class ShowValueAsType
Signature
vb.net
vb.net
Public NotInheritable Class ShowValueAsType
Remarks

Values labels will return ShowValueAsType.Normal. You can check if a PivotField is values label with the IsValuesLabel Property

Values

Name

Description

Anchor
Normal
Normal
Normal

Indicates that the field is shown as its normal data
type.

Anchor
Difference
Difference
Difference

Indicates the field is shown as the "difference from" a
value.

Anchor
Percent
Percent
Percent

Indicates the field is show as the "percentage of"

Anchor
PercentDiff
PercentDiff
PercentDiff

Indicates the field is shown as the "percentage
difference from" a value.

Anchor
RunningTotal
RunningTotal
RunningTotal

Indicates the field is shown as running total in the
table.

Anchor
PercentRow
PercentRow
PercentRow

Indicates the field is shown as the percentage of row

Anchor
PercentColumn
PercentColumn
PercentColumn

Indicates the field is shown as the percentage of
column.

Anchor
PercentTotal
PercentTotal
PercentTotal

Indicates the field is shown as percentage of total.

Anchor
Index
Index
Index

Indicates the field is shown as the index.