Skip Menu | 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

Owner: Nobody in particular
Requestors: markd7 [...]

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 [...]
From: mark dewhirst <markd7 [...]>
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 infrastructure.

Please report any issues with to