Export to Excel ignores Number precision settings

User 7b0ee04e66

10-02-2011 13:16:09


I am currently using IJC 5.4

I need to export the Molweight with a precision of 2 digits.

I have set up a new Chemical Terms field and set the precision to 2.

When I export the data to Excel file, I lose the precision and the full value is exported (435.519989013671).

When I export the same data to CSV file, the precision is not lost. But this will mean an extra step of opening each file and saving it as an Excel spreadsheet.



ChemAxon fa971619eb

11-02-2011 14:08:39

Thanks for the report. We will investigate and resolve.


ChemAxon 99d87cf303

31-03-2011 13:09:21

The real problem was that full value in this case was 435.52 and IJC lost precision during export/coversion to the excel. So it was seen as 435.519989013671 instead of real value 435.52.

It was just fixed in trunk. Will be available in the upcomming IJC 5.5. Thanks for the catch.

ChemAxon fa971619eb

31-03-2011 17:04:26

Also bear in mind that Excel can change the format of the numbers that are displayed (e.g. the number of decimal places).

IJC exports the actual value in the database without formatting. Excel migth format this e.g. using only 2 decimal places, but this is configurable withing Excel.

The bug was that the numbers were not exported correctly during Excel export, resulting in sem loss of precission.