getCalculatedValue() return 0

Topics: Developer Forum, User Forum
Sep 30, 2009 at 3:17 PM
Hello, this work (sum of different cell of different sheets)
$objPHPExcel->getActiveSheet()->getCell("D21")->getValue();
 return SUM('FilEau LF'!D25+'FilEau CDH'!D21+'FilEau Sab'!D21+'FilEau Cant'!D21+'FilEau Lille'!D21+'FilEau CD10'!D21+'FilEau Mel'!D21)
but

$objPHPExcel->getActiveSheet()->getCell("D21")->getCalculatedValue();
no work, return 0

any help please

marc
Developer
Sep 30, 2009 at 3:30 PM

Hmm.. This is strange. I will make a bug report.

Developer
Sep 30, 2009 at 3:42 PM

Issue created:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=10708

Coordinator
Sep 30, 2009 at 4:25 PM

Cause of the bug identified. Fix will be checked into SVN this evening

Oct 1, 2009 at 8:47 AM

What does it mean ?
There will have a correction ?

I've tried with the version 1.6.7. I have the same problem..

(Congratulations for your work)

Marc

Coordinator
Oct 1, 2009 at 9:01 AM

It means that there is a correction/fix in the latest code. This will be included in the 1.7.1 release.

However, you can download the latest source code from: http://phpexcel.codeplex.com/SourceControl/ListDownloadableCommits.aspx if you want access to the fix now.