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: 71619
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX

People
Owner: Nobody in particular
Requestors: markd7 [...] internode.on.net
Cc:
AdminCc:

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



Subject: two secret formats for dates
Date: Wed, 12 Oct 2011 18:13:38 +1100
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: mark dewhirst <markd7 [...] internode.on.net>
Download (untitled) / with headers
text/plain 500b
Hi Dmitry Thank you for putting this together, you've saved me days of effort! It turns out that Microsoft excel in Excel 2007 zip-xls formats have two secret $formatCode for dates... both 14 and 15 All the other date formats seem to cause "proper" date format string (real members of @styles) so in Module Version: 0.13 the line... elsif ($t1 == 14){ $formatCode="m-d-yy";} simply needs to be... elsif ($t1 == 14 || $t1 == 15 ){ $formatCode="m-d-yy";} Cheers Mark


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.