Template:Number table sorting
Similar to Dts, Number table sorting stands for Number Table Sorting and is used to display numbers with thousands separator in a sortable table and have them numerically sorted in alphabetic sort mode.
What it solves[change source]
Formerly, for table sorting to function correctly, numbers had to be entered with not more than one thousands separator. As a workaround alphabetic sorting mode was applied, and the numbers provided with a hidden part so that alphabetic sorting corresponded with numeric sorting.
Since a mix in one column of numbers formatted for alphabetic sorting and plain numbers does not allow proper sorting, adding a number in an existing table may require putting it in the format used in that column. Also, if some table cells in a column contain text after the number, or if the numbers are preceded by some fixed text other than a currency symbol, alphabetic sorting mode is needed.
This template automatically creates the hidden
<span style="display:none">&&&&&&&0123456789.&&1230</span> 123,456,789.00123 before the actual displayed number. It forces the sorting routine to use text sort on the hidden segment, which functions correctly due to the preceding ampersands (currently till 16 digits before, and 6 digits after the decimal separator).
Negative numbers do not sort correctly with this template.
The template has only one parameter: a real number without thousand separators.
Output sent to table
<span style="display:none">&&&&&&&0123456789.&&1230</span> 123,456,789.00123
Output displayed to user
Related pages[change source]
- Template:Ntsh- same as Nts, but does not display the number
- Template:Lsc11- using non-breaking spaces instead of ampersands in a similar fashion
|The above documentation is transcluded from Template:Number table sorting/doc. (edit | history)|
Editors can experiment in this template's sandbox (create | mirror) and testcases (create) pages.
Please add categories to the /doc subpage. Subpages of this template.