Re^3: Spreadsheet::Read module is rounding the decimals in XLSX file

"Also you could see that the unformatted value is '0.98880000000000001' (raw data). How can i extract this 0.9888 from that?"

In Re: Spreadsheet::Read module is rounding the decimals in XLSX file, I provided:

A fully functional script.
The output from that script.
Links to documentation.
Advice on issues should you choose a different, but closely related, function.

My apologies. Clearly that wasn't sufficient, free work for you!

If, at some point, you want to extract a digit and change 0.9888 to 0.98880000000000001 in my code, you'll find out for yourself. If you're too lazy to do that, stay ignorant!

-- Ken

Comment on Re^3: Spreadsheet::Read module is rounding the decimals in XLSX file Select or Download Code

Replies are listed 'Best First'.
Re^4: Spreadsheet::Read module is rounding the decimals in XLSX file by char_perl (Initiate) on Jun 24, 2015 at 10:15 UTC
Hi Ken, Its not about the precisions missing. My point is why the same Read.pm is working in one environment and not working in other with the same code, same input file and same libraries? I need to know what settings(excel attributes) are missing in these two environments. We can write some customization to play with precision values, but, if you compare both the hashes, why is one environment referring to raw data and the other is printing out the exact value in xlsx file?	[reply]

Replies are listed 'Best First'.

Re^4: Spreadsheet::Read module is rounding the decimals in XLSX file
by char_perl (Initiate) on Jun 24, 2015 at 10:15 UTC

Its not about the precisions missing. My point is why the same Read.pm is working in one environment and not working in other with the same code, same input file and same libraries? I need to know what settings(excel attributes) are missing in these two environments. We can write some customization to play with precision values, but, if you compare both the hashes, why is one environment referring to raw data and the other is printing out the exact value in xlsx file?

[reply]