Excel import decimal formatting incorrect

0
For a project we use the Excel Importer module to import .xlsx files. For this we use a template where we set each attribute as data type string.    The import runs smoothly, without errors. However when we import a cell with string value 2,43 it takes on the value 2,34000000002. This seems as it has been formatted as decimal. However in entity we only import strings. In excel file the cell takes category Standard. With all other values (2.43, 2,34) we get the expected result.   Is anyone familair with this issue? Any recommendations?
asked
1 answers
0

This happens because you are importing as a string.

Why.. I don't know.

 

My solution was to convert it to decimal then to string again.

 

if parseDecimal(trim($object/strDecimal),empty) != empty

then formatDecimal(parseDecimal(trim($object/strDecimal)),'#.##')

else $object/strDecimal

answered