Data is displayed before the spreadsheet calculation is done

Resolved danamedina
(@danamedina)

7 years, 11 months ago

I am working with your plugin for a while, and a new problem had occurred:
It seems that it takes longer for the google spreadsheet to calculate and display the data properly, and an incorrect data is displayed.
I’m trying the same solution you described here:
https://wordpress.org/support/topic/timeout-while-loading-spreadsheet?replies=9
I’m using the http_opts='{“timeout”:20}’ parameter, but the data is still being displayed within ~10 seconds, probably because an initial data is displayed in the spreadsheet itself.
I’m not sure this is an edge case anymore since I’m using a simple =TODAY() function in the spreadsheet, and it worked fine so far, but somehow now it takes longer to calculate and the data is displayed by the plugin to early.
Is there a chance you have a solution for this?
Maybe a delay as glatze1001 suggested?
Here’s the url:
http://www.nightpeople.co.il/?page_id=1709

Thanks,
Dana.

https://wordpress.org/plugins/inline-google-spreadsheet-viewer/

Viewing 4 replies - 1 through 4 (of 4 total)

Plugin Author Meitar
(@meitar)

7 years, 11 months ago

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.

Thread Starter danamedina
(@danamedina)

7 years, 11 months ago

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.

Plugin Author Meitar
(@meitar)

7 years, 11 months ago

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.

Thread Starter danamedina
(@danamedina)

7 years, 11 months ago

OK, thanks.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Data is displayed before the spreadsheet calculation is done’ is closed to new replies.