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.
Thanks.
--
smu johnson <smujohnson@gmail.com>