When I use setNumberFormat = ‘$0,000", 1, “.”, ",’ the downloaded Excel file has all zero values.
When I use setNumberFormat = ‘0,000", 1, “.”, ",’ the downloaded Excel file has decimal places instead of a comma and truncated the rest of the number on the right side.
I have tried making the change to gridExcelWrapper suggested in another post:
case 'ron':
$text = preg_replace("/[^\d-\.]/", "", $text);
$this->excel->getActiveSheet()->getCell($this->getColName($i).$this->currentRow)->setValueExplicit($text, PHPExcel_Cell_DataType::TYPE_NUMERIC);
break;
This change did not help.