Page History

Introducedin

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

Signature

	C#
	C#

 public sealed class ShowValueAs

...

Example

Code Block

	csharp
	csharp
title	C#


          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open("template.xlsx");
          SortOptionsShowValueAs 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 SortOptionsShowValueAs = wb(0).PivotTables(0).DataFields(0).ShowValueAs;

...

Name

Description

BaseField

Excerpt Include

	EW8:ShowValueAs.BaseFieldEW8:
	ShowValueAs.BaseField
nopanel	true

BaseIndex

Excerpt Include

	EW8:ShowValueAs.BaseIndexEW8:
	ShowValueAs.BaseIndex
nopanel	true

BaseItemNext

Excerpt Include

	EW8:ShowValueAs.BaseItemNextEW8:
	ShowValueAs.BaseItemNext
nopanel	true

BaseItemPrevious

Excerpt Include

	EW8:ShowValueAs.BaseItemPreviousEW8:
	ShowValueAs.BaseItemPrevious
nopanel	true

ShowValueAsType

Excerpt Include

	EW8:ShowValueAs.ShowValueAsTypeEW8:
	ShowValueAs.ShowValueAsType
nopanel	true

ValueType

Excerpt Include

	EW8:ShowValueAs.ValueTypeEW8:
	ShowValueAs.ValueType
nopanel	true

...

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 Current

Key