Subject: | Fwd: Perl module Spreadsheet::XLSX |
Date: | Wed, 7 Dec 2016 10:21:21 -0800 |
To: | bug-Spreadsheet-XLSX [...] rt.cpan.org |
From: | Pete Lancashire <pete [...] petelancashire.com> |
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
Message body not shown because it is not plain text.
Message body not shown because it is not plain text.
Message body is not shown because sender requested not to inline it.
Message body is not shown because sender requested not to inline it.