iliaal/php_excel — Issue #20: ExcelBook::packDate doesn't work for negative timestamps
Author: dahjelle
Created: 2011-12-09 21:23:46+00:00
State: open

I was using ExcelBook::packdate( strtime( "mm-dd-yyyy" ) ); to create dates in my Excel files; however, it did not work properly for any dates before the UNIX epoch. Simply setting the cell to a numeric value computed from the formulas at http://www.massyn.net/?p=17 and setting the format of the cell worked fine, however.

I see the the C source code is filtering out everything that is below 1, but I don't know enough about PHP extensions to understand what is going on.

Thanks for your work!