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)



MIME-Version: 1.0
X-Spam-Status: No, score=-2.599 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7] autolearn=ham
X-Spam-Flag: NO
Content-Type: multipart/alternative; boundary="001a114b1720c1127b053ac09147"
Message-ID: <CAOKSKv81YT7m4uRc8ei8Hv2J_4O9Wod8r+NHQtWMMmHzk-mxzQ [...] mail.gmail.com>
X-Received: by 10.28.223.9 with SMTP id w9mr22524111wmg.65.1471973637026; Tue, 23 Aug 2016 10:33:57 -0700 (PDT)
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -2.599
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 99E54240334 for <cpan-bug+Spreadsheet-XLSX [...] hipster.bestpractical.com>; Tue, 23 Aug 2016 13:34:09 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 6I4ohml-wmaH for <cpan-bug+Spreadsheet-XLSX [...] hipster.bestpractical.com>; Tue, 23 Aug 2016 13:34:08 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 2F712240305 for <bug-Spreadsheet-XLSX [...] rt.cpan.org>; Tue, 23 Aug 2016 13:34:07 -0400 (EDT)
Received: (qmail 8788 invoked by alias); 23 Aug 2016 17:34:07 -0000
Received: from mail-wm0-f49.google.com (HELO mail-wm0-f49.google.com) (74.125.82.49) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Tue, 23 Aug 2016 10:34:01 -0700
Received: by mail-wm0-f49.google.com with SMTP id o80so205450116wme.1 for <bug-Spreadsheet-XLSX [...] rt.cpan.org>; Tue, 23 Aug 2016 10:34:01 -0700 (PDT)
Received: by 10.28.214.71 with HTTP; Tue, 23 Aug 2016 10:33:16 -0700 (PDT)
Authentication-Results: hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] online-rewards-com.20150623.gappssmtp.com
Delivered-To: cpan-bug+Spreadsheet-XLSX [...] hipster.bestpractical.com
Subject: unformatted date values can no longer be retrieved
Return-Path: <ken.prows [...] online-rewards.com>
X-RT-Mail-Extension: spreadsheet-xlsx
X-Original-To: cpan-bug+Spreadsheet-XLSX [...] hipster.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=online-rewards-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=pwxVXtZ/a8rCaZ2+u/wcvhpoOny35JFDGSWIOymDjzk=; b=dAOC08M+LD9OfOlKzFJFMRGMm/JZor7LVkR0KYRh5itAmuMGqHD5PDh5iL5sYgoi64 gPHlF2hSbAmTUFImIkPOZxrDqgbbypC96ywCrWaU2ZEuV+dxGhdqX9UPFovnObyMr47K A4OzT1EDkZw1iwfRm9b/8DSnXlLuAoACVvag5x+nk4wRKQsBnhT3jTDQWtx/UpQY6TD/ 9XnD847mOxMSd30GjyAFkz+bWNnMD5796/WGfwd+hJ8nMxZ4Dv3FKdxQd6dN9UbsziEk Om/8lPs5EDT0Aasorm+qkPEc8IjvbWWamdMRVwxTU7OHRCizm1uUJAqHnFUrKW0zmv6p JEuw==
X-Google-Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=pwxVXtZ/a8rCaZ2+u/wcvhpoOny35JFDGSWIOymDjzk=; b=Erv1PogBMK/8pf1phYtufopgeYVvk+0EFlF0OWTepuYSOycgbp1eP91ThSm3C1YP4f PU/Ii3RDjmbdmqyXJV79DVcLfD3VSt7LllXYYnqG5peg1RGu3KNdfsD1RivjA9KNxwIJ v4sAAIn3R3yn0vr0zK7mJTUozFqS8969bZH5JIzHzD2xY3OR301ZFc3anBWKpGgv1KyK cMtglOrGJ8MKX6+VVDAhMGixl8mW2DWLbU6MifHdpCL1duAcEuzL7+1jPhx5a/3xivz8 gJ7tmXEGvdV7R1eEmNK0M0FH9J/LaK7/9+mmhMMTJfltRZ2okWZNHqFKN7JpU51JW3sQ A1Dw==
Date: Tue, 23 Aug 2016 13:33:16 -0400
X-Spam-Level:
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: Ken Prows <ken.prows [...] online-rewards.com>
X-GM-Message-State: AEkoouup7lHJNBx2kXc8UBWnzuGGdtonPf5q83oLVu7rCQLqbkXg4WtmBBrBZqzgY/OQeaSau59iLkV/e2qgNLg+
X-RT-Interface: Email
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 584
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
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 2083
MIME-Version: 1.0
In-Reply-To: <CAOKSKv81YT7m4uRc8ei8Hv2J_4O9Wod8r+NHQtWMMmHzk-mxzQ [...] mail.gmail.com>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <CAOKSKv81YT7m4uRc8ei8Hv2J_4O9Wod8r+NHQtWMMmHzk-mxzQ [...] mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-2126-1489595843-1951.117166-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 112
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.