Title: Timeout while loading Spreadsheet Last modified: August 30, 2016 --- # Timeout while loading Spreadsheet * Resolved [glatze1001](https://wordpress.org/support/users/glatze1001/) * (@glatze1001) * [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/) * Hi Meitar, Again – I love your plug-in and support. Last question: My google spreadsheet calculates about 5 seconds after I open it since I download few google finance data. * [https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0](https://docs.google.com/spreadsheets/d/1BRCq_ZwBzO_oP4kRcU91id4qhyZzQ5Flvvp5qX6HKos/edit#gid=0) * I seems that your spreadsheet viewer does not allow for that time to fully calculate. Hence the charts does not open because of missing data. If I have the spreadsheet open while I go to my webpage, the charts appear correctly. * [http://www.invest-to-retire.ch/portfolio/](http://www.invest-to-retire.ch/portfolio/) * Any chance to set a timeout before the spreadsheet viewer displays my charts or is it possible to open the spreadsheet in the background while visitng the webpage? * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) Viewing 8 replies - 1 through 8 (of 8 total) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/#post-6551734) * I appreciate that you “love my support,” but you really should read the documentation for the software you use. I have answered the same questions you’re asking [_numerous_](https://wordpress.org/support/topic/some-cells-blank-loading-csv-file-from-other-than-google-docs?replies=8#post-7364258) different [times](https://wordpress.org/support/topic/error-on-refresh?replies=8#post-6971254) in prior posts on this forum and even in the documentation itself. Simple google searches are sufficient for finding these answers. * That said, you can use the `http_opts` attribute in this plugin’s shortcode to set a timeout for retrieving some data. The `http_opts` attribute of the `[gdoc]` shortcode maps to all the standard [WordPress HTTP API](https://codex.wordpress.org/HTTP_API) options of the various WordPress core `wp_remote_*()` functions. * The HTTP API option you’re looking for is the `timeout` option. For a 20 second timeout instead of the default 5 second timeout, use: * ``` [gdoc key="ABCDEFG" http_opts='{"timeout":20}'] ``` * Thread Starter [glatze1001](https://wordpress.org/support/users/glatze1001/) * (@glatze1001) * [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/#post-6551739) * Wooh! I tried to solve this issue for over a month. Ok. Will stop bothering you. Thanks again! * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/#post-6551741) * Cool, glad it’s solved for you now. It’s not that I’m bothered by questions so much as it’s just that I’m frustrated by being asked _the same questions_ I’ve answered before multiple times (which I think is a pretty reasonable human reaction). * If you have suggestions for how to make these answers clearer or even easier to find than they already are, let me know. 🙂 * Thread Starter [glatze1001](https://wordpress.org/support/users/glatze1001/) * (@glatze1001) * [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/#post-6552000) * Hi Meitar, * Unfortunately this did not solve the issue. I just had the content stored in cache. * Again: My spreadsheet needs about 10 seconds to calculate, but the spreadsheet viewer does not allow the sheet to fully calculate before it displays the content. My Sheet actually delivers values, but they are wrong since I am downloading data via Google Finance. So the your plugin should wait 10s and only then display. * With the timeout command the content of the webpage is not delayed, it is displayed more or less immediatly. It does not matter if I give a 10s or a 60s timeout. * Thread Starter [glatze1001](https://wordpress.org/support/users/glatze1001/) * (@glatze1001) * [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/#post-6552002) * Find below an example:¨ [http://www.invest-to-retire.ch/portfolio/](http://www.invest-to-retire.ch/portfolio/) * Thread Starter [glatze1001](https://wordpress.org/support/users/glatze1001/) * (@glatze1001) * [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/#post-6552003) * The issue seems that google finance returns the value “loading” while closing prices are downloaded. So your plug-in regards the sheet as ready. * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/#post-6552016) * This plugin works by asking google to export whatever content it has available and displaying that. Sorry if that’s not working out the way you’d expect; I’m not going to change the plugin to accommodate this edge case. You can alternatively write a Google Apps script that does the appropriate post-processing you need and then point this plugin to the endpoint for your script. * Bottom line: I consider this expected behavior and will not address ti further. * Thread Starter [glatze1001](https://wordpress.org/support/users/glatze1001/) * (@glatze1001) * [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/#post-6552017) * Good Morning Sir, Just relax: A simple delay before displaying would do the job. Any change that this funcion is already provided by google and I with my meodiocre IT knowledge does not know? Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Timeout while loading Spreadsheet’ 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/) * 8 replies * 2 participants * Last reply from: [glatze1001](https://wordpress.org/support/users/glatze1001/) * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/timeout-while-loading-spreadsheet/#post-6552017) * Status: resolved