Difference between revisions of "Template:Cell Formatting"
From dataZoa Wiki
Line 1: | Line 1: | ||
<table class="Gbb1"> | <table class="Gbb1"> | ||
− | <tr><td style="min-width: 8em;">Tab name</td><td>Fields</td><td>Description</td><td>Examples</td></tr> | + | <tr><td class="GbcLgray" style="min-width: 8em;">Tab name</td><td>Fields</td><td>Description</td><td>Examples</td></tr> |
<tr><td colspan="4" class="GbcLgray"><b>Styling</b></td></tr> | <tr><td colspan="4" class="GbcLgray"><b>Styling</b></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> |
Revision as of 15:11, 18 January 2017
Tab name | 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 | |
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 | |
Commas | Checkbox, use comma separator | Financial information | |
Swap comma/period | Checkbox, European-style separators | European financial information |