Hi John, That's not the case, you can use A1 notation in cell formulas via the API. I just confirmed it works.
Run a PUT request: https://spreadsheets.google.com/feeds/cells/ <key>/<worksheet>/private/full/R4C3 <entry xmlns="http://www.w3.org/2005/Atom"; xmlns:gs="http://schemas.google.com/spreadsheets/2006";> <gs:cell row="4" col="3" inputValue="=SUM(A1:B4)"/> </entry> The API will then translate your A1 notation to R1C1 notation, although this is translated back in the user interface to A1 notation. Also, to clear things up some more, I tried a1:B4, a1:b4, and A1:b4, all worked. Thanks, -Vic On Wed, Jan 12, 2011 at 5:41 AM, John Black <[email protected]>wrote: > Vic, > > It turns out that the critical event in my scenario was that it works if > you enter a range by hand but not if you try to do it through the API. > Looking around in the documentation and on the forum, I came to the > conclusion that you can only use relative or absolute row column address > notation in the API. You cannot use 'cell names' such as 'A1', 'B2', etc. > You can only use 'r1c1' (absolute address) or r[-1]c[2] (relative address). > > My application is now working with row/column address notation. > > John > > On Tue, Jan 11, 2011 at 5:19 PM, Vic Fryzel <[email protected]> wrote: > >> Hey John, >> >> You're saying it works if and only if you pass b3:B5 to the API? That is, >> lowercase b, then uppercase B? >> >> Thanks, >> -Vic >> >> >> >> On Thu, Dec 30, 2010 at 1:50 PM, John Black <[email protected]>wrote: >> >>> If I call the method ListInsertAction on a Spreadsheet and try to add a >>> formula, the formula will be correctly inserted into the spreadsheet but >>> will result in an error message generated: >>> >>> #NAME -(in the popup help)-> "error: Unknown range name X0", where "X0" >>> stands for a column name such as "B3", "b4", etc. >>> >>> Now, there is nothing wrong with my ranges. An example is "B3:B5". If I >>> change this to "b3:B5" then it works! >>> >>> If I type in exactly the same formula by hand, it works. >>> >>> John >>> >>> >>> >> >
