{"action":"closed","issue":{"url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/439","labels_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/439/labels{/name}","comments_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/439/comments","events_url":"https://api.github.com/repos/Maatwebsite/Laravel-Excel/issues/439/events","html_url":"https://github.com/Maatwebsite/Laravel-Excel/issues/439","id":78108326,"number":439,"title":"Average Function showing wrong output with multiple sheet refrenace","user":{"login":"alpeshkasodariya","id":5284355,"avatar_url":"https://avatars.githubusercontent.com/u/5284355?v=3","gravatar_id":"","url":"https://api.github.com/users/alpeshkasodariya","html_url":"https://github.com/alpeshkasodariya","followers_url":"https://api.github.com/users/alpeshkasodariya/followers","following_url":"https://api.github.com/users/alpeshkasodariya/following{/other_user}","gists_url":"https://api.github.com/users/alpeshkasodariya/gists{/gist_id}","starred_url":"https://api.github.com/users/alpeshkasodariya/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alpeshkasodariya/subscriptions","organizations_url":"https://api.github.com/users/alpeshkasodariya/orgs","repos_url":"https://api.github.com/users/alpeshkasodariya/repos","events_url":"https://api.github.com/users/alpeshkasodariya/events{/privacy}","received_events_url":"https://api.github.com/users/alpeshkasodariya/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-05-19T14:20:58Z","updated_at":"2015-06-04T14:48:12Z","closed_at":"2015-06-04T14:48:12Z","body":"Hello,\r\nWe are facing issue on average function.We are using below like code with average function.\r\n\"  Excel::load('export.xls', function($excel) {\r\n       $excel->setActiveSheetIndex(0); \r\n       $excel->getActiveSheet()->setCellValue('A4', \"=AVERAGEA(sheet2!A3:sheet2!Q2)\"); \r\n  })->store('xls', storage_path('report'));\"\r\n\r\nWe are set \"AVERAGEA(sheet2!A3:sheet2!Q2)\" and xls output showing \"=AVERAGEA(sheet2!A3)\"\r\nso its getting wrong output. We need help regarding this issue.\r\nCould you please help us for?\r\n\r\nAny help will be appreciated.\r\n\r\nThanks\r\nAlpesh"}}