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




