in reply to Re^2: Spreadsheet::Read module is rounding the decimals in XLSX file
in thread Spreadsheet::Read module is rounding the decimals in XLSX file

But how come the same piece of code is giving me .9888 in the other environment. Also you could see that the unformatted value is '0.98880000000000001' (raw data). How can i extract this 0.9888 from that?

See http://floating-point-gui.de/ for the 0000000000001 part. Apart from that, if you want a certain precision, use sprintf, as you were told in other replies.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
  • Comment on Re^3: Spreadsheet::Read module is rounding the decimals in XLSX file
  • Download Code

In Section Seekers of Perl Wisdom