I'm curious what inputValue for the cell comes back after you make the PUT? I think that it might be failing because it's trying to translate the D2:D to R1C1 notation (which the API does.)
Thanks, -Vic On Mon, Jan 24, 2011 at 6:14 AM, <[email protected]> wrote: > I would like to insert a formula in to my spreadsheet. I am able to update > the contents of a cell and set simple formula's without an issue. I first > get the feed of cells, once I have that I do this: > > GDataEntrySpreadsheetCell *entry = [[feed] entries objectAtIndex:i]; > GDataSpreadsheetCell *cell = [entry cell]; > [cell setInputString:@"ABc"]; > > This works perfectly well. Even the simple formulas works nicely. For > examples, this works: > > [cell setInputString:@"=D1"]; > > However, this does not work: > > [cell setInputString:@"=Unique(D2:D)"]; > > This value gets placed in the cell, but the cell has a #NAME? error. > Details on the error: > > Unkown range name D2 > > Interestingly though, if I delete the contents of the cell, and then type > this formula it works. Does anyone know what I am missing? > > Thanks, Khurram >
