Page 1 of 1
[Solved] All Sheets not showing in Page Preview
Posted: Mon Mar 21, 2011 3:29 am
by steverd
I have created a spreadsheet with 13 sheets. When I select all sheets and open the preview only 11 sheets are shown. Can someone get me going in right direction. I am familar with spreadsheets, most of my work was with MS Office. Now retired and cannot afford Office.
Thanks for any help. Using OpenOffice 3.3 on Win 7
Re: All Sheets not showing in Page Preview
Posted: Mon Mar 21, 2011 5:35 am
by thomasjk
The print preview is page based. Do you have a print range on each sheet? Use Format-->Print Ranges Define and under Tools-->Options-->Openoffice.org Calc-->Print Uncheck "Print only selected sheets".
Re: All Sheets not showing in Page Preview
Posted: Mon Mar 21, 2011 3:56 pm
by steverd
Tom, Thanks for the response. This solved my problem. I did not remember setting the print range on the 11 sheets that would show, reset print range on all sheets and everything now works fine.
Re: [Solved] All Sheets not showing in Page Preview
Posted: Thu Nov 28, 2013 11:11 am
by jimbokea
ok - got it - but it didn't help - but solved as in last reply.