Fred(CH)

Excel importation may misinterpret fractional numbers

Discussion created by Fred(CH) on Jan 28, 2016
Latest reply on Feb 1, 2016 by 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.

Outcomes