Skip Menu | will be shut down on March 1st, 2021.

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

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

Owner: Nobody in particular
Requestors: ken.prows [...]

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 [...]
From: Ken Prows <ken.prows [...]>
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 infrastructure.

Please report any issues with to