search

GCalToolkit / Sheets2GCal

Issue Tracker for Sheets2GCal Google Sheets Add-on
0 stars 1 forks source link

Sync Cal to Sheet - changes to description on cal show as HTML in sheet description column #13

Open aldiouma opened 2 years ago

aldiouma commented 2 years ago

On the initial calendar import, it appears that the description information syncs correctly. However, if I make changes to the description on the calendar. Future updates show up as HTML on the calendar sheet description column for those entries.

If changes to the description are made in the sheet, all is well and continues to sync nicely.

Many thanks for your assistance. AD

GCalToolkit commented 2 years ago

Hi, are you making manual text edits to the descriptions, or copy/pasting from elsewhere? Can you post a few screenshots?

aldiouma commented 2 years ago

Thanks. When I make manual text edits to the description on Google Calendar.

New event not yet made on the calendar - "Test 2" at 10 AM on 1/29/2022 image

Creating a new calendar event "Test 2" at 10 AM on 1/29/2022 (Please also note the first row "test 1" with HTML in the description cell.) image

Quick update performed. Result on Calendar is the new event. image

Here is the spreadsheet after the Quick update: image

Now I am editing the calendar event description. I have added, "I have added this." image image

Quick import is performed on the spreadsheet. It has imported the new addition successfully. image

Now I am editing the calendar event description a second time. I have added, "I have added this - second time" image

Quick import is performed again on the spreadsheet. This time, it has converted the text in the spreadsheet description cell to HTML image

I hope this is helpful. Many thanks for all of your assistance! Andrew

GCalToolkit commented 2 years ago

I'll do some tests and get back to you - Sheets2GCal imports the raw data from Google Calendar, so this means that somehow when you are editing the calendar description Google Calendar is adding the HTML. You could test this if you have iOS with Apple's calender app which also imports raw calendar data for descriptions. If you select the description text in Google Calendar and click the "remove formatting" button (crossed out 'T'), save and then Quick Import to Sheets2GCal, does it still show HTML tags?

aldiouma commented 2 years ago

Sorry, I don't have i)S with Apple calendar app.

However, I highlighted and clicked the crossed out "T" as follows: image

I performed a Quick Import in the spreadsheet for the two entries with HTML... and this is the result... image

It worked! I will make it a point to remove the formatting when I make updates in Google Calendar and it appears that this should fix the issue.

I really appreciate your help! Many thanks!

GCalToolkit commented 2 years ago

I'm glad that workaround helps - I've reported this as I can reproduce it using only Google Calendar and the API Explorer, so it does seem to be a Google Calendar bug. I'll update here when I hear back from them. Thank you for pointing it out!

aldiouma commented 2 years ago

Many thanks.

On Mon, Jan 31, 2022, 11:27 GCalToolkit @.***> wrote:

I'm glad that workaround helps - I've reported this as it does seem to be a Google Calendar bug, and I'll update you when I hear back from them.

— Reply to this email directly, view it on GitHub https://github.com/GCalToolkit/Sheets2GCal/issues/13#issuecomment-1026025897, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHO4FGHIWIF2CSSHKJMP5LUY3A6RANCNFSM5NEJ6DDQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>