Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.9.4

Bug #2425 Error using writeFormula with Now() and TODAY()
Submitted: 2004-09-30 20:10 UTC
From: casep at tuxpan dot com Assigned: xnoguer
Status: Closed Package: Spreadsheet_Excel_Writer
PHP Version: 4.3.8 OS: Windows 2000
Roadmaps: (Not assigned)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 31 + 13 = ?

 
 [2004-09-30 20:10 UTC] casep at tuxpan dot com
Description: ------------ IF I try to insert NOW() or TODAY() as formula there is an error creating the excel. Reproduce code: --------------- <?php require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer(); $worksheet =& $workbook->addWorksheet('Sheet1'); $workbook->send('test.xls'); $worksheet->writeFormula(0, 0, '=NOW()'); $workbook->close(); ?> Expected result: ---------------- The excel file with a cell with =NOW() as content Actual result: -------------- Notice: Undefined variable: result in C:\PHP\www\Spreadsheet\Excel\Writer\Parser.php on line 1643 Warning: Cannot modify header information - headers already sent by (output started at C:\PHP\www\Spreadsheet\Excel\Writer\Parser.php:1643) in C:\PHP\www\Spreadsheet\Excel\Writer.php on line 67 After several Warning lines there is some kind of excel file on the web page... Warning: Cannot modify header information - headers already sent by (output started at C:\PHP\www\Spreadsheet\Excel\Writer\Parser.php:1643) in C:\PHP\www\Spreadsheet\Excel\Writer.php on line 71 ÐÏࡱá ...

Comments

 [2005-11-12 04:15 UTC] xnoguer at php dot net
This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.