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