Ok, obviously its not enough to share AND make it editable by everyone, you also have to put "Publish as Website", i wasnt aware of that, stupid me :)
(I still dont understand whats the difference between "Sharing with everyone" and "Publishing as a website" in google docs? best, tob On 22 Mrz., 02:13, Pegasusrjf <[email protected]> wrote: > I have had this issue from time to time. > > Be sure that all the sheets were actually published, and I usually > double check to see who has permissions just to make sure that > everyone can read without sign-in required. > > On Mar 21, 10:26 am, Tobi Harnegg <[email protected]> wrote: > > > > > Ok, I have ONE spreadsheet where this is working, but as soon as i > > enter another one > "Access Denied" > > > working spreadsheet: > > 'http://spreadsheets.google.com/tq? > > key=0AveLEDuTZv0vdFNFb1pBNl9scGVRU3JWd19qZUtuQVE&pub=1'); > > nonworking spreadsheet (amongst others) > > 'http://spreadsheets.google.com/tq? > > key=0AveLEDuTZv0vdGxWV0hUZkZWYXdBaE1sT29GUjZKQWc&pub=1'); > > > Logical conclusion would be, it has something to do with the docs > > themselves, but > > all spreadsheets are completely shared, for reading and editing. > > > Or is there some secret essential setting i have to change? > > > Very grateful for Advice, > > > Tobias > > > PS: Even though i am a total noob, i like playing around with this API > > > and here is the complete code: > > > ------------------------------------------------ > > <!-- > > copyright (c) 2009 Google inc. > > > You are free to copy and use this sample. > > License can be found > > here:http://code.google.com/apis/ajaxsearch/faq/#license > > --> > > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> > > <html xmlns="http://www.w3.org/1999/xhtml";> > > <head> > > <meta http-equiv="content-type" content="text/html; charset=utf-8"/ > > > <title> > > Google Visualization API Sample > > </title> > > <script type="text/javascript" src="http://www.google.com/jsapi";></ > > script> > > <script type="text/javascript"> > > google.load('visualization', '1', {packages: ['table']}); > > </script> > > <script type="text/javascript"> > > > var isFirstTime = true; > > var options = {'showRowNumber': false}; > > var data; > > var queryInput; > > > // To see the data that this visualization uses, browse to > > var query = new google.visualization.Query( > > // 'http://spreadsheets.google.com/tq? > > key=0AveLEDuTZv0vdFNFb1pBNl9scGVRU3JWd19qZUtuQVE&pub=1'); > > 'http://spreadsheets.google.com/tq? > > key=0AveLEDuTZv0vdGxWV0hUZkZWYXdBaE1sT29GUjZKQWc&pub=1'); > > > function sendAndDraw() { > > // Send the query with a callback function. > > query.send(handleQueryResponse); > > } > > > function handleQueryResponse(response) { > > if (response.isError()) { > > alert('Error in query: ' + response.getMessage() + ' ' + > > response.getDetailedMessage()); > > return; > > } > > data = response.getDataTable(); > > var table = new > > google.visualization.Table(document.getElementById('querytable')); > > table.draw(data, {'showRowNumber': false}); > > if (isFirstTime) { > > init(); > > } > > } > > > function setQuery(queryString) { > > // Query language examples configured with the UI > > query.setQuery(queryString); > > sendAndDraw(); > > queryInput.value = queryString; > > } > > > google.setOnLoadCallback(sendAndDraw); > > > function init() { > > isFirstTime = false; > > (new > > google.visualization.Table(document.getElementById('table'))).draw(data, > > options); > > queryInput = document.getElementById('display-query'); > > } > > > function setQueryFromUser() { > > setQuery(queryInput.value); > > } > > > // Apply query language. > > query.setQuery('SELECT A,B,D ORDER BY A DESC'); > > > </script> > > </head> > > <body style="font-family: Arial; border: 0 none;"> > > <div style="margin-bottom: 10px; padding: 5px; border: 1px solid gray; > > background-color: buttonface;"> > > <span> Test-Table </span> > > > </div> > > <table style='width: 100%;'> > > <tr> > > <td style="width: 50%; padding: 10px; vertical-align: left;"> > > <div id="querytable"></div> > > </td> > > </tr> > > </table> > > </body> > > </html> -- 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.
