{"action":"created","issue":{"url":"https://api.github.com/repos/Davepar/gcalendarsync/issues/3","repository_url":"https://api.github.com/repos/Davepar/gcalendarsync","labels_url":"https://api.github.com/repos/Davepar/gcalendarsync/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/Davepar/gcalendarsync/issues/3/comments","events_url":"https://api.github.com/repos/Davepar/gcalendarsync/issues/3/events","html_url":"https://github.com/Davepar/gcalendarsync/issues/3","id":133473567,"number":3,"title":"Gcalendarsync","user":{"login":"Anastasis25","id":17211219,"avatar_url":"https://avatars.githubusercontent.com/u/17211219?v=3","gravatar_id":"","url":"https://api.github.com/users/Anastasis25","html_url":"https://github.com/Anastasis25","followers_url":"https://api.github.com/users/Anastasis25/followers","following_url":"https://api.github.com/users/Anastasis25/following{/other_user}","gists_url":"https://api.github.com/users/Anastasis25/gists{/gist_id}","starred_url":"https://api.github.com/users/Anastasis25/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Anastasis25/subscriptions","organizations_url":"https://api.github.com/users/Anastasis25/orgs","repos_url":"https://api.github.com/users/Anastasis25/repos","events_url":"https://api.github.com/users/Anastasis25/events{/privacy}","received_events_url":"https://api.github.com/users/Anastasis25/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2016-02-13T21:07:56Z","updated_at":"2016-02-22T22:35:43Z","closed_at":null,"body":"Hi Dave, I just worked out how to open comms with you.\r\n\r\nI posted on an old thread re: the calendarsync which is great.\r\n\r\nThe only issue is that when I do the sync, any formulas in the sheet get wiped out, which is a problem.\r\n\r\nIf there were a way for this not to happen then the script would be 100% what I need.\r\n\r\nI can work around it, however it means undoing the sync which reverts the sheet back to it's previous state and getting the formula back, however as other people are going to use this sheet they will always have to remember doing this, which isn't ideal.\r\n\r\nI think it works for us but would be the 100% solution if we didn't lose the forumula.\r\n\r\nalso when you do the undo you lose the latest calendar ID.\r\n\r\nJust for your information the reason for the formula is that the data is pulled from several sources and some of the cells are concatenated to make them more useful in the calendar.\r\n\r\nThanks for your help/advice in advance and also for making this script easy to understand and implement."},"comment":{"url":"https://api.github.com/repos/Davepar/gcalendarsync/issues/comments/187419556","html_url":"https://github.com/Davepar/gcalendarsync/issues/3#issuecomment-187419556","issue_url":"https://api.github.com/repos/Davepar/gcalendarsync/issues/3","id":187419556,"user":{"login":"Anastasis25","id":17211219,"avatar_url":"https://avatars.githubusercontent.com/u/17211219?v=3","gravatar_id":"","url":"https://api.github.com/users/Anastasis25","html_url":"https://github.com/Anastasis25","followers_url":"https://api.github.com/users/Anastasis25/followers","following_url":"https://api.github.com/users/Anastasis25/following{/other_user}","gists_url":"https://api.github.com/users/Anastasis25/gists{/gist_id}","starred_url":"https://api.github.com/users/Anastasis25/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Anastasis25/subscriptions","organizations_url":"https://api.github.com/users/Anastasis25/orgs","repos_url":"https://api.github.com/users/Anastasis25/repos","events_url":"https://api.github.com/users/Anastasis25/events{/privacy}","received_events_url":"https://api.github.com/users/Anastasis25/received_events","type":"User","site_admin":false},"created_at":"2016-02-22T22:35:43Z","updated_at":"2016-02-22T22:35:43Z","body":"Hi Dave,\n\n \n\nI tried something on my spreadsheet which worked.\n\n \n\nAs I mentioned I had formula in my spreadsheet. This was throughout the spreadsheet, except for the headings. I tested it again by making the headings formulas and it seemed to work, i.e. they didn’t disappear after I ran the update.\n\n \n\nDoes this make sense? If it didn’t have to be this way it would be better, however it is a workaround to not lose the headings in this case.\n\n \n\nThanks for all your help and if you resolve it great, otherwise this has been really helpful.\n\n \n\nIs there anyway of being updated if you make improvements to this in the future or if you make some other neat apps?\n\n \n\nRegards\n\n\n\nAnastasis Kokkinos\n\n \n\nFrom: Dave Parsons [mailto:notifications@github.com] \nSent: 23 February 2016 04:22\nTo: Davepar/gcalendarsync\nCc: Anastasis25\nSubject: Re: [gcalendarsync] Gcalendarsync (#3)\n\n \n\nWhen I said update the calendar ID, I just meant if you copied the script again. It has \"YOUR CALENDAR ID HERE\" in the code.\n\nNot sure why the headings were removed. I'm not seeing that problem when I sync from the spreadsheet to the calendar. Do you have more than one row of headings? And you were syncing from the spreadsheet to the calendar, or the other direction?\n\nSyncing one spreadsheet to two calendars would be tricky. How would it determine which calendar to use for each event? Or would the events appear on both calendars, but with different title/description?\n\nYou're feedback has been great. I'm glad you reported the problem with the formulas.\n\n—\nReply to this email directly or view it on GitHub <https://github.com/Davepar/gcalendarsync/issues/3#issuecomment-187276929> .Image removed by sender.\n\n"}}