search

GCalTools / Sheets2GCal

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

Out of order #58

Open Rehabco opened 4 months ago

Rehabco commented 4 months ago

G'mornin! When importing calendars to Gsheet the events are out of time order. (I.E. 10 am before 8am)

GCalToolkit commented 4 months ago

Hi, unless you implement sorting there’s no guarantee the events will be ordered as you want them to be. When you first import they will probably be in order, but when new events are fetched from the Calendar, for example, they'll be inserted at the first free row - so you should set up sorting yourself.

If you want basic date ordering you can just select the Start column and Sort A-Z or Z-A , but if you need ordering by date and time then you can select all your rows (except the Header row), go to the Sheets "Data" menu, then "Sort Range" > "Advanced Range Sorting Options", configure your "Start" column and "Start Time" column to sort A-Z and then click "Sort".

For example if Start is column D and Start Time is column F:

Screenshot 2024-07-22 at 19 49 03
Rehabco commented 4 months ago

Thank you for your suggestion, unfortunately this only rearranges the information around those two columns, the rest of the pertinent information (location, description) remain unmoved, disconnecting the needed information from the date.

Rehabco commented 4 months ago

This is a new issue, as it was working well previous to today. Not sure what changed.

GCalToolkit commented 4 months ago

Sheets2GCal lists the events in the order that they are provided by Google Calendar, but I'm not aware of any changes they've made to this recently.

However, reordering in the way I've described above should not change anything except the order of the rows - are you sure you followed the instructions correctly and selected all the data in the calendar before sorting?