Skip Menu |
 

This queue is for tickets about the Spreadsheet-XLSX CPAN distribution.

Report information
The Basics
Id: 117166
Status: open
Priority: 0/
Queue: Spreadsheet-XLSX

People
Owner: Nobody in particular
Requestors: ken.prows [...] online-rewards.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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>
Download (untitled) / with headers
text/plain 584b
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
Download (untitled) / with headers
text/plain 112b
I can confirm this report. This severely breaks existing code that expects dates to be unformatted/numerical.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.