<Pivot Table>.ExpandAll (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Pivot Table>.ExpandAll (Function)

In french: <Tableau croisé dynamique>.DérouleTout

Expands all row and/or column headers in a Pivot Table control.

Example

// Loads the data file
PVT_Statistics.Load(sFile)
// Expands all headers of the Pivot Table control
PVT_Statistics.ExpandAll()

Syntax

<Pivot Table control>.ExpandAll([<Type of header>])

<Pivot Table control>: Control name

Name of the Pivot Table control to be used. This Pivot Table control must have been populated using <Pivot table>.CalculateAll or <Pivot Table>.Load.

<Type of header>: Optional Integer constant (or combination of constants)

Type of the header to expand:
pvtColumnHeader Expands the headers of columns.
pvtRowHeader Expands the headers of rows.

If this parameter is not specified, the row headers AND the column headers are expanded.

Component: wd300obj.dll