Page History

{introducedin: 8.4}{description}
{excerpt}The {{ShowValueAs}} class contains the options for showing the value of a DataField.  It is equivalent to the Show Values As tab in DataField settings in Excel.{excerpt}

{signature:C#}
public sealed class ShowValueAs
{signature}{signature:vb.net}
Public NotInheritable Class ShowValueAs
{signature}

{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open("template.xlsx");
          ShowValueAs options = wb[0].PivotTables[0].DataFields[0].ShowValueAs;
        {code}
{code:vbnet|title=vb.net}

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("template.xlsx")
          Dim options As ShowValueAs = wb(0).PivotTables(0).DataFields(0).ShowValueAs;
        {code}

{example}
{properties}
|| Name || Description ||
| [BaseField|ShowValueAs.BaseField] | {excerpt-include:ShowValueAs.BaseField|nopanel=true} |
| [BaseIndex|ShowValueAs.BaseIndex] | {excerpt-include:ShowValueAs.BaseIndex|nopanel=true} |
| [BaseItemNext|EW8:ShowValueAs.BaseItemNext] | {excerpt-include:ShowValueAs.BaseItemNext|nopanel=true} |
| [BaseItemPrevious|EW8:ShowValueAs.BaseItemPrevious] | {excerpt-include:ShowValueAs.BaseItemPrevious|nopanel=true} |
| [ShowValueAsType|ShowValueAs.ShowValueAsType] | {excerpt-include:ShowValueAs.ShowValueAsType|nopanel=true} |
| [ValueType|ShowValueAs.ValueType] | {excerpt-include:ShowValueAs.ValueType|nopanel=true} |

{methods}
|| Name || Description ||
| [SetShowValueAs()|EW8:ShowValueAs.SetShowValueAs (ShowValueAsType, SourceField, Int32)] | {excerpt-include:ShowValueAs.SetShowValueAs (ShowValueAsType, SourceField, Int32)|nopanel=true} |