11 Replies Latest reply on Feb 1, 2016 12:03 AM by Fred(CH)

    Excel importation may misinterpret fractional numbers

    Fred(CH)

      Product and version

      FileMaker Pro 11->14.0.4

      OS and version

      Mac OS X 10.10.5 and Windows 7

      Hardware

      iMac 5K Retina 27" end 2014

      Description

      Excel importation may misinterpret fractional numbers, e.g., 1.1 is becoming 1.1000000000000001

      How to replicate

      Create an Excel document

      Write "Field" on A1 (column title)

      Write 1.1 on A2 (the data)

      Save as xlsx

      Convert this file with FileMaker Pro using Open command

      Workaround (if any)

      Save as "text" instead of xlsx

       

      I tested Office 2011 and Office 2016

      For Windows 7 testing, i was running Parallel Desktop 10.3.0

      My regional settings are standard French (Switzerland)

      The results are similar when using the import command or script step in a existing database

      Both Sample files attached.