Excel Client:DrillElement: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
Created page with '==DrillElement(DimensionName, ElementName, OnAxe, Open)== This function allows the dimension to be opened or closed by double-clicking on the cell. ===Parameter=== {| style=c…' |
No edit summary |
||
| Line 1: | Line 1: | ||
==DrillElement(DimensionName, ElementName, OnAxe, Open)== | ==DrillElement(DimensionName, ElementName, OnAxe, Open)== | ||
This function allows the dimension to be opened or closed by double-clicking on the cell. | This [[Excel_Client:Functions_(Formulas)|function]] allows the dimension to be opened or closed by double-clicking on the cell. | ||
===Parameter=== | ===Parameter=== | ||
Revision as of 08:17, 7 May 2010
DrillElement(DimensionName, ElementName, OnAxe, Open)
This function allows the dimension to be opened or closed by double-clicking on the cell.
Parameter
| DimensionName | The name of the dimension. |
| ElementName | The element that must be opened or closed. |
| OnAxe | The axis on which the element is located (distinction between open/close, down/up, left/right). |
| Open | Indicates whether the element is opened or closed. |
OnAxe can contain only two text values:
| RowDim | Open/close is executed downward/upward (on the line level). |
| ColDim | Open/close is executed to the left/right (on the column level). |
Open can contain only two text values:
| Open | The element is opened and will be closed at the next double-click. |
| Close | The element is closed and will be opened at the next double-click. |
Example
| Function |
| DrillElement(„Produkte“;“Rennräder“;“RowDim“;“Close“) |
