Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Issue while reading decimal number from a Spreadsheet using perl

by syphilis (Bishop)
on Oct 21, 2019 at 08:28 UTC ( #11107750=note: print w/replies, xml ) Need Help??


in reply to Issue while reading decimal number from a Spreadsheet using perl

In reading the numbers back, they are being rounded to 18 decimal digits of precision:
use warnings; for(10.1, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9) { printf "%.18g\n", $_; } __END__ Outputs: 10.0999999999999996 10.1999999999999993 10.3000000000000007 10.4000000000000004 10.5 10.5999999999999996 10.6999999999999993 10.8000000000000007 10.9000000000000004
I don't know why that is happening or how to influence the result, but you clearly want those numbers to be rounded to 3 decimal digits of precision:
use warnings; for(10.1, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9) { printf "%.3g\n", $_; } __END__ Outputs: 10.1 10.2 10.3 10.4 10.5 10.6 10.7 10.8 10.9
Cheers,
Rob

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11107750]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (5)
As of 2019-12-10 09:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?