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

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)



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>
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
Download Book1.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 8.3k

Message body not shown because it is not plain text.

Download test
application/octet-stream 919b

Message body not shown because it is not plain text.

Download XLSX.pm
text/x-perl 10.5k

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

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.