{"action":"created","issue":{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/216","labels_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/216/labels{/name}","comments_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/216/comments","events_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/216/events","html_url":"https://github.com/jmcnamara/XlsxWriter/issues/216","id":55603049,"number":216,"title":"Issue with 'total_function'","user":{"login":"PetiiMat","id":10723776,"avatar_url":"https://avatars.githubusercontent.com/u/10723776?v=3","gravatar_id":"","url":"https://api.github.com/users/PetiiMat","html_url":"https://github.com/PetiiMat","followers_url":"https://api.github.com/users/PetiiMat/followers","following_url":"https://api.github.com/users/PetiiMat/following{/other_user}","gists_url":"https://api.github.com/users/PetiiMat/gists{/gist_id}","starred_url":"https://api.github.com/users/PetiiMat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PetiiMat/subscriptions","organizations_url":"https://api.github.com/users/PetiiMat/orgs","repos_url":"https://api.github.com/users/PetiiMat/repos","events_url":"https://api.github.com/users/PetiiMat/events{/privacy}","received_events_url":"https://api.github.com/users/PetiiMat/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-01-27T10:57:26Z","updated_at":"2015-01-29T19:48:34Z","closed_at":null,"body":"I run the 0.6.6 version with Python 2.7.9 on Win7.\r\n\r\nI'm trying to get a table with a formula (sum) in the totals row. The formula works fine, however, Excel needs also the value, otherwise it complains when closing the workbook that the data have changed in the meantime (because it recalculates the sum itself). There are also ZEROs displayed in non-Excel applications, e.g. preview in MS Outlook.\r\n\r\nCode:\r\n```python\r\nfrom xlsxwriter import Workbook\r\nworkbook = Workbook('sample.xlsx')\r\ndata = [['a', 0, 15.2],\r\n        ['b', 15.2, -3.4], \r\n        ['c', -4, -5]]\r\nworksheet = workbook.add_worksheet()\r\nnumfmt = workbook.add_format({'num_format' : '#,##0.00'})\r\noptions = { 'data': data, \r\n            'style' : 'Table Style Light 21', \r\n            'total_row' : True, \r\n            'first_column' : True, \r\n            'columns' : [{'header' : 'Text 1', 'total_string' : 'Totals'}, \r\n                         {'header' : 'EUR', 'total_function' : 'sum', 'format' : numfmt}, \r\n                         {'header' : 'USD', 'total_function' : 'sum', 'format' : numfmt}]}\r\nworksheet.add_table(0, 0, 4, 2, options)\r\nworkbook.close()\r\n```"},"comment":{"url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/comments/72091413","html_url":"https://github.com/jmcnamara/XlsxWriter/issues/216#issuecomment-72091413","issue_url":"https://api.github.com/repos/jmcnamara/XlsxWriter/issues/216","id":72091413,"user":{"login":"PetiiMat","id":10723776,"avatar_url":"https://avatars.githubusercontent.com/u/10723776?v=3","gravatar_id":"","url":"https://api.github.com/users/PetiiMat","html_url":"https://github.com/PetiiMat","followers_url":"https://api.github.com/users/PetiiMat/followers","following_url":"https://api.github.com/users/PetiiMat/following{/other_user}","gists_url":"https://api.github.com/users/PetiiMat/gists{/gist_id}","starred_url":"https://api.github.com/users/PetiiMat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PetiiMat/subscriptions","organizations_url":"https://api.github.com/users/PetiiMat/orgs","repos_url":"https://api.github.com/users/PetiiMat/repos","events_url":"https://api.github.com/users/PetiiMat/events{/privacy}","received_events_url":"https://api.github.com/users/PetiiMat/received_events","type":"User","site_admin":false},"created_at":"2015-01-29T19:48:34Z","updated_at":"2015-01-29T19:48:34Z","body":"Brilliant! Looking forward to the new release! ;-)\r\n\r\nThanks,\r\nPetr\r\n\r\n29. 1. 2015 v 20:15, John McNamara <notifications@github.com>:\r\n\r\n> Would you consider adding the (optional) 'value' sub-property to the 'columns' parameter of the 'add_table' method, similarly as it is in the 'write_formula' function?\r\n> \r\n> Hi @PetiiMat,\r\n> \r\n> Yes. Not problem.\r\n> \r\n> Until I looked the other day I thought that it was there already.\r\n> \r\n> John\r\n> \r\n> —\r\n> Reply to this email directly or view it on GitHub.\r\n> "}}