Description: ------------ Before starting, many thanks to the team for this very useful package. I want to insert the following formula : =AVERAGE(IF(C35:F35<>0;C35:F35)) When I open the xls file I get an error : "VALUE!" But if I manually modify the formula (just erase the bracket and insert it again) and press SHIFT-CTRL-ENTER, everything is ok. So the syntax of the formula is ok but Excel does not recognize this array formula.

Same problem for me, using SUBTOTAL as function produces VALUE! error, but editing formula with F2 and pressing enter gives correct result. System: Windows 2003 Excel 2003 I remember having this problem some releases ago, but it somehow disappeared with the latest version, now it's up again. Maybe some whitespace character / line break or other things ? Thanks a lot for this very usefull package. Florian

This is the issue with three different range classes. Support has to be ported from Perl version into PHP version.

I'm having the same problem as Florian. System: Windows 2003 Formula: SUBTOTAL Excel: 2003 / 2007 Beta 2 I can't find any work around so I have to do some calculations directly in PHP and print the result without the formula. Do you except to solve this in a near futur version? Thank you for this great package.

Found a solution to my problem here. http://pear.php.net/bugs/bug.php?id=1730 Thx

Same problem here with COUNTIF using MS Office 2003 SP3 (Openoffice.org seems to work). When I open the generated file I see an error "#Value!" in the field. If I doubleclick on it an just hit return Excel calculates right. I had a look a the Perl module, but the definition seem right to me, so http://pear.php.net/bugs/bug.php?id=1730 doesn't help. BTW: Is there still some working on the module?

Script test : require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer(); $worksheet =& $workbook->addWorksheet('whatever'); $worksheet->write(34, 2, '18'); $worksheet->write(34, 5, '19'); $worksheet->write(8, 0, '=AVERAGE(IF(C35:F35<>0;C35:F35)) ',''); $workbook->close(); $workbook->send('test'.date('His').'.xls');