I'm trying to add lots of event to my calendar, so I'm using datasheet view of my calendar. But I found I can't copy-paste whole rows due to the recurrence column is read-only, and I can't hide it in modify view page as the checkbox of recurrence is grayed out. So my question is, how do I get rid of recurrence column in calendar datasheet view so I can copy-paste rows?
What I tried: I tried to go to SharePoint Designer > content type > event > and hide the recurrence column. It became hidden in event content type but still appears in my calendar.