<Pivot table>.InfoXY (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Pivot table>.InfoXY (Function)

In french: <Tableau croisé dynamique>.InfoXY

Returns the values of headers corresponding to a position in a Pivot Table control in pixels.

Example

pos is pvtPosition of PVT_Statistics
pos = PVT_Statistics.InfoXY(MouseXPos(), MouseYPos())
IF pos.Out = True THEN
STC_Caption = ""
ELSE
STC_Caption = "Year =" + pos.Year + ...
"Product = " + pos.Product + ...
"Sales = " + PVT_Statistics.VAL_Sales[pos]
END

Syntax

<Result> = <Pivot Table control>.InfoXY(<X> , <Y>)

<Result>: pvtPosition variable

pvtPosition variable containing the characteristics of the selected cell.
Remarks:
If the position does not correspond to any cell of the pivot table (-1,-1), the Out property of the pvtPosition variable is set to True.
The (0,0) position corresponds to the 1st cell at the top left.

<Pivot Table control>: Control name

Name of the Pivot Table control to be used.

<X>: Integer

X-coordinate (in pixels) to be analyzed. This coordinate is relative to the client area of the control.

<Y>: Integer

Y-coordinate (in pixels) to be analyzed. This coordinate is relative to the client area of the control.

Component: wd270obj.dll