Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Adam Downs on Feb 13, 2009 09:58
open dhtmlx forum
Math Results Format

I am using pro grid 2.0 and I have a math column... I have math rounding set to 2 and when the result is Negative less then 1 the format is wrong

IE 100-100.5 = "0-.5" I need the negitive sign to be on the left of the result not in the middle

I am trying to use a price format so the respose i was sent doesnt really work.

Instead of using setMathRound, you can use edn ( or ron ) column type with math support defined and setNumberFormat
mygrid.setColTypes("ed,ed,price,ed,edn[=]");
mygrid.setNumberFormat("0.00",4);

How can i get the calculaced price column format to be correct?

Regards,
Answer posted by Support on Feb 13, 2009 10:19
>>I am trying to use a price format so the respose i was sent doesnt really work.
If all what you need a currency char, it can be done as

mygrid.setColTypes("ed,ed,price,ed,edn[=]"); 
mygrid.setNumberFormat("$ 0.00",4); //or any other chars can be added to format mask