Excel import is adding decimal places

Comments

3 comments

  • Gido

    I haven't observed an issue like the described one till now. To be able to setup a small test, can you share your used Datameer and Excel version? And how many records are in the column usually? 

    0
    Comment actions Permalink
  • Mike Coffey

    The column has a couple hundred values.  Excel version is 2013, Datameer is 5.4.2

    0
    Comment actions Permalink
  • Gido

    Thanks for sharing additional details.

    Meanwhile I've created a sample file and think I was able to reproduce the issue you are observing. 

    There was always a decimal point, and an integer number like 12345 was shown as 12345.0. The reason seems to be a Java .toString() method for conversion.

    To workaround this you may export the Excel spreadsheet to CSV instead of saving as XLS. 

    0
    Comment actions Permalink

Please sign in to leave a comment.