Excel Client:Ribbon - Revision history

Admin at 15:33, 15 April 2015

2015-04-15T15:33:09Z

← Older revision		Revision as of 17:33, 15 April 2015
Line 111:		Line 111:
	\|The CoPlanner Excel Client Info dialog provides information about the product. Furthermore, the current connection settings can be read from the CoPlanner server.		\|The CoPlanner Excel Client Info dialog provides information about the product. Furthermore, the current connection settings can be read from the CoPlanner server.
	\|}		\|}




	__NOEDITSECTION__		__NOEDITSECTION__
	[[Kategorie:Excel_Client\|Ribbon]]		[[Kategorie:Excel_Client\|Ribbon]]
	[[de:~~Excel Client 2~~.0:Ribbon]]		[[de:Excel_Client_2.0:Ribbon]]

Admin at 15:32, 15 April 2015

2015-04-15T15:32:24Z

← Older revision		Revision as of 17:32, 15 April 2015
Line 110:		Line 110:
	\|'''Info'''		\|'''Info'''
	\|The CoPlanner Excel Client Info dialog provides information about the product. Furthermore, the current connection settings can be read from the CoPlanner server.		\|The CoPlanner Excel Client Info dialog provides information about the product. Furthermore, the current connection settings can be read from the CoPlanner server.
			\|}

	__NOEDITSECTION__		__NOEDITSECTION__
	[[Kategorie:Excel_Client\|Ribbon]]		[[Kategorie:Excel_Client\|Ribbon]]
	[[de:Excel Client 2.0:Ribbon]]		[[de:Excel Client 2.0:Ribbon]]

Admin at 15:31, 15 April 2015

2015-04-15T15:31:26Z

← Older revision		Revision as of 17:31, 15 April 2015
Line 113:		Line 113:
	__NOEDITSECTION__		__NOEDITSECTION__
	[[Kategorie:Excel_Client\|Ribbon]]		[[Kategorie:Excel_Client\|Ribbon]]
	[[de:~~Excel_Client_2~~.0:Ribbon]]		[[de:Excel Client 2.0:Ribbon]]

Admin at 15:30, 15 April 2015

2015-04-15T15:30:28Z

← Older revision		Revision as of 17:30, 15 April 2015
Line 71:		Line 71:
	\|-		\|-
	\|[[Image:FxZauber32.png]]		\|[[Image:FxZauber32.png]]
	\|'''~~Formelassistent~~'''		\|'''Formula assistent'''
	\|~~Der~~ CoPlanner [[~~Excel_Client_2~~.0:~~Formelassistent~~\|~~Formelassistent~~]] ~~unterstützt den Benutzer bei der Erstellung einer vom~~ Excel~~-Client bereitgestellten~~ [[~~Excel_Client_2.0~~:~~Excel-Client_Funktionen~~\|Excel~~-Client Funktionen~~]].		\|The CoPlanner [[Excel Client 2.0:Formula assistent\|formula assistant]] supports the user in creating a structure in the Excel client offering [[Excel Client:Functions (Formulas)\| Excel client functions]].
	\|-		\|-
	\|[[Image:FxRadierer32.png]]		\|[[Image:FxRadierer32.png]]
	\|'''~~Formeln entfernen~~'''		\|'''Delete formulas'''
	\|~~Durch diese Funktion können entweder alle~~ CoPlanner ~~spezifischen Formeln oder alle~~ Excel ~~Formeln aus der aktuellen Arbeitsmappe entfernt werden~~.		\|With this function either all CoPlanner specific formulas or all Excel formulas can be removed from the current workbook.

	~~Wählen Sie die Option „nur~~ CoPlanner ~~Formeln“, wenn nur diese bzw. Formeln, welche~~ CoPlanner ~~Funktionen beinhalten entfernt werden sollen~~.		Select the option "only CoPlanner formulas" if only this or formulas that include CoPlanner functions should be removed.
	~~Wählen Sie die Option „alle~~ Excel ~~Formeln“, wenn alle~~ Excel ~~Formeln aus dem Arbeitsblatt entfernt werden sollen~~.		Select the option "All Excel formulas" when all Excel formulas should be removed from the worksheet.
	\|-		\|-
	\|[[Image:Seriendruck.png]]		\|[[Image:Seriendruck.png]]
	\|'''~~Seriendruck~~'''		\|'''Mail merge'''
	\|~~Durch die Auswahl des Menüpunktes~~ [[~~Excel_Client_2~~.0:~~Seriendruck~~\|~~Seriendruck~~]], ~~wird der Assistent für die Seriendruckerstellung gestartet~~.		\|By selecting the menu item [[Excel Client 2.0:Merge\|merge]], the wizard for the mail merge will be started.
	\|-{{Tabellentitel}}		\|-{{Tabellentitel}}
	\|Layout		\|Layout
