search

davepar / gcalendarsync

Apps Script for syncing a Google Spreadsheet with Google Calendar
MIT License
161 stars 46 forks source link

local date fformat overwritten when syncing from calendar #77

Closed itluzanky closed 3 years ago

itluzanky commented 3 years ago

When I sync from calendar, local date format is overwritten by US standard.

Before sync: image

And, moreover and more importantly, it shifts some dates: After ("Update from calendar"): image

(the sheet is here https://docs.google.com/spreadsheets/d/1HvsaNjmquyga7ruJmEEPOLrPhbY8b4vRRFu99OdSxgw/edit#gid=901722093 )

The bug with shifting dates would be easily fixed by not requiring END TIME (as stated in manual) (issue #73)

davepar commented 3 years ago

Ah, thanks for pointing this out. This was caused by an earlier attempt to fix the off-by-one issue. Should be fixed now.

The end date would still be needed for multi-day events, so the off by one error would happen in that case. Sorry I haven't made the end date optional yet. It's more work than it sounds.

itluzanky commented 3 years ago

I've just tested this, and it seems to be OK now, thanks!