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