{"action":"created","issue":{"url":"https://api.github.com/repos/marbl/Krona/issues/44","repository_url":"https://api.github.com/repos/marbl/Krona","labels_url":"https://api.github.com/repos/marbl/Krona/issues/44/labels{/name}","comments_url":"https://api.github.com/repos/marbl/Krona/issues/44/comments","events_url":"https://api.github.com/repos/marbl/Krona/issues/44/events","html_url":"https://github.com/marbl/Krona/issues/44","id":215294804,"number":44,"title":"KronaExcelTemplate Error - Categories do not merge","user":{"login":"rjea","id":26528284,"avatar_url":"https://avatars0.githubusercontent.com/u/26528284?v=3","gravatar_id":"","url":"https://api.github.com/users/rjea","html_url":"https://github.com/rjea","followers_url":"https://api.github.com/users/rjea/followers","following_url":"https://api.github.com/users/rjea/following{/other_user}","gists_url":"https://api.github.com/users/rjea/gists{/gist_id}","starred_url":"https://api.github.com/users/rjea/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rjea/subscriptions","organizations_url":"https://api.github.com/users/rjea/orgs","repos_url":"https://api.github.com/users/rjea/repos","events_url":"https://api.github.com/users/rjea/events{/privacy}","received_events_url":"https://api.github.com/users/rjea/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-03-19T21:05:20Z","updated_at":"2017-03-30T02:02:33Z","closed_at":null,"body":"Hi,\r\n\r\nI ran into some trouble while trying to use the KronaExcelTemplate in Excel v15.32 (2017) on MacOS: the categories do not merge when generating the graph, e.g., using the granola example data without any editing, I get three \"Fats\" (and three \"Carbohydrates\") categories, each followed by the subsequent subcategories, rather than a single \"Fats\" category subdivided into Saturated, Unsaturated, and so on.\r\n\r\nI can get the correct graph by importing the data from txt with KronaTools, but the \"colouring\" according to an additional variable is essential for my purpose. I have not been able to convert my data to xml so far, as I am not really familiar with the format.\r\nIs it possible to fix the graph generation using KronaExcelTemplate and/or import score data from txt?\r\nIdeally, I would like to have a single chart with several (approx. 10) \"samples\", each with an additional \"score\" colouring option - is it possible to do this without writing an xml file?\r\n\r\nThanks in advance"},"comment":{"url":"https://api.github.com/repos/marbl/Krona/issues/comments/290280094","html_url":"https://github.com/marbl/Krona/issues/44#issuecomment-290280094","issue_url":"https://api.github.com/repos/marbl/Krona/issues/44","id":290280094,"user":{"login":"ondovb","id":1307452,"avatar_url":"https://avatars2.githubusercontent.com/u/1307452?v=3","gravatar_id":"","url":"https://api.github.com/users/ondovb","html_url":"https://github.com/ondovb","followers_url":"https://api.github.com/users/ondovb/followers","following_url":"https://api.github.com/users/ondovb/following{/other_user}","gists_url":"https://api.github.com/users/ondovb/gists{/gist_id}","starred_url":"https://api.github.com/users/ondovb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ondovb/subscriptions","organizations_url":"https://api.github.com/users/ondovb/orgs","repos_url":"https://api.github.com/users/ondovb/repos","events_url":"https://api.github.com/users/ondovb/events{/privacy}","received_events_url":"https://api.github.com/users/ondovb/received_events","type":"User","site_admin":false},"created_at":"2017-03-30T02:02:33Z","updated_at":"2017-03-30T02:02:33Z","body":"The version available [here](https://github.com/marbl/Krona/raw/master/ExcelTemplate/Krona.xltm) should fix the category issue and also allows more than two samples. Let me know if this solves your issue, and if it does not cause any other problems I will make an official release."}}
{"actor":{"display_login":"ondovb"}}