11 Replies Latest reply on Jun 5, 2012 10:00 AM by philmodjunk

    Wrong import of numbers with one decimal from Excel to FileMaker - Severe bug !!!

    intex

      Summary

      Wrong import of numbers with one decimal from Excel to FileMaker - Severe bug !!!

      Product

      FileMaker Pro

      Version

      12 Pro and Advanced

      Operating system version

      Mac OS X 10.7.3 and on 10.6.8

      Description of the issue

      Import of a table in xlsx format goes wrong with importing of numbers like

      1029,6

      You get

      1029,5999999

      in FileMaker instead

      Steps to reproduce the problem

      Have a table in Excel with a column formatted as currency with at least one row containing

      1029,6

      Import that in FileMaker and you get

      1029,59999999

      I can provide sample Excel file and FileMaker file

      Expected result

      of course

      1029,6

      shouldn´t be changed to

      1029,59999999

      Actual result

      1029,59999999

      Exact text of any error message(s) that appear

      None

      Configuration information

      Normal iMac with 10.7.4 Lion standard

      Workaround

      Export and import via text format and reformatting the currency column as numbers

      excel_import_bug.png