| 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: | |
| 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 |
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 |
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 |
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 |
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 |
Message body is not shown because sender requested not to inline it.