Excel Client:DrillElement: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
===Parameter=== | ===Parameter=== | ||
{| | {| class="wikitable" width={{{breite|50%}}} | ||
|- | |- | ||
|width="200pt" style=background-color:#f6f6f6 |'''DimensionName''' | |width="200pt" style=background-color:#f6f6f6 |'''DimensionName''' | ||
| Line 24: | Line 24: | ||
OnAxe can contain only two text values: | OnAxe can contain only two text values: | ||
{| | {| class="wikitable" width={{{breite|50%}}} | ||
|- | |- | ||
|width="200pt" style=background-color:#f6f6f6 |'''RowDim''' | |width="200pt" style=background-color:#f6f6f6 |'''RowDim''' | ||
| Line 36: | Line 36: | ||
Open can contain only two text values: | Open can contain only two text values: | ||
{| | {| class="wikitable" width={{{breite|50%}}} | ||
|- | |- | ||
|width="200pt" style=background-color:#f6f6f6 |'''Open''' | |width="200pt" style=background-color:#f6f6f6 |'''Open''' | ||
| Line 48: | Line 48: | ||
===Example === | ===Example === | ||
{| | {| class="wikitable" width={{{breite|50%}}} | ||
|- | |- | ||
|width="200pt" style=background-color:#f6f6f6 |'''Function''' | |width="200pt" style=background-color:#f6f6f6 |'''Function''' | ||
Revision as of 08:57, 6 March 2012
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“) |
