Hi, The visualization api does not care if the cell content was created by a formula or directly. So your code should work. Please try the simplest scenario, i.e., without the "select J" and use a simple visualization where you can see all the data like a Table and let me know if you see the result of the formula.
- VizBoy. On Wed, Mar 11, 2009 at 6:23 PM, Pragan <[email protected]> wrote: > > Hi, > > I have a question in getting the data from a cell in spreadsheet that > is filled using a formula. > I created a spreadhsheet and I am trying to get the data using viz > api. One column in this cell is filled based on other cells using the > formula : =IF(A2="?",0,1) > I can see the values when I publish the sheet but not when I use this > query > "query.setQuery('select J');" from viz api . Is there any way to > either get the content or write the formula in the code? Please let me > know. > > thanks > pragan. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
