Thanks a lot for quick response 1,2 an 4 worked like a Charm, still not able to sort amount and date fields,
when i am trying to sort on date field got number expected javascript error message on _sortTreeRows function i am using mm/dd/yyyy format and please find below my sample xml code used to build this field, Note: i am using here span tag for sytle, please find attached screenshot 1.
rowElement1.addElement(“cell”).setText(""+unitItem.getFloorDate()+"</span>");
>>Q3. setNumberFormat did not work even for dollar amount
change type of related column to “ron”
when i used ron to sort my amount field with dollar symbol its not sorting correctly please find attahed screenshots 2 and 3 and in some cases got NaN error message
Thanks
Laks