cell "format" as an attribute of column in datagrid

[mshaffer]

Hi,

I am trying to sort data that I have built in HTML...

The sorting is "as a string"... that is "73" and "7" are before "6"...

In your data examples, when you put in the data field, it works as expected, but in the table format, it does not.

In the data examples, you can do "type of" ... which is not possible with table, so I propose adding type-of as a column attribute

Code:

if(typeof(data) == 'number')  
if(typeof(data) == 'boolean')

In the same vain, your sorter: true, with asc and desc ... you should also have default methods of "alpha" or "numeric" with custom functions to override.

Code:

field:'freq', align: 'center',sortable:true, order:'desc', format:'number'

[jarry]

The 'sorter' function can be used to custom your sort on a field. The code below shows how to sort a 'date' field.

Code:

$('#dg').datagrid({
	remoteSort: false,
	columns: [[
		{field:'date',title:'Date',width:80,sortable:true,align:'center',  
			sorter:function(a,b){  
				a = a.split('/');  
				b = b.split('/');  
				if (a[2] == b[2]){  
					if (a[0] == b[0]){  
						return (a[1]>b[1]?1:-1);  
					} else {  
						return (a[0]>b[0]?1:-1);  
					}  
				} else {  
					return (a[2]>b[2]?1:-1);  
				}  
			}  
		}
	]]
});

[mshaffer]

Yes, that was my workaround after finding out "table data" and "direct data" behave differently.