Fails to calculate INDEX() function about phpspreadsheet HOT 6 CLOSED

It's different from that issue. I'll submit a report for that one coz it's still occurring in this package. Then, i'll drop a PR for fix on both issues.

from phpspreadsheet.

Turns out, $arrayValues passed to INDEX method is a 2 level array which is causing the issue.

array (size=1)
  0 => 
    array (size=7)
      0 => string 'First' (length=5)
      1 => string 'Second' (length=6)
      2 => string 'Third' (length=5)
      3 => string 'Fourth' (length=6)
      4 => string 'Fifth' (length=5)
      5 => string 'Sixth' (length=5)
      6 => string 'Seventh' (length=7)

from phpspreadsheet.

You are probably experiencing the same issue as PHPOffice/PHPExcel#1091. If you are able to provide a PR to solve it, that would very much appreciated.

from phpspreadsheet.

There appears to be a breakage when I pulled the latest dev copy. Not sure which commit caused this. Now the $arrayValues only recieved the last element. My fix no longer works because of this.

array (size=1)
  0 => string 'Seventh' (length=7)

from phpspreadsheet.

I will take a look, and understand the issue, and see if I can fix it

from phpspreadsheet.

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

from phpspreadsheet.