Per the documentation, adding a new record is supposed to add it at the
first empty line in the worksheet.
What I am seeing is that regardless of empty rows available at the bottom
of the worksheet, a new row is created and the record is saved in that new
row.
Ugly...
This is the gist of what I'm doing to add a record (python):
cl = gdata.spreadsheets.client.SpreadsheetsClient()
new_feed = gdata.spreadsheets.data.ListEntry()
new_feed.set_value("col1", "blah")
...
ret = cl.AddListEntry(new_feed, spreadsheet_key, worksheet_id,
auth_token)
Any ideas on how to actually add it on the first empty row?
I didn't get any answer on my previous post on this forum, but I'm not
losing hope yet... (Vic?)