{"action":"closed","issue":{"url":"https://api.github.com/repos/SheetJS/js-xlsx/issues/319","labels_url":"https://api.github.com/repos/SheetJS/js-xlsx/issues/319/labels{/name}","comments_url":"https://api.github.com/repos/SheetJS/js-xlsx/issues/319/comments","events_url":"https://api.github.com/repos/SheetJS/js-xlsx/issues/319/events","html_url":"https://github.com/SheetJS/js-xlsx/issues/319","id":116132768,"number":319,"title":"Formula doesn't work on Export2Excel","user":{"login":"neridonk","id":8501623,"avatar_url":"https://avatars.githubusercontent.com/u/8501623?v=3","gravatar_id":"","url":"https://api.github.com/users/neridonk","html_url":"https://github.com/neridonk","followers_url":"https://api.github.com/users/neridonk/followers","following_url":"https://api.github.com/users/neridonk/following{/other_user}","gists_url":"https://api.github.com/users/neridonk/gists{/gist_id}","starred_url":"https://api.github.com/users/neridonk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/neridonk/subscriptions","organizations_url":"https://api.github.com/users/neridonk/orgs","repos_url":"https://api.github.com/users/neridonk/repos","events_url":"https://api.github.com/users/neridonk/events{/privacy}","received_events_url":"https://api.github.com/users/neridonk/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-10T15:42:25Z","updated_at":"2015-11-11T15:08:12Z","closed_at":"2015-11-11T15:08:12Z","body":"I tested the http://sheetjs.com/demos/table.html\r\n\r\nand changed the  sheet_from_array_of_arrays methode to \r\n\r\n\r\nfunction sheet_from_array_of_arrays(data, opts) {\r\n  var ws = {};\r\n  var range = { s: { c: 10000000, r: 10000000 }, e: { c: 0, r: 0 } };\r\n  for (var R = 0; R != data.length; ++R) {\r\n    for (var C = 0; C != data[R].length; ++C) {\r\n      if (range.s.r > R) range.s.r = R;\r\n      if (range.s.c > C) range.s.c = C;\r\n      if (range.e.r < R) range.e.r = R;\r\n      if (range.e.c < C) range.e.c = C;\r\n      var cell = { v: data[R][C] };\r\n      if (cell.v == null) continue;\r\n      var cell_ref = XLSX.utils.encode_cell({ c: C, r: R });\r\n\r\n      if (typeof cell.v === 'number') cell.t = 'n';\r\n      else if (typeof cell.v === 'boolean') cell.t = 'b';\r\n      else if (cell.v instanceof Date) {\r\n        cell.t = 'n'; cell.z = XLSX.SSF._table[14];\r\n        cell.v = datenum(cell.v);\r\n      }\r\n      else cell.t = 's';\r\n\r\n\r\n      cell.f = 'A2+A3';\r\n\r\n\r\n      console.log(cell);\r\n\r\n      ws[cell_ref] = cell;\r\n    }\r\n  }\r\n  if (range.s.c < 10000000) ws['!ref'] = XLSX.utils.encode_range(range);\r\n  return ws;\r\n}\r\n\r\n\r\nbut the ->   cell.f = 'A2+A3'; didnt work"}}