setNumFormat problem with Spreadsheet_Excel_Writer (formatting dates)

From: Date: Mon, 08 Dec 2003 09:35:08 +0000
Subject: setNumFormat problem with Spreadsheet_Excel_Writer (formatting dates)
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-9356@lists.php.net to get a copy of this message
Hi, after a few tries I managed to use Spreadsheet_Excel_Writer for my purposes. Everything works fine so far except the formatting of dates. For example if I define $format_date->setNumFormat('DD.MM.YYYY'); and later I write to the spreadsheet $worksheet->write(2, 2, '31.01.2003',$format_date); then the date formatting looks correct in excel (when viewing the properties of the cell). But if I compare the dates in a given list with some date in order to show earlier or later events nothing is displayed... Only after reentering the dates _manually_ the cells seem to apply the format. Then the comparison works. Does anybody know a solution? Stefan

« previous php.pear.general (#9356) next »