WebApps:Input Mask - Revision history

S.jakobi at 11:36, 1 July 2022

2022-07-01T11:36:04Z

← Older revision		Revision as of 12:36, 1 July 2022
Line 234:		Line 234:
	{{Hint\|Text=(available from CoP 10 HF 3.5) The usage of this letters can now also be combined with the cell functions that can be used through entering a "=" at the beginning of your edit in order to perform mathematical operations.}}		{{Hint\|Text=(available from CoP 10 HF 3.5) The usage of this letters can now also be combined with the cell functions that can be used through entering a "=" at the beginning of your edit in order to perform mathematical operations.}}

	Example: Current cell value: 1.000. Enter the following: =+5k then hit enter. Now it is calculated 1.000 + 5.000 and the result is written into the cell. (Hint: This is only possible when the "AllowCellFunctions" flag is set to yes in the input mask settings.)		Example: Current cell value: 1.000. Enter the following: =+5k then hit enter. Now it is calculated 1.000 + 5.000 and the result (6.000) is written into the cell. (Hint: This is only possible when the "AllowCellFunctions" flag is set to yes in the input mask settings.)

	==Implemented functions==		==Implemented functions==

S.jakobi: Added the possibility to use the letters like k,m,t in combination with the cell fucntions

2022-07-01T11:34:50Z

Added the possibility to use the letters like k,m,t in combination with the cell fucntions

← Older revision		Revision as of 12:34, 1 July 2022
Line 232:		Line 232:
	\|1.000		\|1.000
	\|}		\|}
	{{Hint}}		{{Hint\|Text=(available from CoP 10 HF 3.5) The usage of this letters can now also be combined with the cell functions that can be used through entering a "=" at the beginning of your edit in order to perform mathematical operations.}}
	Example: Current ~~Cell~~ value: 1.000. Enter the following: =+5k then hit enter. Now it is calculated 1.000+5.000 and the result is written into the cell. (Hint: This is only possible when the "AllowCellFunctions" flag is set to yes in the input mask settings.
			Example: Current cell value: 1.000. Enter the following: =+5k then hit enter. Now it is calculated 1.000 + 5.000 and the result is written into the cell. (Hint: This is only possible when the "AllowCellFunctions" flag is set to yes in the input mask settings.)

	==Implemented functions==		==Implemented functions==

S.jakobi at 11:29, 1 July 2022

2022-07-01T11:29:24Z

← Older revision		Revision as of 12:29, 1 July 2022
Line 232:		Line 232:
	\|1.000		\|1.000
	\|}		\|}
			{{Hint}}
			Example: Current Cell value: 1.000. Enter the following: =+5k then hit enter. Now it is calculated 1.000+5.000 and the result is written into the cell. (Hint: This is only possible when the "AllowCellFunctions" flag is set to yes in the input mask settings.

	==Implemented functions==		==Implemented functions==

S.jakobi: added the letters to add the zeros in order to enter bigger numbers

2022-07-01T11:24:00Z

added the letters to add the zeros in order to enter bigger numbers

← Older revision		Revision as of 12:24, 1 July 2022
Line 131:		Line 131:
	\| Data records which include the entered expression will be displayed.		\| Data records which include the entered expression will be displayed.
	\|}		\|}


	=Menu=		=Menu=

Line 181:		Line 179:

	[[Image:Pivotform_Menue.JPG]]		[[Image:Pivotform_Menue.JPG]]


	=Design of the mask=		=Design of the mask=
	[[Image:Web_EM_Allgmein.png\|1400px]]		[[Image:Web_EM_Allgmein.png\|1400px]]
Line 218:		Line 214:
	==Filter bar==		==Filter bar==
	In the filter you can see - as opposed to the windows client - only dimensions which are not defined as axis. Filter settings for dimension which are defined as axis can be done by using the filter symbol in the filter area which is shown besides the dimension or column.		In the filter you can see - as opposed to the windows client - only dimensions which are not defined as axis. Filter settings for dimension which are defined as axis can be done by using the filter symbol in the filter area which is shown besides the dimension or column.


	==Data area==		==Data area==
	In the data area measures and axis are displayed which can be changed. In the data area you can see all measures which are defined as measures in the fields area.		In the data area measures and axis are displayed which can be changed. In the data area you can see all measures which are defined as measures in the fields area.

			=== Input of greater values with the help of the input of letter ===
			In order to make the input of big values easier, there can be added a letter to an entered number to add aditional zeros automatically.
			{\| class="wikitable"
			!Input
			!Result of the input
			\|-
			\|1m
			\|1.000.000
			\|-
			\|1t
			\|1.000
			\|-
			\|1k
			\|1.000
			\|}

	==Implemented functions==		==Implemented functions==

S.jakobi: changed the used "Hint" template

2022-07-01T11:11:59Z

changed the used "Hint" template

