I've been trying to do a batch update of cells, and have been getting only
errors and a headache. Turns out that your own sample code doesn't work
either:
sample.spreadsheet.celldemo.run:
[java] This is a demo of the cells feed!
[java]
[java] Using this interface, you can read/write to your spreadsheet's
cells.
[java]
[java] (1) tmp-1300291075021
1
[java] Enter the number of the spreadsheet to load: Sheet loaded.
[java] Commands:
[java] load [[select a spreadsheet and
worksheet]]
[java] list [[shows all cells]]
[java] range minRow maxRow minCol maxCol [[rectangle]]
[java] set row# col# formula [[sets a cell]]
[java] example: set 1 3 =R1C2+1
[java] search adam [[full text query]]
[java] batch [[batch request]]
[java] exit
batch
[java] Enter set operations one by one, then enter submit to send the
batch request:
[java] set row# col# value [[add a set operation]]
[java] submit [[submit the request]]
set 1 1 foo
[java] Current operations in batch
[java] ID: R1C1 - update row: 1 col: 1 value: foo
[java] Enter set operations one by one, then enter submit to send the
batch request:
[java] set row# col# value [[add a set operation]]
[java] submit [[submit the request]]
set 1 2 bar
[java] Current operations in batch
[java] ID: R1C1 - update row: 1 col: 1 value: foo
[java] ID: R1C2 - update row: 1 col: 2 value: bar
[java] Enter set operations one by one, then enter submit to send the
batch request:
[java] set row# col# value [[add a set operation]]
[java] submit [[submit the request]]
set 1 3 bazz
[java] Current operations in batch
[java] ID: R1C1 - update row: 1 col: 1 value: foo
[java] ID: R1C2 - update row: 1 col: 2 value: bar
[java] ID: R1C3 - update row: 1 col: 3 value: bazz
[java] Enter set operations one by one, then enter submit to send the
batch request:
[java] set row# col# value [[add a set operation]]
[java] submit [[submit the request]]
submit
[java]
* [java] R1C1 failed (If-Match or If-None-Match header or entry etag
attribute required) null**
[java]
[java] R1C2 failed (Internal Error) null
[java]
[java] R1C3 failed (Internal Error) null*
I am assuming that this is a know problem. Will this be fixed in the near
future?
