Skip Menu |
 
Update: The rt.cpan.org bug tracker service is no longer shutting down.

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

Report information
The Basics
Id: 119170
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX

People
Owner: Nobody in particular
Requestors: pete [...] petelancashire.com
Cc:
AdminCc:

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



MIME-Version: 1.0
In-Reply-To: <CAA-F0u8RwYboDw=iWEfcnkwEOVQ0+yVhULLhBF-aLE3hDc6e+Q [...] mail.gmail.com>
X-Spam-Status: No, score=-2.598 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7] autolearn=ham
X-Spam-Flag: NO
X-Virus-Checked: Checked
References: <CAA-F0u8RwYboDw=iWEfcnkwEOVQ0+yVhULLhBF-aLE3hDc6e+Q [...] mail.gmail.com>
Content-Type: multipart/mixed; boundary="001a1141cae87fd88b05431596b9"
Message-ID: <CAA-F0u_1Pa-kBqZnW+b4yWRs963zGWhxko+YV=ukNDFiusNnFg [...] mail.gmail.com>
X-Received: by 10.157.22.205 with SMTP id s13mr37196522ots.234.1481134881869; Wed, 07 Dec 2016 10:21:21 -0800 (PST)
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -2.598
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id E959C2401F9 for <cpan-bug+Spreadsheet-XLSX [...] hipster.bestpractical.com>; Wed, 7 Dec 2016 13:21:38 -0500 (EST)
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 EqS1xB2s8XDZ for <cpan-bug+Spreadsheet-XLSX [...] hipster.bestpractical.com>; Wed, 7 Dec 2016 13:21:37 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id B137A2400EF for <bug-Spreadsheet-XLSX [...] rt.cpan.org>; Wed, 7 Dec 2016 13:21:36 -0500 (EST)
Received: (qmail 16320 invoked by alias); 7 Dec 2016 18:21:36 -0000
Received: from mail-oi0-f41.google.com (HELO mail-oi0-f41.google.com) (209.85.218.41) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 07 Dec 2016 10:21:27 -0800
Received: by mail-oi0-f41.google.com with SMTP id b126so426276981oia.2 for <bug-Spreadsheet-XLSX [...] rt.cpan.org>; Wed, 07 Dec 2016 10:21:25 -0800 (PST)
Received: by 10.202.188.87 with HTTP; Wed, 7 Dec 2016 10:21:21 -0800 (PST)
Authentication-Results: hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] gmail.com
Delivered-To: cpan-bug+Spreadsheet-XLSX [...] hipster.bestpractical.com
Subject: Fwd: Perl module Spreadsheet::XLSX
Return-Path: <xyzzypdx [...] gmail.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=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:from:date:message-id :subject:to; bh=uvbw8wnhD+wQhl6EEasf2p5vvfz/B0OcCZxegkJpmbA=; b=KlAnuXLWh4Tv2T0ksbQCBirVfuuPd4HSPGs2es+p8QPsfWm5hmWOZlSymLEYcWPjHK Hix0FpnFV/VL1kEI4sorw44w2gUMxvjbDeIJr140RCpzAfqBP/IXm8nZK0VKPNd4soCP 9BpRqphU0Y2dlfJKWZz7LSGlkVJQmhsN34cavdm/aVSpQr2nk/PSgrE6FTjVBCiMgcuN 964J7m4REnlxTIjLBE/ZNt+nH6H7c6n+9ct2e4yZTmMgSooCHhwY1MIK8xgESbmxwAnw SzfaTj3D0e+oh5J6fQTZTWs1PL4qsqguaRiTC0+yElWtQExZ8jXC+26h7m7j1JoItNvR A1sA==
X-Google-Sender-Auth: ugKJj_0Pv_FNj8zH7nAj2EC-z20
X-Google-Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:sender:in-reply-to:references:from :date:message-id:subject:to; bh=uvbw8wnhD+wQhl6EEasf2p5vvfz/B0OcCZxegkJpmbA=; b=E1pgX6/VoEdQOS2xvokVO3gpY4QLUvK/RiNVNGASIUJXRNR+7o76um0xARuK1CbF2m t3INp8QXfRn9nwrSHRUPe35wVVH3A5vDHln/xBnS8L51U88se2rm2AGNMJlHlZfVf3FV DJjlCispWycc47yWkr1c3vxtNpUSM26jHPWVwuo5z26SSwDWAt+SVEtU+wZTBZnT7H1b KWwjMVW+v8R1wR0WQ3qnKjSuJ/+ENVaTJl+aMnQh7ylMMbYM5vQdaCdxEK6JmUkXBl+a WF8B+kwTdpTPO4Ox5twhgVge1/FmMfAacoaLv/qKwLIQ67WJj83+0LOh2UgpOQb54qCK NgcQ==
Date: Wed, 7 Dec 2016 10:21:21 -0800
Sender: xyzzypdx [...] gmail.com
X-Spam-Level:
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: Pete Lancashire <pete [...] petelancashire.com>
X-GM-Message-State: AKaTC01cObfAhlPS2MbCosX3dEN66RCjd9ysGPg5O905Q2EML3Y7IKGTS31vJTNenT5Sg73vsFxXKPckNA6rfQ==
X-RT-Interface: Email
Content-Length: 0
Content-Type: multipart/alternative; boundary="001a1141cae87fd88605431596b7"
Content-Length: 0
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
Content-Length: 1129
Download (untitled) / with headers
text/plain 1.1k
Data and Time cell types are not correctly extracted in version 0.15. They are correctly extracted in version 0.13. The version of Excel I am using is 2016 MSO (16.0.6701.1041) 32-bit With XLXS.pm version 0.13 it correctly extracts the data and time data types Sheet: Sheet1 ( 0 , 0 ) => format general ( 0 , 1 ) => format text ( 0 , 2 ) => format number ( 0 , 3 ) => format date ( 0 , 4 ) => format time ( 1 , 0 ) => some stuff ( 1 , 1 ) => some test ( 1 , 2 ) => 123 ( 1 , 3 ) => 42736 ( 1 , 4 ) => 42736.523611111108 With version 0.15 it does not, it does not detect the cell type being date or time Sheet: Sheet1 ( 0 , 0 ) => format general ( 0 , 1 ) => format text ( 0 , 2 ) => format number ( 0 , 3 ) => format date ( 0 , 4 ) => format time ( 1 , 0 ) => some stuff ( 1 , 1 ) => some test ( 1 , 2 ) => 123 ( 1 , 3 ) => 2017-01-01 ( 1 , 4 ) => 12:34:00 AM/PM Attached test - Perl program to demonstrate the issue (almost a copy of your sysnopis example) Book1.xlsx - Microsoft Excel file for testing XLSX.pm - The perl module I have for version 0.15 XLSX13.pm - The perl module I have for version 0.13 Regards -pete
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 1843
X-Attachment-ID: f_iwf8oynw0
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; name="Book1.xlsx"
Content-Disposition: attachment; filename="Book1.xlsx"
Content-Transfer-Encoding: base64
Content-Length: 8572
Download Book1.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 8.3k

Message body not shown because it is not plain text.

X-Attachment-ID: f_iwf8r61q1
Content-Type: application/octet-stream; name="test"
Content-Disposition: attachment; filename="test"
Content-Transfer-Encoding: base64
Content-Length: 919
Download test
application/octet-stream 919b

Message body not shown because it is not plain text.

X-Attachment-ID: f_iwf8uxt82
Content-Type: application/octet-stream; name="XLSX.pm"
Content-Disposition: attachment; filename="XLSX.pm"
Content-Transfer-Encoding: base64
Content-Length: 10835
Download XLSX.pm
text/x-perl 10.5k

Message body is not shown because sender requested not to inline it.

X-Attachment-ID: f_iwf8uxtd3
Content-Type: application/octet-stream; name="XLSX13.pm"
Content-Disposition: attachment; filename="XLSX13.pm"
Content-Transfer-Encoding: base64
Content-Length: 8411
Download XLSX13.pm
text/x-perl 8.2k

Message body is not shown because sender requested not to inline it.



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.