Vic, If I am not mistaken, you are not using the Python client library to make that call. So it may be that the problem is in only in the Python client library and not in the API. I will try calling through a proxy, Paros, to discover what the actual HTTP request looks like, after being generated by the Python lib.
But it is good to know that the API itself, as accessed through HTTP, does correctly interpret the A1 notation in cell formulas. thanks, John On Wed, Jan 12, 2011 at 12:39 PM, Vic Fryzel <[email protected]> wrote: > 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 >>>> >>>> >>>> >>> >> >