← Older revision		Revision as of 12:11, 1 July 2022
Line 14:		Line 14:
	<nowiki>https://servername:4444/coplanner/pivottable/?pivotform=EM Bilanz PLAN</nowiki>		<nowiki>https://servername:4444/coplanner/pivottable/?pivotform=EM Bilanz PLAN</nowiki>

			{{Hint\|Text=upper and lower case of the mask name has to be correct otherwise the mask will not open.}}
	{\| {~~{Bausteindesign2}}~~
	\|-
	~~\|<span style~~=~~"color: darkblue">'''Hint'''</span>  ~~upper and lower case of the mask name has to be correct otherwise the mask will not open.
	\|}


	==Extended invocation==		==Extended invocation==

S.jakobi: small spell correction and tables adapted to standard

2022-07-01T11:00:27Z

small spell correction and tables adapted to standard

← Older revision		Revision as of 12:00, 1 July 2022
Line 72:		Line 72:
	Operators:		Operators:
	{\| class="wikitable" width="857px"		{\| class="wikitable" width="857px"
	~~\|- {{Tabellentitel}}~~		! Filter operator
	\| Filter operator		! Invocation in context
	\| Invocation in context		! Description
	\| Description
	\|-		\|-
	\| [[Image:Filter_Operand_Alle.jpg]]		\| [[Image:Filter_Operand_Alle.jpg]]
Line 105:		Line 104:

	{\| class="wikitable" width="857px"		{\| class="wikitable" width="857px"
	~~\|- {{Tabellentitel}}~~		! Filter operator
	~~\| Filteroperand~~		! Invocation in context
	\| Invocation in context		! Description
	\| Description
	\|-		\|-
	\| =		\| =

Admin at 07:03, 31 July 2019

2019-07-31T07:03:03Z

← Older revision		Revision as of 08:03, 31 July 2019
Line 236:		Line 236:
	__NOEDITSECTION__		__NOEDITSECTION__

	[[Category:WebApps\|~~Input Mask~~]]		[[Category:WebApps\|Input_Mask]]
	[[de:WebApps:Eingabemaske]]		[[de:WebApps:Eingabemaske]]

Admin at 07:02, 31 July 2019

2019-07-31T07:02:01Z

← Older revision		Revision as of 08:02, 31 July 2019
Line 179:		Line 179:
	\|[[Image:Pivotform_ExcelExport_AutoLogin.PNG]]		\|[[Image:Pivotform_ExcelExport_AutoLogin.PNG]]
	\|Exports mask to excel and proceeds an automatic login of the excel addin. Button is only visible if option AutomatedLoginAfterExcelExportAvailable is activated in the mask. CoPlanner Excel Addin has to be installed on the client side in order that works. Additionally in Excel the option 'Enable Protected View for files originating from the Internet' has to be disabled.		\|Exports mask to excel and proceeds an automatic login of the excel addin. Button is only visible if option AutomatedLoginAfterExcelExportAvailable is activated in the mask. CoPlanner Excel Addin has to be installed on the client side in order that works. Additionally in Excel the option 'Enable Protected View for files originating from the Internet' has to be disabled.
			\|-
			\|[[Image:Web_Achsendrehen.PNG]]
			\|Transposes the axes. To transfer measures only to the opposite axis, press the Ctrl key also.
	\|}		\|}

Admin at 09:47, 3 July 2019

2019-07-03T09:47:49Z

← Older revision		Revision as of 10:47, 3 July 2019
Line 229:		Line 229:

	==Implemented functions==		==Implemented functions==
	A list of all implemented functions in the input mask can be found [[WebApps:~~Eingabemaske~~:~~_Umgesetzte_Funktionen~~\|here]].		A list of all implemented functions in the input mask can be found [[WebApps:Input_Mask:_Implemented_functions\|here]].

	__NOEDITSECTION__		__NOEDITSECTION__

	[[Category:WebApps\|~~Eingabemaske~~]]		[[Category:WebApps\|Input Mask]]
	[[en:WebApps:Eingabemaske]]		[[de:WebApps:Eingabemaske]]

Admin at 09:26, 3 July 2019

2019-07-03T09:26:55Z

← Older revision		Revision as of 10:26, 3 July 2019
Line 5:		Line 5:
	=System requirements=		=System requirements=

	~~==Supported Browsers==~~		The requirements can be found [[WebApps:Requirements\|here]].
	* Internet Explorer 11 or higher
	* Edge
	* Firefox
	* Chrome

	~~==CoPlanner Server==~~
	In [[~~Technics~~:~~CoPlanner-Server#SvrConfig.xml~~\|~~svrconfig.xml~~]] ~~the WebAppUrl has to be included and all necessary steps to establish REST have to be finished~~. ~~(see[[Technics:CoPlanner-Server#Zusätzliche_Voraussetzungen_für_die_Verwendung_der_REST-Funktionalitäten]])~~


	=Invocation=		=Invocation=