Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I print (or export to PDF), some cells has value Loading... instead of actual value. It looks like Google Spreadsheet was still calculating values when it converted document to a PDF, although they are already calculated on my screen.

Is there any way to force to Google Spreasheet to finish calculations before it converts it to PDF?

share|improve this question
Have you tried Ctrl+r first? Do such cells have external links? Might you copy, Paste special, Paste values only before export? – pnuts Aug 28 '14 at 12:49
Thanks, a figured a workaround with paste special too, but it's note very convenient... I hoped there is some bette solution :) – Paulius Liekis Aug 28 '14 at 16:12
Would you mind to detail the steps that you followed in order to reproduce this? I'm thinking that if you're using Google Spreadsheet's export to PDF feature and you're getting that behavior, that may be an actual bug to report to them. – Alpha Sep 2 '14 at 22:08
Well I wrote some script functions which take long time to execute. I'll see if I can still reproduce this problem. – Paulius Liekis Nov 20 '14 at 22:08
I can not reproduce it right now. I'll see if it comes up again during actual use of these sheets – Paulius Liekis Nov 20 '14 at 22:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.