Difference between revisions of "Template:Cell Formatting"
From dataZoa Wiki
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<table class="Gbb1"> | <table class="Gbb1"> | ||
| − | <tr><td style="min-width: 8em;"> | + | <tr><td style="min-width: 8em;"></td><td>Fields</td><td>Description</td><td>Examples</td></tr> |
| − | <tr><td colspan="4" | + | <tr><td colspan="4" class="GbcLgray"><div class="GfakeTabGroup"><div class="GfakeTab">Styling</div></div></td></tr> |
<tr><td></td><td>Min Decimals</td><td>Minimum number of decimals to show</td><td>2 for U.S. Currency</td></tr> | <tr><td></td><td>Min Decimals</td><td>Minimum number of decimals to show</td><td>2 for U.S. Currency</td></tr> | ||
<tr><td></td><td>Max Decimals</td><td>Maximum number of decimals to show</td><td>2 for U.S. Currency</td></tr> | <tr><td></td><td>Max Decimals</td><td>Maximum number of decimals to show</td><td>2 for U.S. Currency</td></tr> | ||
| + | <tr><td></td><td>Percentage Decimals</td><td>Exact number of decimals to show <br>in fields that are calculated as <br>percentages within the display itself.</td><td>2 for <b>1.23%</b><br><br>0 for <b>1%</b></td></tr> | ||
<tr><td></td><td>Prefix</td><td>Text to use before the number</td><td>$<br>Yen: </td></tr> | <tr><td></td><td>Prefix</td><td>Text to use before the number</td><td>$<br>Yen: </td></tr> | ||
<tr><td></td><td>Suffix</td><td>Text to use after the number</td><td>(USD)<br>(thous.)<br>%</td></tr> | <tr><td></td><td>Suffix</td><td>Text to use after the number</td><td>(USD)<br>(thous.)<br>%</td></tr> | ||
| − | <tr><td colspan="4">Scale</td></tr> | + | <tr><td colspan="4" class="GbcLgray"><div class="GfakeTabGroup"><div class="GfakeTab">Scale</div></div></td></tr> |
<tr><td></td><td>Multiply by</td><td>Number</td><td>100, to express a percentage</td></tr> | <tr><td></td><td>Multiply by</td><td>Number</td><td>100, to express a percentage</td></tr> | ||
<tr><td></td><td>Divide by</td><td>Number</td><td>1000 for currency in thousands</td></tr> | <tr><td></td><td>Divide by</td><td>Number</td><td>1000 for currency in thousands</td></tr> | ||
<tr><td></td><td>Add</td><td>Number</td><td>1.7, to add an integration constant</td></tr> | <tr><td></td><td>Add</td><td>Number</td><td>1.7, to add an integration constant</td></tr> | ||
<tr><td></td><td>Subtract</td><td>Number</td><td>1, to zero-base an index</td></tr> | <tr><td></td><td>Subtract</td><td>Number</td><td>1, to zero-base an index</td></tr> | ||
| − | <tr><td colspan="4">+ / -</td></tr> | + | <tr><td colspan="4" class="GbcLgray"><div class="GfakeTabGroup"><div class="GfakeTab">+ / -</div></div></td></tr> |
<tr><td></td><td>Parens when < 0</td><td>Checkbox</td><td>Financial negative</td></tr> | <tr><td></td><td>Parens when < 0</td><td>Checkbox</td><td>Financial negative</td></tr> | ||
<tr><td></td><td>Color when < 0</td><td>HTML color name</td><td>Red</td></tr> | <tr><td></td><td>Color when < 0</td><td>HTML color name</td><td>Red</td></tr> | ||
<tr><td></td><td>Color when > 0</td><td>Number</td><td>Blue</td></tr> | <tr><td></td><td>Color when > 0</td><td>Number</td><td>Blue</td></tr> | ||
| − | <tr><td colspan="4">Other</td></tr> | + | <tr><td colspan="4" class="GbcLgray"><b><div class="GfakeTabGroup"><div class="GfakeTab">Other</div></div></b></td></tr> |
<tr><td></td><td>ND</td><td>Text to use when No Data</td><td>No data exists</td></tr> | <tr><td></td><td>ND</td><td>Text to use when No Data</td><td>No data exists</td></tr> | ||
<tr><td></td><td>N/A</td><td>Text to use when Not Available</td><td>No data available</td></tr> | <tr><td></td><td>N/A</td><td>Text to use when Not Available</td><td>No data available</td></tr> | ||
<tr><td></td><td>NDD</td><td>Text to use when Not Disclosed</td><td>Undisclosed</td></tr> | <tr><td></td><td>NDD</td><td>Text to use when Not Disclosed</td><td>Undisclosed</td></tr> | ||
| + | <tr><td></td><td>Date Format Offset Fraction</td><td>Offset Date Display (like '0.58' for Thursday on Weekly data)</td><td>Adjust Date on Period Displayed</td></tr> | ||
<tr><td></td><td>Commas</td><td>Checkbox, use comma separator</td><td>Financial information</td></tr> | <tr><td></td><td>Commas</td><td>Checkbox, use comma separator</td><td>Financial information</td></tr> | ||
<tr><td></td><td>Swap comma/period</td><td>Checkbox, European-style separators</td><td>European financial information</td></tr> | <tr><td></td><td>Swap comma/period</td><td>Checkbox, European-style separators</td><td>European financial information</td></tr> | ||
</table> | </table> | ||
Latest revision as of 12:35, 30 March 2020
| Fields | Description | Examples | |
Styling | |||
| Min Decimals | Minimum number of decimals to show | 2 for U.S. Currency | |
| Max Decimals | Maximum number of decimals to show | 2 for U.S. Currency | |
| Percentage Decimals | Exact number of decimals to show in fields that are calculated as percentages within the display itself. | 2 for 1.23% 0 for 1% | |
| Prefix | Text to use before the number | $ Yen: | |
| Suffix | Text to use after the number | (USD) (thous.) % | |
Scale | |||
| Multiply by | Number | 100, to express a percentage | |
| Divide by | Number | 1000 for currency in thousands | |
| Add | Number | 1.7, to add an integration constant | |
| Subtract | Number | 1, to zero-base an index | |
+ / - | |||
| Parens when < 0 | Checkbox | Financial negative | |
| Color when < 0 | HTML color name | Red | |
| Color when > 0 | Number | Blue | |
Other | |||
| ND | Text to use when No Data | No data exists | |
| N/A | Text to use when Not Available | No data available | |
| NDD | Text to use when Not Disclosed | Undisclosed | |
| Date Format Offset Fraction | Offset Date Display (like '0.58' for Thursday on Weekly data) | Adjust Date on Period Displayed | |
| Commas | Checkbox, use comma separator | Financial information | |
| Swap comma/period | Checkbox, European-style separators | European financial information | |
