Random digits added to imported datapoints

[moPellowe]

I've noticed that random digits get added to imported data points with decimals in PK-Sim.

I imported an excel sheet (attached below) into PK-Sim for a generic compound (I just loaded the Aciclovir template), and when I look at the data within the building block, there are digits added that weren't in the original xlsx file.

test.xlsx

[msevestre]

@moPellowe Transferring this to our code repository.
I believe this is a display issue only when converting values from float to double

@Yuri05 The problem happens here I believe
https://github.com/Open-Systems-Pharmacology/OSPSuite.Core/blob/develop/src/OSPSuite.Infrastructure.Export/DataRepositoryExportTask.cs#L178

We are converting a float to double via the UnitConversion methods. Then the DataTable is bound to the grid for display and the value has been corrupted

The same happens when we are loading the value and saving it from display unit in the file to internal unit in the column

I feel that we should create an overload that converts a float to float for unit conversion. Internally, we should only use float, also in the DataTable

[Yuri05]

I feel that we should create an overload that converts a float to float for unit conversion. Internally, we should only use float, also in the DataTable

Agree.