Bug #7504

Formulas problems

Details

Submitted	2006-04-27 14:49 UTC
From	admin at confort-it dot com
Status	Verified
Package	Spreadsheet_Excel_Writer
PHP Version	5.1.0
OS	FEDORA core 4
Roadmaps	(Not assigned)

Comments

[2006-04-27 14:49 UTC] admin at confort-it dot com

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.

[2006-05-29 16:21 UTC] florian dot schaeffer at mercoline dot de

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

[2006-10-06 08:04 UTC] tuupola at php dot net

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

[2006-10-19 19:04 UTC] vpoitras at dialektelecom dot ca

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.

[2006-10-19 19:53 UTC] vpoitras at dialektelecom dot ca

Found a solution to my problem here.

http://pear.php.net/bugs/bug.php?id=1730

Thx