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

Subscription-exclusive new feature

This function is now available for WEBDEV websites in Windows and Linux.

Note: This feature is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 4.
For more details, see Using new features exclusive to the subscription-based version of WINDEV Suite 2025.

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 column headers.
pvtRowHeader Expands the row headers.

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

Component: wd300obj.dll