Data is displayed before the spreadsheet calculation is done

You cannot export some formulas from Google Sheets; this is a limitation of Google Sheets itself. The http_opts parameter determines the timeout for how long to wait for all data to arrive from Google during an export, not delay before retrieving data.

Also, there is no Inline Google Spreadsheet Viewer output showing on the page you linked.

Thank you for your quick answer.
Sorry about the link I gave, I forgot it was a members-only page (that doesn’t display any spreadsheet if no member has logged in).

At the moment I cannot reconstruct the problem after editing the spreadsheet itself (which probably created new default values and all are displayed correctly)

Is there a workaround? a way to delay before retrieving data?

I understand it’s not the proper use, but spreadsheets sometimes take time to calculate (actually I can’t understand why in most cases the retrieved data is correct before the calculation is done and sometimes not – any thoughts?)

Thanks again,
Dana.

You’re still misunderstanding how this system works.

When you use formulas in a Google Sheet, Google will calculate the results of those formulas when a visitor views the spreadsheet via a page on a part of Google.com. Those formulas are not evaluated when you export a spreadsheet’s contents, which is how this plugin works. Therefore, you cannot use certain formulas with this plugin, end of story. This is a limitation of Google Sheets and there is no way to change that short of petitioning Google to support formulas in exported data sets.

OK, thanks.