AnsweredAssumed Answered

Why has google sheet (range) stopped updating correctly on Canvas page?

Question asked by Richard Nickalls on Jul 31, 2017
Latest reply on Oct 18, 2017 by Kenneth Rogers

Until last week, we had a really nice googlesheet (used by several differnet programmes) embedding nicely into different Canvas courses (on their pages).  Different programmes took different parts of the same spreadsheet - showing reminders about schedules- through the 'range' code (see example below).  We also used a relative size function -so different users would see the weekly schedule whatever their screen size.  It worked perfectly and we thought we were really clever....until last Friday.  For some reason (see screeshots below), when we update the spreadhseet in google (see screenshot 1) the table cells update in different parts of the sheet on Canvas.

 

Here's the embed iframe code we used on the Canvas page (I took out the real url of course):

<div style="position: relative; width: 100%; height: 0px; padding-bottom: 60%;"><iframe style="position: absolute; left: 0px; top: 0px; width: 100%; height: 100%;" src="https://docs.google.com/spreadsheets/XXXXXXXXXXXXXXXXXX?gid=0&range=h1:m193&widget=false&headers=false" width="100%" height="400"></iframe></div>

 

Sceenshot 1: what we should see (the google sheet)

 

Screen shot 2: what we see on the embedded page - see how some cells have drifted off the embedded sheet, to the right.)

 

Thanks in advance for any help anyone can give me.  Can anyone see a problem in my embed code? It was working fine until last week, but maybe a recent upgrade or a change in google has stopped it working?

Outcomes