tablesoter is not working when first row has empty value

[kotarao]

Hi,

need help on tablesorter.

TableSorter is not working when date field first row is empty. when I enter some date on first field , sorting is working fine.

Please can you help me what I need to change here?

$(document).ready(
$(function () {
$('#GridViewSummaryResults').tablesorter({
widgets: ['zebra'], theme: 'blue', headers: { 0: { sorter: false } }, emptyTo: 'top',
textExtraction: {
1: function (node, table, cellIndex) { return $(node).find("span").text(); },
2: function (node, table, cellIndex) { return $(node).find("span").text(); },
3: function (node, table, cellIndex) { return $(node).text(); },
4: function (node, table, cellIndex) { return $(node).text(); }
}

			});

		})
	);

My HTML code is

<thead>
	<tr>			
		<th>
			Order #
		</th>
		<th>
			Customer
		</th>
		<th>

			PO
		</th>
		<th>
			Date
		</th>
		<th>
			Total
		</th>
	</tr>
</thead>

<tbody>
	
		<tr>				
			<td  >
				<a href="javascript:alert('Order # SO71774')">SO71774</a>
			</td>
			<td>
				 <span id="GridViewSummaryResults_name1">Good Toys</span>					
			</td>
			<td>
				 <span id="GridViewSummaryResults_PO1">PO348186287</span>					
			</td>
			<td>
			
			</td>
			<td>
				$972.78
			</td>

		</tr>
					
	
		<tr class="even">				
			<td  >
				<a href="javascript:alert('Order # SO71775')">SO71775</a>
			</td>
			<td>
				 <span id="GridViewSummaryResults_name2">Cycle Clearance</span>					
			</td>
			<td>
				 <span id="GridViewSummaryResults_PO2">PO58159451</span>						
			</td>
			<td>
				01/06/10
			</td>
			<td>
				$2,313.13
			</td>

		</tr>
		
		
	
		<tr>				
			<td  >
				<a href="javascript:alert('Order # SO71776')">SO71776</a>
			</td>
			<td>
				<span id="GridViewSummaryResults_name3">West Side Mart</span>						
			</td>
			<td>
				<span id="GridViewSummaryResults_PO3">PO19952192051</span>	
				
			</td>
			<td>
				10/01/15
			</td>
			<td>
				$87.09
			</td>
		</tr>
		<tr class="even">				
			<td  >
				<a href="javascript:alert('Order # SO71777')">SO71777</a>
			</td>
			<td>
				<span id="GridViewSummaryResults_name4">Demand Distributors</span>
				
			</td>
			<td>
				<span id="GridViewSummaryResults_PO4">PO20097113391</span>						
			</td>
			<td>
				07/01/17
			</td>
			<td>
				$1,267.82
			</td>

		</tr>
		
	<tr>				
			<td  >
				<a href="javascript:alert('Order # SO71776')">SO71786</a>
			</td>
			<td>
				<span id="GridViewSummaryResults_name5">West Side Mart5</span>						
			</td>
			<td>
				<span id="GridViewSummaryResults_PO5">PO19952192041</span>	
				
			</td>
			<td>
				&nbsp;
			</td>
			<td>
				$87.09
			</td>
		</tr>
		<tr class="even">				
			<td  >
				<a href="javascript:alert('Order # SO71777')">SO71778</a>
			</td>
			<td>
				<span id="GridViewSummaryResults_name6">Demand Distributors6</span>
				
			</td>
			<td>
				<span id="GridViewSummaryResults_PO6">PO20097113396</span>						
			</td>
			<td>
				&nbsp;
			</td>
			<td>
				$1,267.82
			</td>

		</tr>
	<tr>				
			<td  >
				<a href="javascript:alert('Order # SO71676')">SO71786</a>
			</td>
			<td>
				<span id="GridViewSummaryResults_name7">West Side Mart8</span>						
			</td>
			<td>
				<span id="GridViewSummaryResults_PO7">PO19952192041</span>	
				
			</td>
			<td>
				07/01/10
			</td>
			<td>
				$87.09
			</td>
		</tr>

	<tr class="even">				
			<td  >
				<a href="javascript:alert('Order # SO71777')">SO71778</a>
			</td>
			<td>
				<span id="GridViewSummaryResults_name8">Demand Distributors6</span>
				
			</td>
			<td>
				<span id="GridViewSummaryResults_PO8">PO20097113396</span>						
			</td>
			<td>
				&nbsp;
			</td>
			<td>
				$1,267.82
			</td>

		</tr>
	<tr>				
			<td  >
				<a href="javascript:alert('Order # SO71676')">SO71786</a>
			</td>
			<td>
				<span id="GridViewSummaryResults_name9">West Side Mart8</span>						
			</td>
			<td>
				<span id="GridViewSummaryResults_PO9">PO19952192041</span>	
				
			</td>
			<td>
				12/15/09
			</td>
			<td>
				$187.09
			</td>
		</tr>
	</tbody>

[kotarao]

sorting screen shot for your reference:-

[Mottie]

Hi @kotarao!

Set the headers option for that column because it's not correctly auto-detecting the data type.