User 7b0ee04e66
10-02-2011 13:16:09
Hello
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.
Thanks
Catherine
ChemAxon fa971619eb
11-02-2011 14:08:39
Thanks for the report. We will investigate and resolve.
Tim
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.
Tim