Skip Menu |

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)

History Show all quoted text
  Wed Oct 12 03:12:54 2011 markd7 [...] internode.on.net - Ticket created
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>
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