Hi Abu,

how can I to formated number or currency?

Ex.

$col = array();
$col[“title”] = “Descuento”;
$col[“name”] = “descuento”;
$col[“width”] = “10”;
$col[“align”] = “right”;

if($row[‘tipodescuento’] == ‘%’)
{
$col[“formatter”] = “number”;
$col[“formatoptions”] = array(“prefix” => ”,”suffix” => ‘%’,”thousandsSeparator” => ‘.’,”decimalSeparator” => ‘,’,”decimalPlaces” => 2);
}
else
{
$col[“formatter”] = “currency”;
$col[“formatoptions”] = array(“prefix” => “$”,”suffix” => ”,”thousandsSeparator” => “.”,”decimalSeparator” => “,”,”decimalPlaces” => 2);
}

$col[“search”] = false; // this column is not searchable
$cols[] = $col;

Thank you