Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Introduced in build 8.3

Description

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

C#
vb.net

Values

Name

Description

Normal

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

Difference

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

Percent

Indicates the field is show as the "percentage of"

PercentDiff

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

RunningTotal

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

PercentRow

Indicates the field is shown as the percentage of row

PercentColumn

Indicates the field is shown as the percentage of\ column.

PercentTotal

Indicates the field is shown as percentage of total.

Index

Indicates the field is shown as the index.

Remarks

CalculatedFields will return ShowValueAsType.Normal. You can check if a PivotField is calculated field with the IsCacluatedField Property
  • No labels