Timeout while loading Spreadsheet

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 different times 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 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}']

Wooh! I tried to solve this issue for over a month. Ok. Will stop bothering you. Thanks again!

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

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.

Find below an example:¨
https://www.invest-to-retire.ch/portfolio/

The issue seems that google finance returns the value “loading” while closing prices are downloaded. So your plug-in regards the sheet as ready.

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.

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?