Difference between revisions of "Template:Cell Formatting"

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

@@ Line 20: / Line 20: @@
 <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>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>Swap comma/period</td><td>Checkbox, European-style separators</td><td>European financial information</td></tr>
 </table>