| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Custom number formats"
(Created page with "Some screens in XLCubed allow you to enter a text template to be used, e.g. Tooltips for Small Multiple Charts or the text of Treemaps. In these cases you can set a c...") |
|||
| Line 2: | Line 2: | ||
In these cases you can set a custom number format for any numeric placeholders by following the placeholder with braces - {{Code| { } }}. | In these cases you can set a custom number format for any numeric placeholders by following the placeholder with braces - {{Code| { } }}. | ||
| + | |||
| + | These must always be entered in US English format, and will be translated to the correct format for the user based on their settings. (Decimal separator is "." and thousand separator is ","). | ||
e.g. | e.g. | ||
{{Code| %value%{0.00} %valuex%{0} }} | {{Code| %value%{0.00} %valuex%{0} }} | ||
Latest revision as of 11:35, 9 September 2016
Some screens in XLCubed allow you to enter a text template to be used, e.g. Tooltips for Small Multiple Charts or the text of Treemaps.
In these cases you can set a custom number format for any numeric placeholders by following the placeholder with braces - { } .
These must always be entered in US English format, and will be translated to the correct format for the user based on their settings. (Decimal separator is "." and thousand separator is ",").
e.g.
%value%{0.00} %valuex%{0}
