I've found a few queries related but they are all<https://groups.google.com/forum/#!searchin/google-spreadsheets-api/validation/google-spreadsheets-api/gqGuZ6uovRI/ji9ITzIlgmwJ> slightly<https://groups.google.com/forum/#!searchin/google-spreadsheets-api/validation/google-spreadsheets-api/CcagijQNupw/9TGnpWiaPpcJ> different<https://groups.google.com/forum/#!searchin/google-spreadsheets-api/validation/google-spreadsheets-api/OLch6zwVqE8/ffqkJWZZ_JIJ>and outdated.
I'm trying to add a row of data (using the Google Spreadsheet API) to my sheet where the first column contains validation (list of items). The sheet is empty aside from a header row and validation set on every row of the first column. <https://lh5.googleusercontent.com/-u7o-CQQsedM/U16tIbJVPII/AAAAAAAAIWY/pUP-J1nsmS0/s1600/example.png> In the image example above, when I add a row, the data is added to row 3. When I remove the validation from A2 and try again, the data is added to row 2. The Google Spreadsheet API docs state<https://developers.google.com/google-apps/spreadsheets/#adding_a_list_row> : > The API inserts the new row immediately after the last row that appears in > the list feed, which is to say immediately before the first entirely blank > row. So I thought, ok lets just pull the list of rows and UPDATE the row containing validation instead of ADDing a new row. But when I pull the list of rows, the empty row containing validation isn't returned (because its empty!)! How can I either: 1. Add a row containing validation 2. or update an empty row containing validation Thanks! -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
