{"action":"created","issue":{"url":"https://api.github.com/repos/burnash/gspread/issues/503","repository_url":"https://api.github.com/repos/burnash/gspread","labels_url":"https://api.github.com/repos/burnash/gspread/issues/503/labels{/name}","comments_url":"https://api.github.com/repos/burnash/gspread/issues/503/comments","events_url":"https://api.github.com/repos/burnash/gspread/issues/503/events","html_url":"https://github.com/burnash/gspread/issues/503","id":297899943,"number":503,"title":"inserting cell.input_value returns '#NAME?'","user":{"login":"Grisolfi","id":24906727,"avatar_url":"https://avatars1.githubusercontent.com/u/24906727?v=4","gravatar_id":"","url":"https://api.github.com/users/Grisolfi","html_url":"https://github.com/Grisolfi","followers_url":"https://api.github.com/users/Grisolfi/followers","following_url":"https://api.github.com/users/Grisolfi/following{/other_user}","gists_url":"https://api.github.com/users/Grisolfi/gists{/gist_id}","starred_url":"https://api.github.com/users/Grisolfi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Grisolfi/subscriptions","organizations_url":"https://api.github.com/users/Grisolfi/orgs","repos_url":"https://api.github.com/users/Grisolfi/repos","events_url":"https://api.github.com/users/Grisolfi/events{/privacy}","received_events_url":"https://api.github.com/users/Grisolfi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-02-16T19:48:19Z","updated_at":"2018-03-11T23:35:22Z","closed_at":null,"author_association":"NONE","body":"\r\nI am having an issue with `cell.input_value `\r\n\r\n### Environment info\r\nOperating System: Linux 4.9.0-4-amd64 #1 SMP Debian 4.9.65-3 (2017-12-03) x86_64 unknown unknown GNU/Linux\r\nPython version: Python 3.5.3\r\ngspread version: gspread==0.6.2\r\n\r\n### Steps to reproduce\r\n1. get a range of cells e.g. `cell_list`\r\n2. loop over cell_list\r\n ```python\r\nfor cell in cell_list:\r\n    cell.input_value = '=HIPERLINK(\"http://google.com.br\";\"Google\")'\r\n```\r\n3. update cells\r\n`worksheet.update_cells(cell_list)`\r\n4. check in the spreadsheet for \"#NAME?\"\r\n5. if a hit the cell in chrome and edit the cell with the same text, the link appears =\\\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/burnash/gspread/issues/comments/372159937","html_url":"https://github.com/burnash/gspread/issues/503#issuecomment-372159937","issue_url":"https://api.github.com/repos/burnash/gspread/issues/503","id":372159937,"user":{"login":"burnash","id":264674,"avatar_url":"https://avatars0.githubusercontent.com/u/264674?v=4","gravatar_id":"","url":"https://api.github.com/users/burnash","html_url":"https://github.com/burnash","followers_url":"https://api.github.com/users/burnash/followers","following_url":"https://api.github.com/users/burnash/following{/other_user}","gists_url":"https://api.github.com/users/burnash/gists{/gist_id}","starred_url":"https://api.github.com/users/burnash/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/burnash/subscriptions","organizations_url":"https://api.github.com/users/burnash/orgs","repos_url":"https://api.github.com/users/burnash/repos","events_url":"https://api.github.com/users/burnash/events{/privacy}","received_events_url":"https://api.github.com/users/burnash/received_events","type":"User","site_admin":false},"created_at":"2018-03-11T23:35:22Z","updated_at":"2018-03-11T23:35:22Z","author_association":"OWNER","body":"Thanks for reporting this. \r\n\r\nI've just released a new gspread version. It uses API v4 and it's possible that this issue is fixed in a new API. Can you try to upgrade gspread  to the latest version and see if it fixes the issue?\r\n\r\nThe API has changed slightly, Sheets API is no longer using `inputValue`, so I dropped it in gspread as well. Your code will look like this:\r\n\r\n```python\r\nfor cell in cell_list:\r\n   cell.value = '=HIPERLINK(\"http://google.com.br\";\"Google\")'    # <-- no input_value\r\nworksheet.update_cells(cell_list)\r\n```"}}
{"actor":{"display_login":"burnash"}}