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 for the report. We will investigate and resolve.
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.
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.