Difference between revisions of "Template:Cell Formatting"

From dataZoa Wiki
Jump to: navigation, search
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 nameFieldsDescriptionExamples
Styling
Min DecimalsMinimum number of decimals to show2 for U.S. Currency
Max DecimalsMaximum number of decimals to show2 for U.S. Currency
PrefixText to use before the number$
Yen:
SuffixText to use after the number(USD)
(thous.)
%
Scale
Multiply byNumber100, to express a percentage
Divide byNumber1000 for currency in thousands
AddNumber1.7, to add an integration constant
SubtractNumber1, to zero-base an index
+ / -
Parens when < 0CheckboxFinancial negative
Color when < 0HTML color nameRed
Color when > 0NumberBlue
Other
NDText to use when No DataNo data exists
N/AText to use when Not AvailableNo data available
NDDText to use when Not DisclosedUndisclosed
CommasCheckbox, use comma separatorFinancial information
Swap comma/periodCheckbox, European-style separatorsEuropean financial information