{"action":"created","issue":{"url":"https://api.github.com/repos/burnash/gspread/issues/504","repository_url":"https://api.github.com/repos/burnash/gspread","labels_url":"https://api.github.com/repos/burnash/gspread/issues/504/labels{/name}","comments_url":"https://api.github.com/repos/burnash/gspread/issues/504/comments","events_url":"https://api.github.com/repos/burnash/gspread/issues/504/events","html_url":"https://github.com/burnash/gspread/issues/504","id":298044690,"number":504,"title":"Unkown Function returning #NAME?","user":{"login":"Rodrigoaz7","id":27520422,"avatar_url":"https://avatars2.githubusercontent.com/u/27520422?v=4","gravatar_id":"","url":"https://api.github.com/users/Rodrigoaz7","html_url":"https://github.com/Rodrigoaz7","followers_url":"https://api.github.com/users/Rodrigoaz7/followers","following_url":"https://api.github.com/users/Rodrigoaz7/following{/other_user}","gists_url":"https://api.github.com/users/Rodrigoaz7/gists{/gist_id}","starred_url":"https://api.github.com/users/Rodrigoaz7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rodrigoaz7/subscriptions","organizations_url":"https://api.github.com/users/Rodrigoaz7/orgs","repos_url":"https://api.github.com/users/Rodrigoaz7/repos","events_url":"https://api.github.com/users/Rodrigoaz7/events{/privacy}","received_events_url":"https://api.github.com/users/Rodrigoaz7/received_events","type":"User","site_admin":false},"labels":[{"id":499570056,"url":"https://api.github.com/repos/burnash/gspread/labels/TTL","name":"TTL","color":"fef2c0","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-02-17T23:17:52Z","updated_at":"2018-03-12T13:31:29Z","closed_at":null,"author_association":"NONE","body":"Hello,\r\n\r\nI was just using some lines of code like this one: wks.update_acell('A1', formula), and had worked fine. but now I'm using a different formula =googlefinance(\"petr3\"; \"price\"; DIATRABALHO(HOJE();-10);HOJE()).\r\nBut the Sheet returnin the following error: \"unkown function DIATRABALHO\", but that function it's correct, even when I put the same formula directly into the sheet, it work fine. \r\n\r\nWhat can I do this work just using update_acell ??\r\n"},"comment":{"url":"https://api.github.com/repos/burnash/gspread/issues/comments/372310019","html_url":"https://github.com/burnash/gspread/issues/504#issuecomment-372310019","issue_url":"https://api.github.com/repos/burnash/gspread/issues/504","id":372310019,"user":{"login":"Rodrigoaz7","id":27520422,"avatar_url":"https://avatars2.githubusercontent.com/u/27520422?v=4","gravatar_id":"","url":"https://api.github.com/users/Rodrigoaz7","html_url":"https://github.com/Rodrigoaz7","followers_url":"https://api.github.com/users/Rodrigoaz7/followers","following_url":"https://api.github.com/users/Rodrigoaz7/following{/other_user}","gists_url":"https://api.github.com/users/Rodrigoaz7/gists{/gist_id}","starred_url":"https://api.github.com/users/Rodrigoaz7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rodrigoaz7/subscriptions","organizations_url":"https://api.github.com/users/Rodrigoaz7/orgs","repos_url":"https://api.github.com/users/Rodrigoaz7/repos","events_url":"https://api.github.com/users/Rodrigoaz7/events{/privacy}","received_events_url":"https://api.github.com/users/Rodrigoaz7/received_events","type":"User","site_admin":false},"created_at":"2018-03-12T13:31:29Z","updated_at":"2018-03-12T13:31:29Z","author_association":"NONE","body":"First, I get the credentials by the json_keyfile_name:\r\n\r\n```\r\nscope = ['https://spreadsheets.google.com/feeds']\r\ncredentials = ServiceAccountCredentials.from_json_keyfile_name(BASE_DIR + 'path_of_json', scope)\r\n```\r\n\r\nThen I use the authorize:\r\n`gc = gspread.authorize(credentials, client_class=Client)`\r\n\r\nAfter the authorization, I open my sheet:\r\n`wks = gc.open(\"name_of_my_sheet\").sheet1`\r\n\r\nNow comes the problem. First of all I update the cell 'A1\" of my sheet with a function like this:\r\n`wks.update_acell('A1','=googlefinance(\"petr3\";\"price\";workday(today();-10);today())')`\r\n\r\nAnd it worked, because in my sheet, the table with the data appears, but when a I run a code to get those datas with `wks.acell('A1').value `, it's given to me #NAME?.\r\n\r\nAnd when a run the code like that with another cell, like `wks.acell('B2').value`, for example, it gives blank (but there's data in my sheet).\r\n\r\nBest regards,\r\n"}}
{"actor":{"display_login":"Rodrigoaz7"}}