Tuesday, March 27, 2012

yogi_Print A Live Form With Its Fancy Fonts And Theme Image Applied To The Form

Yogi Anand, D.Eng, P.E.                Google Spreadsheet          Post  #490         www.energyefficientbuild.com

user msheffield said: How can I print a survey from live form? I'd like to have a physical version of my 'live form' survey, but it prints really awkwardly, without the fancy heading. Is there any way to print this in its fancy form? 
Thanks!! 
-------------------------------------------
You can not directly print the Live Form
1) with its fancy font(s) used in creating the FORM
    that the user sees  
    nor can you directly print the Live Form
2) with the theme image that you may used in the FORM
    that the user sees
a workaround to print the FORM in WYSIWYG (what you see is what you get) is to save an image of the FORM, then load it in a graphics program, and print it from there as described in the following solution to the problem

To view how the FORM with its fancy fonts and the theme image applied to the FORM looks like ...
from within the spreadsheet ...
  • click on Form
  • click on Embed form in a web page
  • then look at following dialogBox that pops up, and
  • click on the hyperlink where it says ... you can view the published form here


and up pops the beautiful Form with its fancy fonts and the theme image that was applied to the Form


now we want to print this beautiful form ... right? ... so let us press Ctrl P to print the form ... in the following image I show the print dialog box with an image of the form that would be printed ... oh oh no fancy fonts no theme image that was applied to the Form


and in the following I present the  image of the form that got printed after pressing Ctrl P or if you got to the print dialog box some other way


So, what do we need to do to print our form with its fancy fonts and the theme image is ...

  • to copy the image (or take a screen shot) of the portion of the form that we want to print or save it as a graphic file, then
  • go to our graphics program such as irfanView or some other favorite program of yours, and paste the copied image or open the saved file, and then
  • print from there
In the following I present an image of the form that I printed with its fancy fonts and the theme image that was applied to the form