NOTE!
Set the emptyTo
selector below:
top
- sort empty table cells to the top.bottom
- sort empty table cells to the bottom.none
orzero
- sort empty table cells as if the cell has the value equal to zero.- Individual columns can be modified by adding the following (they all do the same thing), set in order of priority:
- jQuery data
data-empty="top"
. - metadata
class="{ empty: 'top'}"
. This requires the metadata plugin. - headers option
headers : { 0 : { empty : 'top' } }
. - header class name
class="empty-top"
. - Overall
emptyTo
option.
- jQuery data
emptyToBottom
option was added in v2.1.11, then replaced by theemptyTo
option in v2.1.16.
Demo
SetemptyTo
option:
*Account # |
First Name |
Last Name |
Age |
Total |
Discount |
Diff |
---|---|---|---|---|---|---|
A43 | Peter | Parker | 28 | 20.3% | +3 | |
A255 | Hood | 19.99 | 25.1% | -7 | ||
Clark | 18 | 15.89 | 44.2% | -15 | ||
A1 | Bruce | Almighty | 45 | 153.19 | +19 | |
A102 | Bruce | Evans | 56 | 153.19 | 23% | |
A109 | Larry | Stevens | 56 | 153.19 | 23% | 0 |
A99 | John | Smithy | 56 | 156 | 22% | |
A119 | Mike | Rowe | 55 | -53.99 | 13% | 0 |
emptyTo
option (see the order of priority note above).
Javascript
$(function() { // call the tablesorter plugin $("table").tablesorter({ theme : 'blue', // default "emptyTo" emptyTo: 'bottom' }); });
HTML
<table class="tablesorter"> <thead> <tr> <th class="empty-top">*Account #</th> <!-- empty-top class has higher priority than the "emptyTo" option --> <th>First Name</th> <th>Last Name</th> <th>Age</th> <th>Total</th> <th>Discount</th> <th>Diff</th> </tr> </thead> <tbody> <tr> <td>A43</td> <td>Peter</td> <td>Parker</td> <td>28</td> <td></td> <td>20.3%</td> <td>+3</td> </tr> <tr> <td>A255</td> <td></td> <td>Hood</td> <td></td> <td>19.99</td> <td>25.1%</td> <td>-7</td> </tr> <tr> <td></td> <td>Clark</td> <td></td> <td>18</td> <td>15.89</td> <td>44.2%</td> <td>-15</td> </tr> <tr> <td>A1</td> <td>Bruce</td> <td>Almighty</td> <td>45</td> <td>153.19</td> <td></td> <td>+19</td> </tr> <tr> <td>A102</td> <td>Bruce</td> <td>Evans</td> <td>56</td> <td>153.19</td> <td>23%</td> <td></td> </tr> <tr> <td>A109</td> <td>Larry</td> <td>Stevens</td> <td>56</td> <td>153.19</td> <td>23%</td> <td>0</td> </tr> <tr> <td>A99</td> <td>John</td> <td>Smithy</td> <td>56</td> <td>156</td> <td>22%</td> <td></td> </tr> <tr> <td>A119</td> <td>Mike</td> <td>Rowe</td> <td>55</td> <td>-53.99</td> <td>13%</td> <td>0</td> </tr> </tbody> </table>