Hi thanks for replying. I can create a formula via the API as you suggested, but only if the cell in the formula is relative to the current worksheet. I don't know how to copy and paste a cell if the formula refers to a different worksheet; in my case, a worksheet "daily times" is different from the worksheet that contains the formula, and D227 was a cell in that worksheet (being copied), not the worksheet being pasted.
Is my problem description more clear now? Thanks Robin On Fri, Mar 18, 2011 at 11:38 AM, Vic Fryzel <[email protected]> wrote: > Are you looking to copy/paste a cell with a formula via the API? You can > retrieve and set the a formula with the cells feed, using something like > this: > > <gs:cell row="9" col="4" > inputValue="=FLOOR(R[0]C[-1]/(R[0]C[-2]*60),.0001)" > numericValue="5.0">5</gs:cell> > > > http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#RetrievingCellFeeds > > Thanks, > -Vic > > > > On Fri, Mar 11, 2011 at 4:23 PM, Robin <[email protected]> wrote: > >> I've been able to add rows to different worksheets in a spreadsheet >> using the API. Some of my formulas in my spreadsheet refer to other >> worksheets by name e.g. using syntax like this (in the formula) >> =hour('daily times'!D227)+(minute('daily times'!D227)/60) >> When I update this spreadsheet manually, I first add a new row worth >> of values manually in one worksheet 'daily times' (this part I can >> automate using the API) but then I copy and paste a row from a >> different worksheet. Manually it works great. Any suggestions for how >> to automate it using the Google Docs Data API for Spreadsheets? >> > >
