Usage of Excel formulas entered by CRTL+SHIFT+ENTER

Topics: Developer Forum, User Forum
Aug 15, 2012 at 5:34 PM

Is there any way of "Array-Entered Formulas" usage in PHPExcel?

Like described here: http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=103

Copy-n-past 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.

Aug 15, 2012 at 6:48 PM

Thanks for the info.