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
- None/zero has a value less than A through Z (in javascript,
0 < 'A' && 0 < 'Z'
); so in an alphabetical column, empty cells will sort at the top in an ascending sort & at the bottom in a descending sort. - In numerical columns, empty cells will sort as if their value was 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>