Line 91:		Line 91:
	\|[[Image:EC_AutoSize32.png]]		\|[[Image:EC_AutoSize32.png]]
	\|'''Autosize'''		\|'''Autosize'''
	\|~~Hiermit werden alle Spaltenbreiten entsprechend der aktuellen Inhalt optimal angepasst~~.		\|All column widths will be adjusted optimally to the actual content.
	~~Die Schaltfläche ist nur sichtbar, wenn~~ "~~Spaltenbreite automatisch anpassen~~" ~~unter~~ [[~~Excel_Client_2.0~~:~~Optionen~~\|~~Optionen~~]] ~~deaktiviert ist~~.		The button is only visible if "Automatically adjust column width" in [[Excel_Client:Options\|Options]] is disabled.
	\|-		\|-
	\|[[Image:Styling2.png]]		\|[[Image:Styling2.png]]
	\|'''~~Formatvorlagen~~'''		\|'''Style sheets'''
	\|~~Hier können verschiedene Formatvorlagen auf den Bericht angewendet werden~~.		\|Here, different styles can be applied to the report.
	~~Formatvorlagen können nur auf Berichte mit Analysedaten angewendet werden~~.		Styles can only be applied to reports with analysis data.
	\|-{{Tabellentitel}}		\|-{{Tabellentitel}}
	\|~~Hilfe~~		\|Help
	\|		\|
	\|		\|
Line 105:		Line 105:
	\|[[Image:CoPPortal32.png]]		\|[[Image:CoPPortal32.png]]
	\|'''Portal'''		\|'''Portal'''
	\|~~Hier gelangen Sie zum~~ CoPlanner~~-Portal, wo Sie Informationen und Hilfestellungen zu den~~ CoPlanner~~-Produkten finden~~.		\|Click here for the CoPlanner portal where you can find information and assistance to the CoPlanner products.
	\|-		\|-
	\|[[Image:Hilfe32.png]]		\|[[Image:Hilfe32.png]]
	\|'''Info'''		\|'''Info'''
	\|~~Der~~ CoPlanner Excel Client Info ~~Dialog beinhaltet Informationen zum Produkt~~. ~~Des Weiteren können aus diesem die aktuellen Verbindungseinstellungen zum~~ CoPlanner ~~Server abgelesen werden~~.		\|The CoPlanner Excel Client Info dialog provides information about the product. Furthermore, the current connection settings can be read from the CoPlanner server.
	\|}

	__NOEDITSECTION__		__NOEDITSECTION__
	[[Kategorie:~~Excel_Client_2.0~~\|Ribbon]]		[[Kategorie:Excel_Client\|Ribbon]]
	[[en:Excel_Client_2.0:Ribbon]]		[[de:Excel_Client_2.0:Ribbon]]

Admin at 15:19, 15 April 2015

2015-04-15T15:19:00Z

← Older revision		Revision as of 17:19, 15 April 2015
Line 63:		Line 63:
	\|[[Image:FilterCo32.png]]		\|[[Image:FilterCo32.png]]
	\|'''Filter'''		\|'''Filter'''
	\|Use this button to open the dialogue for the [[~~Excel Client~~:Filter Management\|filter administration]].		\|Use this button to open the dialogue for the [[Excel_Client_2.0:Filter Management\|filter administration]].
	Here you can define, change settings or delete filter for the current reporting solution.		Here you can define, change settings or delete filter for the current reporting solution.
	\|-{{Tabellentitel}}		\|-{{Tabellentitel}}

Admin: Created page with "==Ribbon== The Ribbon in the upper range includes individual menu items to use the CoPlanner Excel client. The ribbon is divided into the following groups: :* Server :* Data ..."

2015-04-15T15:17:55Z

Created page with "==Ribbon== The Ribbon in the upper range includes individual menu items to use the CoPlanner Excel client. The ribbon is divided into the following groups: :* Server :* Data ..."

New page

==Ribbon==
The Ribbon in the upper range includes individual menu items to use the CoPlanner Excel client.
The ribbon is divided into the following groups:
:* Server
:* Data
:* Options
:* Layout
:* Help

[[Image:Excel2.0_Menue.jpg|thumb|center|Excel Client, Ribbon]]

These groups are assigned to individual menu items that are needed to work with the Excel client.

==Menu items at the CoPlanner Ribbon==

Below is a list of all the available menu items:

