{"action":"opened","issue":{"url":"https://api.github.com/repos/sanger-pathogens/Roary/issues/156","labels_url":"https://api.github.com/repos/sanger-pathogens/Roary/issues/156/labels{/name}","comments_url":"https://api.github.com/repos/sanger-pathogens/Roary/issues/156/comments","events_url":"https://api.github.com/repos/sanger-pathogens/Roary/issues/156/events","html_url":"https://github.com/sanger-pathogens/Roary/issues/156","id":90966140,"number":156,"title":"labeling of missing values in CSV files","user":{"login":"dutchscientist","id":10428112,"avatar_url":"https://avatars.githubusercontent.com/u/10428112?v=3","gravatar_id":"","url":"https://api.github.com/users/dutchscientist","html_url":"https://github.com/dutchscientist","followers_url":"https://api.github.com/users/dutchscientist/followers","following_url":"https://api.github.com/users/dutchscientist/following{/other_user}","gists_url":"https://api.github.com/users/dutchscientist/gists{/gist_id}","starred_url":"https://api.github.com/users/dutchscientist/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dutchscientist/subscriptions","organizations_url":"https://api.github.com/users/dutchscientist/orgs","repos_url":"https://api.github.com/users/dutchscientist/repos","events_url":"https://api.github.com/users/dutchscientist/events{/privacy}","received_events_url":"https://api.github.com/users/dutchscientist/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-06-25T13:31:45Z","updated_at":"2015-06-25T13:31:45Z","closed_at":null,"body":"I primarily use the CSV files produced by Roary, and currently markers missing are represented by an empty cell if opened in a spreadsheet. With large datasets (say 500-1000 genomes) this is sometimes awkward, especially if one wants to do formatting. If all cells were filled (i.e. N/A for missing values), then this would make life a lot easier.\r\n\r\nIs this possible? It saves doing Find/Replace of empty cells in Excel. I have done Find/Replace of \"\" in the text file, but this gives some errors and hence does not work well."}}