Use CellFeed to clear a cell containing numeric value

Question

I am trying to to use CellFeed to clear some cells in a google spreadsheet. I'm using a batch update to improve speed, so I can't use CellEntry.update(). I create cells and feed them to a batch.

If I set the cell with new CellEntry(row, col, ""), cells that contained text are cleared, but numeric values remain.

I also tried new CellEntry(Cell.createFullCell(row, col, "", null, "") to clear the number and calculated value as well, but that didn't help.

Any hints on how to clear the number as well?

I sure hope for a SpreadsheetService to replace this stupid and slow API...

Answer 1

For changing contents of a cell with numeric value you should use:

CellEntry.changeInputValueLocal() method.

Check this documentation for more details.