AnsweredAssumed Answered

Bug in import from Excel

Question asked by manjit on Feb 17, 2014
Latest reply on Feb 18, 2014 by mikebeargie

Hi

 

Since from a long time development in Filemaker I am facing a strange issue while importing data from an excel file to my Filemaker application. In the excel (.xls/.xlsx) the data are showing correct (e.g. 1.1524) which is entered by me but when it get imported into Filemaker its showing a different value (e.g. 1.1524000000000001).

 

This issue was not showing if I do import for same data using CSV file into Filemaker.  I have tried a lot by removing all type of formatting from the excel file even I made the column to text still on import the data in Filemaker is showing wrong data. Is there anybody faced the same issue and got any solution please share with me.

 

 

Thanks,

Manjit

Attachments

Outcomes