Page History

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.

Signature

	C#
	C#

 public sealed class ShowValueAs

Signature

	vb.net
	vb.net

Public NotInheritable Class ShowValueAs

Example

Code Block

	csharp
	csharp
title	C#


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open("template.xlsx");
          SortOptions options = wb[0].PivotTables[0].DataFields[0].ShowValueAs;

Code Block

	vbnet
	vbnet
title	vb.net


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

Properties

Name

Description

BaseField

Excerpt Include

	EW8:ShowValueAs.BaseField
	EW8:ShowValueAs.BaseField
nopanel	true

BaseIndex

Excerpt Include

	EW8:ShowValueAs.BaseIndex
	EW8:ShowValueAs.BaseIndex
nopanel	true

BaseItemNext

Excerpt Include

	EW8:ShowValueAs.BaseItemNext
	EW8:ShowValueAs.BaseItemNext
nopanel	true

BaseItemPrevious

Excerpt Include

	EW8:ShowValueAs.BaseItemPrevious
	EW8:ShowValueAs.BaseItemPrevious
nopanel	true

ShowValueAsType

Excerpt Include

	EW8:ShowValueAs.ShowValueAsType
	EW8:ShowValueAs.ShowValueAsType
nopanel	true

ValueType

Excerpt Include

	EW8:ShowValueAs.ValueType
	EW8:ShowValueAs.ValueType
nopanel	true

Methods

Name

Description

SetShowValueAs()

Excerpt Include

	EW8:ShowValueAs.SetShowValueAs (ShowValueAsType, SourceField, Int32)
	EW8:ShowValueAs.SetShowValueAs (ShowValueAsType, SourceField, Int32)
nopanel	true

Space Shortcuts

Page tree

Versions Compared

Old Version 4

New Version 5

Key