Hi
the decimal in my country is ',' and your country is '.'
and the thoudsands is '.' and your country is ','.
how can I to convert?
I use:
$col = array();
$col["title"] = "<center>Valor<br>Costo</center>";
$col["name"] = "valorcosto";
$col["width"] = "10";
$col["align"] = "right"; // this column is not editable
$col["editable"] = true;
$col["formatter"] = "currency";
$col["formatoptions"] = array("prefix" => "$","suffix" => '',"thousandsSeparator" => ".","decimalSeparator" => ",","decimalPlaces" => '2');
$col["search"] = false; // this column is not searchable
$cols[] = $col;
but the information is Ex. $241,5 and the show me $24.1.5
Thank you
Your formatoptions looks fine except:
"decimalPlaces" => '2')
should be:
"decimalPlaces" => 2)
(without quotes)