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

Report information
The Basics
Id:
117166
Status:
open
Priority:
Low/Low

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

BugTracker
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>

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

I can confirm this report. This severely breaks existing code that expects dates to be unformatted/numerical.


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

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