{"action":"created","issue":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/1091","repository_url":"https://api.github.com/repos/PHPOffice/PHPExcel","labels_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/1091/labels{/name}","comments_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/1091/comments","events_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/1091/events","html_url":"https://github.com/PHPOffice/PHPExcel/issues/1091","id":196970273,"number":1091,"title":"Excel function index always returns #value!","user":{"login":"christian-06","id":24700785,"avatar_url":"https://avatars.githubusercontent.com/u/24700785?v=3","gravatar_id":"","url":"https://api.github.com/users/christian-06","html_url":"https://github.com/christian-06","followers_url":"https://api.github.com/users/christian-06/followers","following_url":"https://api.github.com/users/christian-06/following{/other_user}","gists_url":"https://api.github.com/users/christian-06/gists{/gist_id}","starred_url":"https://api.github.com/users/christian-06/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/christian-06/subscriptions","organizations_url":"https://api.github.com/users/christian-06/orgs","repos_url":"https://api.github.com/users/christian-06/repos","events_url":"https://api.github.com/users/christian-06/events{/privacy}","received_events_url":"https://api.github.com/users/christian-06/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-12-21T16:08:23Z","updated_at":"2016-12-22T11:07:12Z","closed_at":"2016-12-21T16:56:18Z","body":"System: Nginx with PHP7.0.14, PHPExcel V1.8\r\nExcel-Template:\r\n![screenshot from 2016-12-21 17-00-09](https://cloud.githubusercontent.com/assets/24700785/21396056/201b179a-c79f-11e6-93b2-edaecbe8e3f5.png)\r\nResult in PHPExcel for A10 is \"**#VALUE!**\"\r\nWhat I'm doing wrong?\r\nCorrect would be \"**AT3456**\""},"comment":{"url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/comments/268777687","html_url":"https://github.com/PHPOffice/PHPExcel/issues/1091#issuecomment-268777687","issue_url":"https://api.github.com/repos/PHPOffice/PHPExcel/issues/1091","id":268777687,"user":{"login":"christian-06","id":24700785,"avatar_url":"https://avatars.githubusercontent.com/u/24700785?v=3","gravatar_id":"","url":"https://api.github.com/users/christian-06","html_url":"https://github.com/christian-06","followers_url":"https://api.github.com/users/christian-06/followers","following_url":"https://api.github.com/users/christian-06/following{/other_user}","gists_url":"https://api.github.com/users/christian-06/gists{/gist_id}","starred_url":"https://api.github.com/users/christian-06/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/christian-06/subscriptions","organizations_url":"https://api.github.com/users/christian-06/orgs","repos_url":"https://api.github.com/users/christian-06/repos","events_url":"https://api.github.com/users/christian-06/events{/privacy}","received_events_url":"https://api.github.com/users/christian-06/received_events","type":"User","site_admin":false},"created_at":"2016-12-22T11:07:12Z","updated_at":"2016-12-22T11:07:12Z","body":"`<?php\r\nerror_reporting(E_ALL);\r\nini_set('display_errors', true);\r\nrequire_once 'PHPExcel-1.8/Classes/PHPExcel.php';\r\n\r\n$objPHPExcel = new PHPExcel();\r\n$objPHPExcel->setActiveSheetIndex(0)\r\n            ->setCellValue('A1', 'Title 1')->setCellValue('B1', 'AT1234')\r\n            ->setCellValue('A2', 'Title 2')->setCellValue('B2', 'AT3456')\r\n            ->setCellValue('A3', 'Title 3')->setCellValue('B3', 'AT5678')\r\n            ->setCellValue('A4', 'Title 4')->setCellValue('B4', 'AT8875')\r\n            ->setCellValue('A5', 'Title 5')->setCellValue('B5', 'AT5457')\r\n            ->setCellValue('A7', '2')      ->setCellValue('B7', '=INDEX(A1:B5,A7,2)');\r\n            // In Excel, parameters must be per ; separated here by ,\r\n\r\nvar_dump($objPHPExcel->getActiveSheet()->getCell('B7')->getValue()); # Return String '=INDEX(A1:C5,A7,2)'\r\nvar_dump($objPHPExcel->getActiveSheet()->getCell('B7')->getCalculatedValue()); # Return String '#VALUE!'\r\n?>`\r\n\r\nExample without xlsx file purely created in code, comes to the same error.\r\nWhat am I doing wrong?\r\nI think the error in file \"PHPExcel / Calculation / LookupRef.php\" found in line 635?\r\nAn array is compare to an integer value\r\nArray > int"}}
{"actor":{"display_login":"christian-06"}}