jman Report post Posted September 5, 2013 I am using Excel as my data provider and I am doing a calculation to get a percentage. I am formatting the field as a number with one decimal place. Excel Value - "0.7" When I connect to this workbook and view that data, it returns as a long whole number. Value in Collabion - "69139467010870616" See attached captures. Thanks! Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 5, 2013 Hi, Could you please share a sample Excel file so that we can check? Share this post Link to post Share on other sites
jman Report post Posted September 5, 2013 How can I upload the file if I'm not permitted to upload xslx or xsl files? Can I email the file to you? Thanks! Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 5, 2013 Hi, You can either compress it to zip and attach with your post in forum or send it to [email protected] Share this post Link to post Share on other sites
jman Report post Posted September 5, 2013 Data.zipOK, here is the sample file. Thanks, Justin Mease Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 6, 2013 Thanks Justin, We were able to replicate the issue. The fix will be available with next minor release. Share this post Link to post Share on other sites
jman Report post Posted September 6, 2013 Great, thanks for your help! Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 6, 2013 Hi, For a workaround you can configure the number formatting option available in the wizard. Please refer to the attached image. Share this post Link to post Share on other sites
Rahul Kumar Report post Posted September 27, 2013 Hi Justin, We have released the updated version v1.1.6.0 with the fix. Could you please download and check? Share this post Link to post Share on other sites
