Re: Insert a slightly complex function / formula through GDATA Objective C library to a spreadsheet cell

[Khurram Ali]

Thank you for the quick response. I will do a test tomorrow and let you know. It could also explain why C2:C would be converted to $B:A. Interestingly, my problem goes away if I put a bound to my range. So this works: D2:D100 and also C2:C100. - Khurram Vic Fryzel wrote: 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, <khurram....@riksof.com> 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 -- M. Khurram Ali CEO, RIKSOF #603 Horizon Towers, Plot No Com 2/6, Block 3, Clifton, Karachi 75600, Pakistan Tel : (92) 21 3529 2676-7 Fax : (92) 21 3529 2678 Skype: riksof.skype Email: khurram....@riksof.com http://www.riksof.com ----------------------------------- I blog @ http://riksof.blogspot.com