Hi…
I have a problem with displaying the number formatted (using thousand and decimal separator). Number format is not working! I am doing formatting via XML. this is an example of my codding.
0
0true
1true
0,000
6
Company
Risk
Claim No
Date of Loss
Remarks
Curr
Claim Amount
Deductible
Paid
OutStanding
Policy Year
…
I also want to sort the date, but not working too. Is there anything that I missed?
TIA,
FY
Actually the XML which you provided - works fine, it output 12345 as 12,345
Instead of
you can use
Claim Amount
sorry, but when I run this script. Why it is display ‘N.aN’ in the column instead of the value?
FY
The data which you provided as cell value is not a number, grid uses parseFloat function against incoming data to convert it to correct numbers, if incoming data can’t be converted to number ( most common issue - it has some extra text chars, such as currency mark ) - data outputed as NaN
thanks for the number sorting, now my problem is solved. but I need a help with date sorting, too.
the problem is I have 2 date field, if I sort field 1 the sorting process was working. but if I sort column 2, it still sort the column 1. can we have more than 1 date field on the grid and how to sort it. below is the copy of my code.
0
0true
1true
Company
Risk
Claim No
Date of Loss
Progress Date
Progress Status
Description
Policy Year
…
TIA,
FY
Problem may be caused by date format
Currently you not using “sort” attribute at all, which results in sorting dates as strings ( which most probably is incorrect )
If you specify sort=“date” - it will sort dates correctly, but only if they are in default format => mm/dd/yyyy
If you are using data in any other format - you need to specify custom sorting routine for such columns
dhtmlx.com/docs/products/kb/inde … ort%20date