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?
>
