We are using dhtml 5.x version with “Enterprise license”. We had one critical business case with respect to DHTML Grid export functionality.
When we export txt data type cell with value example “12e3” then export functionality converting the value from 12e3 to 12000. This happing when we have character “e” between the numbers. I think because of character “e” the entire text column is converted with exponential number even the cell/column data type is “txt”
We have debugged and below are findings.
Note: We internally deployed DHTML export feature/service as war file from the following source link and invoking as “grid.toExcel(”…/grid-excel/generate");"
If we use direct online export service i,e. https://export.dhtmlx.com/grid5/excel the same use case working fine and grid file extension this time is xlsx (grid.xlsx).
Due to organization level security policy we are not allowed to use the online export service.
This is very much impacting the business so please help us in resolving the issue owing to the urgency of the issue.