Number formatting truncates decimals

Suite and Optimus Suite 5
#1

I have a site that uses DHTMLXGrid to display data online, but if I format cells (using the API or XML) to “0.00”, only the formatted number is stored in memory, not the actual number. So when users export to Excel, any numbers after the first 2 decimals get cut off.

Isn’t the best practice in this situation to store the full value of the cell and then manipulate only what the user sees? :question:

#2

Unfortunately the method was designed so the user see the formatted value in the Excel.
In most cases the user needs to see in the excel or pdf file those values that he saw in the grid.