{| class="wikitable" width={{{breite|100%}}}
|- {{Tabellentitel}}
|width="50pt" |Button
|width="200pt" |Menu item
|Beschreibung
|-{{Tabellentitel}}
|Server
|
|
|-
|[[Image:Excel2.0_LogIn.png]] / [[Image:Excel2.0_LogOut.png]]
| '''Login''' / '''Logout'''
|

Like the Windows client the Excel client must be connected to the CoPlanner server. If the [[Excel_Client2.0:Login_Dialogue|Login Dialogue]] does not appear automatically, select the menu item ''[[Excel_Client:Overview#Register|Login]]''.
After you have successfully logged in, the menu item '' Login '' will change to the menu item ''[[Excel_Client_2.0:Overview#Logout|Logout]]''
When this option is selected, the connection will be separated from the CoPlanner server.
|-
|[[Image:Optionen_grau32.png]]
|'''Options'''
|Via Options you get access to the [[Excel Client:Options|Configuration options]] for the CoPlanner Excel Addin.
In this dialogue you can define/change settings for logon/logout, data updating, capture, representation and use of a [[Excel_Client:Template|CoPlanner templates]] for Excel Addin.
|-
|[[Image:Verbindung_grau_türkis32.png]]
|'''Connection'''
|Here you can define/change your [[Excel_Client_2.0:Connection|connection settings]] for the CoPlanner Server
|-
|[[Image:User.png]] / [[Image:PowerUser.png]]
|'''User- / PowerUser-Mode'''
|In the user mode you will have access to your own and shared reports in the Analyzer. in the power user mode you have additional access to the data sources.
|-{{Tabellentitel}}
|Data
|
|
|-
|[[Image:EC_Aktualisieren.png]]
|'''Refresh'''
|Here you can recalculate the data of the workbook.
The button is only visible if "Automatically Calculate" under [[Client_Excel:Options|options]] is disabled.
|-
|[[Image:Analyser32.png]]
|'''Analyzer'''
|The [[Excel Client:Analyzer|Analyzer]] represents the wizard which is used to define/composition of the desired data.
Here you have the possibility of [[Excel_Client:create a report|createing a report]].
|-
|[[Image:FilterCo32.png]]
|'''Filter'''
|Use this button to open the dialogue for the [[Excel Client:Filter Management|filter administration]].
Here you can define, change settings or delete filter for the current reporting solution.
|-{{Tabellentitel}}
|Options
|
|
|-
|[[Image:FxZauber32.png]]
|'''Formelassistent'''
|Der CoPlanner [[Excel_Client_2.0:Formelassistent|Formelassistent]] unterstützt den Benutzer bei der Erstellung einer vom Excel-Client bereitgestellten [[Excel_Client_2.0:Excel-Client_Funktionen|Excel-Client Funktionen]].
|-
|[[Image:FxRadierer32.png]]
|'''Formeln entfernen'''
|Durch diese Funktion können entweder alle CoPlanner spezifischen Formeln oder alle Excel Formeln aus der aktuellen Arbeitsmappe entfernt werden.

Wählen Sie die Option „nur CoPlanner Formeln“, wenn nur diese bzw. Formeln, welche CoPlanner Funktionen beinhalten entfernt werden sollen.
Wählen Sie die Option „alle Excel Formeln“, wenn alle Excel Formeln aus dem Arbeitsblatt entfernt werden sollen.
|-
|[[Image:Seriendruck.png]]
|'''Seriendruck'''
|Durch die Auswahl des Menüpunktes [[Excel_Client_2.0:Seriendruck|Seriendruck]], wird der Assistent für die Seriendruckerstellung gestartet.
|-{{Tabellentitel}}
|Layout
|
|
|-
|[[Image:EC_AutoSize32.png]]
|'''Autosize'''
|Hiermit werden alle Spaltenbreiten entsprechend der aktuellen Inhalt optimal angepasst.
Die Schaltfläche ist nur sichtbar, wenn "Spaltenbreite automatisch anpassen" unter [[Excel_Client_2.0:Optionen|Optionen]] deaktiviert ist.
|-
|[[Image:Styling2.png]]
|'''Formatvorlagen'''
|Hier können verschiedene Formatvorlagen auf den Bericht angewendet werden.
Formatvorlagen können nur auf Berichte mit Analysedaten angewendet werden.
|-{{Tabellentitel}}
|Hilfe
|
|
|-
|[[Image:CoPPortal32.png]]
|'''Portal'''
|Hier gelangen Sie zum CoPlanner-Portal, wo Sie Informationen und Hilfestellungen zu den CoPlanner-Produkten finden.
|-
|[[Image:Hilfe32.png]]
|'''Info'''
|Der CoPlanner Excel Client Info Dialog beinhaltet Informationen zum Produkt. Des Weiteren können aus diesem die aktuellen Verbindungseinstellungen zum CoPlanner Server abgelesen werden.
|}

__NOEDITSECTION__
[[Kategorie:Excel_Client_2.0|Ribbon]]
[[en:Excel_Client_2.0:Ribbon]]