|
|
|
|
<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. 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|