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.
Contents
[hide]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))