Title: Inline Google Spreadsheet Viewer problem Last modified: December 16, 2016 --- # Inline Google Spreadsheet Viewer problem * Resolved [dorinand2112](https://wordpress.org/support/users/dorinand2112/) * (@dorinand2112) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/) * Hello, * I trying to create chart from my spreadsheet. I would like to take just one column from all (the B one). So I try use query like this: query=”select B” * But nothing change. I also try other alternatives like limit but my chart still take all columns. Can anybody help me? Viewing 12 replies - 1 through 12 (of 12 total) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8558429) * On this forum: * * [“query” part is ignored](https://wordpress.org/support/topic/query-part-is-ignored/#post-8268210) * [Diffculties with “query” option](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-diffculties-with-query-option/)* [Query not working](https://wordpress.org/support/topic/query-not-working-3/) * Please search for existing answers to your question before making a new posting. - This reply was modified 9 years, 5 months ago by [Meitar](https://wordpress.org/support/users/meitar/). * Thread Starter [dorinand2112](https://wordpress.org/support/users/dorinand2112/) * (@dorinand2112) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8566849) * Hello, * of course I read about my problem first. I learn from [this](https://maymay.net/blog/projects/inline-google-spreadsheet-viewer/) site. And also read another examples from internet and “Other Notes” from plugin download site. I use the whole URL address in key attribute, my chart is displayed. My problem is that I would like to show only e.g. third column but the plugin always show all columns. It not react on query attribute. Can anybody help me to solve this issue? My version of wordpress is 4.7. The plugin is compatibile up to 4.6.1. Could this be a problem? * Here is example of my code: * [gdoc key=”whole address to my spreadsheet” chart=”Column” title=”Title” query =”select A,B” ] * My table in spradsheet have 13 rows and 4 columns but on my page there is every column in my chart. Is there some problem with my code? * Thank you! * Thread Starter [dorinand2112](https://wordpress.org/support/users/dorinand2112/) * (@dorinand2112) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8571299) * Can anybody help me? * [Dustin Tantum](https://wordpress.org/support/users/tantumonium/) * (@tantumonium) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8573543) * **I suggest you:** 1) Create a dummy spreadsheet w/ some sample data, including more columns than you need to display 2) Share this dummy sheet via the plug- in instructions 3) Reply and include your actual shortcode * I and many others have no problems displaying just specified columns from a many- columned spreadsheet, so without looking at your code and spreadsheet it’s pretty tough to help you. * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8599237) * After more than aa week without a reply, I’m marking this resolved. (Thanks for your help, Dustin.) * Thread Starter [dorinand2112](https://wordpress.org/support/users/dorinand2112/) * (@dorinand2112) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8602362) * Hello, * sorry for late response, I was on vocation. * here is my shortcode: * [gdoc key=”[https://docs.google.com/spreadsheets/d/1oAXojGlqFGVMevxbXH35Wq6bau1l-r-xWjeV6TenCWc/edit#gid=0″](https://docs.google.com/spreadsheets/d/1oAXojGlqFGVMevxbXH35Wq6bau1l-r-xWjeV6TenCWc/edit#gid=0″); chart=”Column” title=”r.2016″ query=”select A,B” ] * I can see all three columns even I chose only one. I thing, the shortcode is ok. * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8602419) * [Works for me](https://i.imgur.com/Ng9rs0p.png). * Thread Starter [dorinand2112](https://wordpress.org/support/users/dorinand2112/) * (@dorinand2112) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8602672) * So why it is not working for me? This is what I see: * [https://drive.google.com/file/d/0B9TerafhhkGpVkVDcFU4b0Z5eWs/view?usp=sharing](https://drive.google.com/file/d/0B9TerafhhkGpVkVDcFU4b0Z5eWs/view?usp=sharing) * I would like to show, for example, only one column of my table. * The plugin is compatibile up to 4.6.1. but i have wordpress 4.7. Could be this the problem? What should I do to make it work for me? * Thread Starter [dorinand2112](https://wordpress.org/support/users/dorinand2112/) * (@dorinand2112) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8609602) * I have to set this incident to not resolved for 3 time. It still not working for me. Can anybody help? * [Dustin Tantum](https://wordpress.org/support/users/tantumonium/) * (@tantumonium) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8614215) * Your shortcode works fine for me as well. I would suspect that your issue is either caused by your WordPress theme (try using a default theme to test with) or another installed Plug-in (try disabling them to see if the problem persists). * Additionally, is your browser’s Console Log showing any errors? If so… what are they? * Thread Starter [dorinand2112](https://wordpress.org/support/users/dorinand2112/) * (@dorinand2112) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8617257) * Hi Dustin, * I tried this steps: 1. disable all plugins – did not help 2. default theme – did not help 3. another two themes – did not help 4. update plugins – did not work * I see in console only this warrning: * `A Parser-blocking, cross-origin script, https://www.google.com/uds/?file=visualization& v=1.0&packages=annotatedtimeline%2Cannotationchart%2Ccorechart%2Cgauge%2Ctimeline, is invoked via document.write. This may be blocked by the browser if the device has poor network connectivity.` * I think, this should not be a problem. * If you do not have any ideas, it seems that I will need a special table for each column. * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8622897) * Just in case it’s something “obvious,” make sure your shortcode is _plain text_. Using curly quotes, for instance, will not work. * Other than that, though, `¯\_(ツ)_/¯`. Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Inline Google Spreadsheet Viewer problem’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer. svg) * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq) * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/) * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/) * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/) * 12 replies * 3 participants * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/) * Last activity: [9 years, 5 months ago](https://wordpress.org/support/topic/inline-google-spreadsheet-viewer-problem/#post-8622897) * Status: resolved