Excel Client:DrillElement: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
← Older edit
VisualWikitext
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
==DrillElement(DimensionName, ElementName, OnAxe, Open)==
==[[Excel_Client:Functions_(Formulas)|Function]]==
 
<span {{CoPFormel}}>DrillElement(DimensionName, ElementName, OnAxe, Open)</span>


This [[Excel_Client:Functions_(Formulas)|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===
{| class="wikitable" width={{{breite|80%}}}
 
|- {{Tabellentitel}}
{| class="wikitable" width={{{breite|50%}}}
| width="150px"|Parameter
| Description
|-
|-
|width="200pt" style=background-color:#f6f6f6 |'''DimensionName''' 
|DimensionName  
|The name of the dimension.
|The name of the dimension.
|-
|-
|style=background-color:#f6f6f6 |'''ElementName'''
|ElementName
|The element that must be opened or closed.
|The element that must be opened or closed.
|-
|-
|style=background-color:#f6f6f6 |'''OnAxe'''
|OnAxe
|The axis on which the element is located (distinction between open/close, down/up, left/right).  
|The axis on which the element is located (distinction between open/close, down/up, left/right).  
:*RowDim - Open/close is executed downward/upward (on the line level).
:*ColDim - Open/close is executed to the left/right (on the column level).
|-
|-
|style=background-color:#f6f6f6 |'''Open'''
|Open
|Indicates whether the element is opened or closed.  
|Indicates whether the element is opened or closed.
|}
:*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.
 
 
OnAxe can contain only two text values:
 
{| class="wikitable" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''RowDim''' 
|Open/close is executed downward/upward (on the line level).
|-
|style=background-color:#f6f6f6 |'''ColDim'''
|Open/close is executed to the left/right (on the column level).
|}
 
 
Open can contain only two text values:
 
{| class="wikitable" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''Open''' 
|The element is opened and will be closed at the next double-click.
|-
|style=background-color:#f6f6f6 |'''Close'''
|The element is closed and will be opened at the next double-click.  
|}
 
 
===Example ===
 
{| class="wikitable" width={{{breite|50%}}}
|- {{Tabellentitel}}
|width="200pt" Function
|-
|DrillElement(„Produkte“;“Rennräder“;“RowDim“;“Close“)
|}
|}


==Example ==
<span {{CoPFormel}}>DrillElement("Produkte";"Rennräder";"RowDim";"Close")</span>


__NOEDITSECTION__
__NOEDITSECTION__
[[Category:Excel_Client_Formulas|DrillElement]]
[[Category:Excel_Client_Formulas|DrillElement]]
[[de:Excel_Client:DrillElement]]
[[de:Excel_Client:DrillElement]]

Latest revision as of 14:57, 15 April 2014

Function

DrillElement(DimensionName, ElementName, OnAxe, Open)

This function allows the dimension to be opened or closed by double-clicking on the cell.

Parameter Description
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).
  • 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 Indicates whether the element is opened or closed.
  • 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

DrillElement("Produkte";"Rennräder";"RowDim";"Close")

Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Excel_Client:DrillElement&oldid=14791"