
Is there any way of "ArrayEntered Formulas" usage in PHPExcel?
Like described here:
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=103
Copynpast from stated above page:
Click into cell A12 and type this formula and when you are finished typing, hit ctrl+shift+enter:
=SUM((A2:A11>500)*(A2:A11))+SUM((A2:A11<300)*(A2:A11))
You will see that you get $9800 as a result and this is correct. And, if you look at the formula in the Formula Bar at the top of your spreadsheet, you will see that Excel added the curly brackets to the formula and it looks like this:
{=SUM((A2:A11>500)*(A2:A11))+SUM((A2:A11<300)*(A2:A11))}


Coordinator
Aug 15, 2012 at 5:44 PM

On the TODO list, but not yet implemented  there's a number of changes I need to make to the cell structure to facilitate array formula handling, and changes to some of the existing methods. The first step is deprecation of a couple of methods which is
planned for this weekend's release. Second step is the changes to methods for setting/getting formulae/values, together with some additions to the cell properties to map array formula references for the 1.7.9 release (probably in October). Then there's a major
rewrite of the calculation engine to follow, so it will be early next year before PHPExcel can fully handle array formulae.



Thanks for the info.

