Decimal and thousand separator in grid.toExcel

Suite and Optimus Suite 5
#1

I have a serious problem. We work in Italy, and (unfortunately), we separate thousands with a dot “.” and decimal is a comma “,”, eg:
1.234.567,89
When ever i use the grid.toExcel function calling:
myGrid.toExcel(“assets/DHTMLX46/codebase/grid-excel-php/generate.php”);
All the numbers I receive in excel are messed up due to this.

I have tried:

  1. setting the grid number format, (i.e. myGrid.setNumberFormat(“0,000.00”,5,“,”,“.”) )
  2. changing the regional settings on my pc (adjusting thou separator and decimal)

But I still get incorrect numbers, i.e. 1,920.84 (uk format) becomes 1.92084

How can I solve this?