http://www.perlmonks.org?node_id=761583


in reply to Re^3: Why Does the Module(s) Round off to 2 Decimal Places?
in thread Why Does the Module(s) Round off to 2 Decimal Places?

The change you've made appears to apply default formatting (i.e. ignoring the specified format for the cell), whereas the change I proposed to xls2csv (earlier reply) pulls the unformatted value as stored in the xlsx file.

Personally, I'd change my local xls2csv sub, to avoid surprises in other uses of Spreadsheet::XLSX.

  • Comment on Re^4: Why Does the Module(s) Round off to 2 Decimal Places?