Hi,
We are using the DHTMLX suite v3.6 and we have a probleme with the grid.toExcel() function using the PHP package.
We create the xml, and we set the format (example: objColumn.setAttribute “format”, “0,000.0000”) and it is displayed correctly in the dhtmlx grid component, but when we use the “.toExcel” functionality the generated excel file doesn’t display the same format, and always use the generic excel’s format.
I check the $xmlString received by the “generate.php” file and in the headers data the “format” atribute doesnt appear, and also the “gridExcelWrapper.php” class doest set any format at all.
Do you know any method to pass the custom format setted in the grid to the “.toExcel” functionality?
Or do yoy know any tip to include the format atribute in the xml sended from the .toExcel method of the grid to the “generate.php” file, with that i could customize the “gridExcelGenerator.php’” class (headerParse($header) method) to include the correct format.
I also checked the last available version and the result was the same.
I hope you could help me.
Thank you very much!!