John, Can you set service.debug = True before your call and paste me the debug output without the token?
Thanks, -Vic On Wed, Jan 12, 2011 at 10:28 AM, John Black <[email protected]>wrote: > 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 >>>>> >>>>> >>>>> >>>> >>> >> >
