Excel Client:DrillElement - Revision history

Admin at 12:57, 15 April 2014

2014-04-15T12:57:55Z

← Older revision		Revision as of 14:57, 15 April 2014
Line 28:		Line 28:

	==Example ==		==Example ==
	<span {{CoPFormel}}>DrillElement(~~„Produkte“~~;~~“Rennräder“~~;~~“RowDim“~~;~~“Close“~~)</span>		<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]]

Admin at 08:25, 24 May 2012

2012-05-24T08:25:06Z

← Older revision		Revision as of 10:25, 24 May 2012
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]]

Admin at 06:58, 6 March 2012

2012-03-06T06:58:12Z

← Older revision		Revision as of 08:58, 6 March 2012
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“)

Admin at 06:57, 6 March 2012

2012-03-06T06:57:56Z

← Older revision		Revision as of 08:57, 6 March 2012
Line 49:		Line 49:

	{\| class="wikitable" width={{{breite\|50%}}}		{\| class="wikitable" width={{{breite\|50%}}}
	\|-		\|- {{Tabellentitel}}
	\|width="200pt" ~~style=background-color:#f6f6f6 \|'''~~Function~~'''~~		\|width="200pt" Function
	\|-		\|-
	\|DrillElement(„Produkte“;“Rennräder“;“RowDim“;“Close“)		\|DrillElement(„Produkte“;“Rennräder“;“RowDim“;“Close“)

Admin at 06:57, 6 March 2012

2012-03-06T06:57:31Z

← Older revision		Revision as of 08:57, 6 March 2012
Line 5:		Line 5:
	===Parameter===		===Parameter===

	{\| ~~style=cellspacing="1" cellpadding="5" border~~="1" width={{{breite\|50%}}}		{\| 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:

	{\| ~~style=cellspacing="1" cellpadding="5" border~~="1" width={{{breite\|50%}}}		{\| 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:

	{\| ~~style=cellspacing="1" cellpadding="5" border~~="1" width={{{breite\|50%}}}		{\| 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 ===

	{\| ~~style=cellspacing="1" cellpadding="5" border~~="1" width={{{breite\|50%}}}		{\| class="wikitable" width={{{breite\|50%}}}
	\|-		\|-
	\|width="200pt" style=background-color:#f6f6f6 \|'''Function'''		\|width="200pt" style=background-color:#f6f6f6 \|'''Function'''

Admin at 06:17, 7 May 2010

2010-05-07T06:17:40Z

← Older revision		Revision as of 08:17, 7 May 2010
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===

Admin: 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…'

2010-05-07T05:55:07Z

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…'

New page

==DrillElement(DimensionName, ElementName, OnAxe, Open)==

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

===Parameter===

{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''DimensionName'''
|The name of the dimension.
|-
|style=background-color:#f6f6f6 |'''ElementName'''
|The element that must be opened or closed.
|-
|style=background-color:#f6f6f6 |'''OnAxe'''
|The axis on which the element is located (distinction between open/close, down/up, left/right).
|-
|style=background-color:#f6f6f6 |'''Open'''
|Indicates whether the element is opened or closed.
|}

OnAxe can contain only two text values:

{| style=cellspacing="1" cellpadding="5" border="1" 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:

{| style=cellspacing="1" cellpadding="5" border="1" 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 ===

{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''Function'''
|-
|DrillElement(„Produkte“;“Rennräder“;“RowDim“;“Close“)
|}

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