...
Introducedin | ||
---|---|---|
|
...
|
Description |
---|
Excerpt |
---|
The ShowValueAsType class contains the Excel value field show value as types supported by ExcelWriter. |
Signature | ||||
---|---|---|---|---|
| ||||
public sealed class ShowValueAsType{signature}{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public NotInheritable Class ShowValueAsType{signature}
{remarks}Values labels will return |
Remarks |
---|
Values labels will return ShowValueAsType.Normal. You can check if a PivotField is values label with the [ |EW8:PivotTableField.IsValuesLabel]Property {remarks} {values} || Name || Description || | {anchor:Normal}Normal | Indicates that the field is shown as its normal data \type. | | {anchor:Difference}Difference | Indicates the field is shown as the "difference from" a \value. | | {anchor:Percent}Percent | Indicates the field is show as the "percentage of" | | {anchor:PercentDiff} PercentDiff | Indicates the field is shown as the "percentage \difference from" a value. | | {anchor:RunningTotal}RunningTotal | Indicates the field is shown as running total in the \table. | | {anchor:PercentRow}PercentRow | Indicates the field is shown as the percentage of row | | {anchor:PercentColumn}PercentColumn | Indicates the field is shown as the percentage of \column. | | {anchor:PercentTotal}PercentTotal | Indicates the field is shown as percentage of total. | | {anchor:Index}Index | Indicates the field is shown as the index. |Property |
Values |
---|
Name | Description | ||||||
---|---|---|---|---|---|---|---|
| Indicates that the field is shown as its normal data | ||||||
| Indicates the field is shown as the "difference from" a | ||||||
| Indicates the field is show as the "percentage of" | ||||||
| Indicates the field is shown as the "percentage | ||||||
| Indicates the field is shown as running total in the | ||||||
| Indicates the field is shown as the percentage of row | ||||||
| Indicates the field is shown as the percentage of | ||||||
| Indicates the field is shown as percentage of total. | ||||||
| Indicates the field is shown as the index. |