Components > Component properties

The display format specifies the representation of values within a text. Precondition is that the component has an input "value display".

For strings and other values '#' can be used as a placeholder . If a value has been received # will be replaced by the value. Should the value "0" be displayed, the placeholder must be 0 instead of #.

Examples of value displays:

#0,0 for two digits before the decimal point and one digit after the decimal point

##0,000 for three digits before the decimal point and three digits after the decimal point

%H:%M:%S for operating hours

HH:mm:ss for hour:minute:seconds

dd.MM.yyy for day/month/year. The following applies: MM=month, dd=day, yy=year, HH=hours, mm=minutes, ss=seconds

0.0 °C for temperatures
0,0 A for current

Text "%" for a % - value (The percent sign must be directly enclosed in quotation marks to prevent incorrect displays. In the touch value input \% is displayed).

Text #0,0 °C; Text -#0,0 °C for temperatures with positive and negative values

"Text positive" ##0,00; "Text negative" -##0,00 for values with positive and negative values

To show both, text and numbers in a cell, close the text characters in quotation marks (' '),

E.g .: If you would like to use the % -symbol, you have to close it in any case in superscript (quotation marks), otherwise the arithmetic operation% (multiplied by 100) is executed. Should be: '%'.

Display of Text and Numbers
0 (Null)	Placeholder for numeric displays with meaningless zeros, if a number has fewer digits than zeros in the format. If you enter eg. 8.9 and you want display it as 8.90, use the format # .00
#	This placeholder follows the same rules as the 0 (zero). However no additional zeros will be dsiplayed, if the number you entered has on both sides of the decimal fewer digits, as the # symbols in the format. When the custom size z. B. #, ## states and 8.9 is entered, the number 8.9 will be displayed.

Display of Date and Time
d	1-31	Shows the day as a number without leading 0.
dd	01-31	Shows the day as a number with leading 0.
ddd	Sun-Sat	Shows the day as an abbreviation.
dddd	Sunday-Saturday	Shows the day in complete notation.

M	1-12	Shows the month as a number without leading 0.
MM	01-12	Shows the month as a number with leading 0.
MMM	Jan-Dec	Shows the month as an abbreviation.
MMMM	January-December	Shows the month in complete notation.

y (klein)	0-99	Shows the year as a number without leading 0.
yy (klein)	00-99	Shows the year as a two-digit number with leading 0.
yyyy (klein)	1900-9999	Shows the year as a four-digit number.

H	0-23	Shows the hour as a number without leading 0.
HH	00-23	Shows the hour as a number with leading 0.

h	0-12	Shows the hour as a number without leading 0. The display is based on the 12-hour clock.
hh	00-12	Shows the hour as a number with leading 0. The display is based on the 12-hour clock.

m	0-59	Shows the minute as a number without leading 0.
mm	00-59	Shows the minute as a number with leading 0.

s	0-59	Shows the second as a number without leading 0.
ss	00-59	Shows the second as a number with leading 0.

t	A-P	Displays the first character of the AM / PM designation for the specified time. (Will not be displayed in all regions)
tt	AM-PM	Displays the AM / PM designation for the specified time (does not appear in all regions)

z	-12 - +13	Displays the offset of the current system time zone in whole hours. The offset is always displayed with a leading plus or minus sign (zero is called a "+0" is displayed), the hours before the (+) GMT (Greenwich Mean Time) or by - indicates GMT (). The range is between -12 and +13. If the offset is a single digit (0-9), it is displayed as a single digit with the appropriate sign. The setting for the time zone is specified as + X or -X, where X is the offset from GMT in hours. The displayed offset is affected by daylight savings time.
zz	-12 - +13	Displays the offset of the current system time zone in whole hours. The offset is always displayed with a leading or trailing plus or minus sign (zero is called "+00" is displayed), the hours before the (+) GMT (Greenwich Mean Time) or by - indicates GMT (). The range is between -12 and +13. If the offset only a single digit (0-9), this prefix will be added when formatting a 0 (01-09). The setting for the time zone is specified as + X or -X, where X is the offset from GMT in hours. The displayed offset is affected by daylight savings time.
zzz	-12:00 - +13:00	Displays the offset of the current time zone of the system in hours and minutes. The offset is always displayed with a leading or trailing plus or minus sign (zero is called "+00: 00"), which the hours before (+) GMT (Greenwich Mean Time) or after (-) indicates GMT , The range is between -12: 00 and +13: 00 hours. If the offset only a single digit (0-9), this is followed by 0 (01-09) and the corresponding character prefixed when formatting. The setting for the time zone is specified as + X or -X, where X is the offset from GMT in hours. The displayed offset is affected by daylight savings time.

Settings

Settings