Subject: | Decimal format being ignored in Excel file |
Date: | Tue, 20 Jan 2015 12:59:02 -0800 |
To: | bug-Spreadsheet-XLSX@rt.cpan.org |
From: | smu johnson <smujohnson@gmail.com> |
Hi,
The usual behaviour of the classic Spreadsheet::ParseExcel would take into account that the Excel file had decimal formatting, ie, 2 decimal places, and treat that way, e.g., 14.00, even if "14" was entered into the spreadsheet.Spreadsheet-XLSX on the other hand just shows the raw value, 14, and ignores the decimal formatting attribute on the cell / column, etc.