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
