{"action":"closed","issue":{"url":"https://api.github.com/repos/jennybc/googlesheets/issues/18","labels_url":"https://api.github.com/repos/jennybc/googlesheets/issues/18/labels{/name}","comments_url":"https://api.github.com/repos/jennybc/googlesheets/issues/18/comments","events_url":"https://api.github.com/repos/jennybc/googlesheets/issues/18/events","html_url":"https://github.com/jennybc/googlesheets/issues/18","id":56932082,"number":18,"title":"Formula support","user":{"login":"jennybc","id":599454,"avatar_url":"https://avatars.githubusercontent.com/u/599454?v=3","gravatar_id":"","url":"https://api.github.com/users/jennybc","html_url":"https://github.com/jennybc","followers_url":"https://api.github.com/users/jennybc/followers","following_url":"https://api.github.com/users/jennybc/following{/other_user}","gists_url":"https://api.github.com/users/jennybc/gists{/gist_id}","starred_url":"https://api.github.com/users/jennybc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jennybc/subscriptions","organizations_url":"https://api.github.com/users/jennybc/orgs","repos_url":"https://api.github.com/users/jennybc/repos","events_url":"https://api.github.com/users/jennybc/events{/privacy}","received_events_url":"https://api.github.com/users/jennybc/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jennybc/googlesheets/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-02-08T00:14:47Z","updated_at":"2015-08-31T20:49:59Z","closed_at":"2015-08-31T20:49:59Z","body":"I'm not sure if or when we want to handle this. We're clearly not doing so right now. But you can get and edit formulas via the API. Right now, we seem to assume \"contents is contents\".\r\n\r\nFrom the [API docs on the cells feed](https://developers.google.com/google-apps/spreadsheets/#working_with_cell-based_feeds):\r\n\r\n> The inputValue attribute of a cell entry always contains the value that a user would otherwise type into the Google Sheets user interface to manipulate the cell (i.e. either a literal value or a formula). To set a formula or a literal value on a cell, provide the text of the formula or value as the inputValue attribute. Remember that formulas must start with = to be considered a formula. If a cell contains a formula, the formula is always provided as the inputValue when cell entries are returned by the API.\r\n\r\n> The numericValue attribute of a cell entry, when present, indicates that the cell was determined to have a numeric value, and its numeric value is indicated with this attributed.\r\n\r\n> The literal value of the cell element is the calculated value of the cell, without formatting applied. If the cell contains a formula, the calculated value is given here."}}