{"action":"created","issue":{"url":"https://api.github.com/repos/zdavatz/spreadsheet/issues/147","labels_url":"https://api.github.com/repos/zdavatz/spreadsheet/issues/147/labels{/name}","comments_url":"https://api.github.com/repos/zdavatz/spreadsheet/issues/147/comments","events_url":"https://api.github.com/repos/zdavatz/spreadsheet/issues/147/events","html_url":"https://github.com/zdavatz/spreadsheet/issues/147","id":105266602,"number":147,"title":"Adjacent cells in a column using formulas have their data deleted","user":{"login":"forty9er","id":13773335,"avatar_url":"https://avatars.githubusercontent.com/u/13773335?v=3","gravatar_id":"","url":"https://api.github.com/users/forty9er","html_url":"https://github.com/forty9er","followers_url":"https://api.github.com/users/forty9er/followers","following_url":"https://api.github.com/users/forty9er/following{/other_user}","gists_url":"https://api.github.com/users/forty9er/gists{/gist_id}","starred_url":"https://api.github.com/users/forty9er/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/forty9er/subscriptions","organizations_url":"https://api.github.com/users/forty9er/orgs","repos_url":"https://api.github.com/users/forty9er/repos","events_url":"https://api.github.com/users/forty9er/events{/privacy}","received_events_url":"https://api.github.com/users/forty9er/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-09-07T20:55:16Z","updated_at":"2015-09-08T06:41:08Z","closed_at":null,"body":"I'm experiencing a problem where cells in a column have all their data deleted if two or more adjacent cells use formulas.\r\n\r\nHere's the code:\r\n\r\n    require 'spreadsheet'\r\n    Spreadsheet.client_encoding = 'UTF-8'\r\n\r\n    def test\r\n\r\n    # open the spreadsheet\r\n    book = Spreadsheet.open 'test.xls'\r\n    sheet1 = book.worksheet 0\r\n\r\n    # the new data\r\n    a = 1\r\n    b = 2\r\n\r\n    # input the new data into the spreadsheet\r\n    sheet1[5, 1] = a\r\n    sheet1[5, 2] = b\r\n\r\n    # save to \"-Modded\" file in same folder. \r\n    book.write 'test-Modded.xls'\r\n    end\r\n\r\n    test\r\n\r\nThe original file looks like this:\r\n![1-before](https://cloud.githubusercontent.com/assets/13773335/9722734/e83080ca-55aa-11e5-825b-0276960ab4ff.png)\r\n\r\nThe result I want is this:\r\n![2-after-desired](https://cloud.githubusercontent.com/assets/13773335/9722737/f38a5144-55aa-11e5-8264-e8b0dad16926.png)\r\n\r\nbut the actual result is this:\r\n![3-after-actual](https://cloud.githubusercontent.com/assets/13773335/9722738/fe4cd50c-55aa-11e5-896b-481e9da96b6d.png)\r\n\r\ntest files, including an XLS file: \r\nhttps://www.dropbox.com/s/qblq7mcfy6cvc48/delete_error.zip?dl=0\r\n"},"comment":{"url":"https://api.github.com/repos/zdavatz/spreadsheet/issues/comments/138450503","html_url":"https://github.com/zdavatz/spreadsheet/issues/147#issuecomment-138450503","issue_url":"https://api.github.com/repos/zdavatz/spreadsheet/issues/147","id":138450503,"user":{"login":"zdavatz","id":4953,"avatar_url":"https://avatars.githubusercontent.com/u/4953?v=3","gravatar_id":"","url":"https://api.github.com/users/zdavatz","html_url":"https://github.com/zdavatz","followers_url":"https://api.github.com/users/zdavatz/followers","following_url":"https://api.github.com/users/zdavatz/following{/other_user}","gists_url":"https://api.github.com/users/zdavatz/gists{/gist_id}","starred_url":"https://api.github.com/users/zdavatz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zdavatz/subscriptions","organizations_url":"https://api.github.com/users/zdavatz/orgs","repos_url":"https://api.github.com/users/zdavatz/repos","events_url":"https://api.github.com/users/zdavatz/events{/privacy}","received_events_url":"https://api.github.com/users/zdavatz/received_events","type":"User","site_admin":false},"created_at":"2015-09-08T06:41:08Z","updated_at":"2015-09-08T06:41:08Z","body":"Ok, this looks like a bug."}}