Excel Client:DrillElement: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 50: | Line 50: | ||
{| class="wikitable" width={{{breite|50%}}} | {| class="wikitable" width={{{breite|50%}}} | ||
|- {{Tabellentitel}} | |- {{Tabellentitel}} | ||
|width="200pt" Function | |width="200pt" |Function | ||
|- | |- | ||
|DrillElement(„Produkte“;“Rennräder“;“RowDim“;“Close“) | |DrillElement(„Produkte“;“Rennräder“;“RowDim“;“Close“) | ||
Revision as of 08:58, 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“) |
