AnsweredAssumed Answered

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

Question asked by intex on Jun 1, 2012
Latest reply on Jun 5, 2012 by philmodjunk

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

Outcomes