| Subject: | unformatted date values can no longer be retrieved |
| Date: | Tue, 23 Aug 2016 13:33:16 -0400 |
| To: | bug-Spreadsheet-XLSX [...] rt.cpan.org |
| From: | Ken Prows <ken.prows [...] online-rewards.com> |
A recent change in Spreadsheet::XLSX made it so the unformatted value of a
date column cannot be retrieved. Both the formatted and unformatted value
for a date cell returns the formatted value.
It looks like this is due to the following code:
----
if ($type eq "Date") {
if ($v < 1) { #then this is Excel time field
$cell->{Type} = "Text";
}
$cell->{Val} = $cell->{_Value};
}
----
Could you please add a way to retrieve the unformatted date values again?
The formatted date value tends to be very unreliable when coming from a
client.
​Thanks!,
Ken