{"action":"created","issue":{"url":"https://api.github.com/repos/python-excel/xlwt/issues/62","labels_url":"https://api.github.com/repos/python-excel/xlwt/issues/62/labels{/name}","comments_url":"https://api.github.com/repos/python-excel/xlwt/issues/62/comments","events_url":"https://api.github.com/repos/python-excel/xlwt/issues/62/events","html_url":"https://github.com/python-excel/xlwt/issues/62","id":60801906,"number":62,"title":"Add More Formula Functions","user":{"login":"speedplane","id":671052,"avatar_url":"https://avatars.githubusercontent.com/u/671052?v=3","gravatar_id":"","url":"https://api.github.com/users/speedplane","html_url":"https://github.com/speedplane","followers_url":"https://api.github.com/users/speedplane/followers","following_url":"https://api.github.com/users/speedplane/following{/other_user}","gists_url":"https://api.github.com/users/speedplane/gists{/gist_id}","starred_url":"https://api.github.com/users/speedplane/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/speedplane/subscriptions","organizations_url":"https://api.github.com/users/speedplane/orgs","repos_url":"https://api.github.com/users/speedplane/repos","events_url":"https://api.github.com/users/speedplane/events{/privacy}","received_events_url":"https://api.github.com/users/speedplane/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-12T11:00:28Z","updated_at":"2015-03-12T21:32:11Z","closed_at":"2015-03-12T21:32:11Z","body":"It looks like xlwt only supports a few basic functions (`if`, `sum`, `max`, `min`, and `choose`). It would be fantastic if additional formulas were added. \r\n\r\nI'm specifically looking at `averageif` which is difficult to implement without a specific formula function."},"comment":{"url":"https://api.github.com/repos/python-excel/xlwt/issues/comments/78628502","html_url":"https://github.com/python-excel/xlwt/issues/62#issuecomment-78628502","issue_url":"https://api.github.com/repos/python-excel/xlwt/issues/62","id":78628502,"user":{"login":"sjmachin","id":1508240,"avatar_url":"https://avatars.githubusercontent.com/u/1508240?v=3","gravatar_id":"","url":"https://api.github.com/users/sjmachin","html_url":"https://github.com/sjmachin","followers_url":"https://api.github.com/users/sjmachin/followers","following_url":"https://api.github.com/users/sjmachin/following{/other_user}","gists_url":"https://api.github.com/users/sjmachin/gists{/gist_id}","starred_url":"https://api.github.com/users/sjmachin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sjmachin/subscriptions","organizations_url":"https://api.github.com/users/sjmachin/orgs","repos_url":"https://api.github.com/users/sjmachin/repos","events_url":"https://api.github.com/users/sjmachin/events{/privacy}","received_events_url":"https://api.github.com/users/sjmachin/received_events","type":"User","site_admin":false},"created_at":"2015-03-12T21:32:11Z","updated_at":"2015-03-12T21:32:11Z","body":"xlwt supports about 340 functions; see source file ExcelMagic.py. The 5 that you listed are special-cased in the code generation stage.\r\n\r\naverageif() was introduced in Excel2007; xlwt supports up to Excel 2003.\r\n\r\n"}}