Difference between revisions of "XL3GridMember"

(Examples)
(Examples)
Line 38: Line 38:
  
  
Used in conjunction with [[Xl3Link]], the following formula copies the unique name from the row when the report user clicks on "...":
+
Used in conjunction with [[Xl3Link]], the following formula copies the unique name from the row when the report user clicks on "..." into the cell $A$14:
  
 
   =XL3Link(XL3Address($D$7),"...",,XL3Address($A$14),XL3GridMember(A7))
 
   =XL3Link(XL3Address($D$7),"...",,XL3Address($A$14),XL3GridMember(A7))

Revision as of 09:09, 4 July 2014

Returns the member uniquename for the specified grid cell. This can be useful for when you want to get the unique name of a particular member from a grid for passing as an XL3Link parameter - avoiding any issues with duplicate/translated captions etc.

Syntax

XL3GridMember( )

Parameters

The parameters can take one of two forms:

Parameter Description
Grid cell location Shows member uniquename for grid cell

or

Parameter Description
Grid name Name of the grid to get the member for
Axis 1 for Columns, 2 for Rows
Dimension Dimension on the axis to look at, 1-based.
Member Index Member index to look at, 1-based.

Examples

Used in conjunction with Xl3Link, the following formula copies the unique name from the row when the report user clicks on "..." into the cell $A$14:

  =XL3Link(XL3Address($D$7),"...",,XL3Address($A$14),XL3GridMember(A7))

XL3GridMember1.png

See Also