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

Report information
The Basics
Id:
119170
Status:
new
Priority:
Low/Low

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



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.



This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.