[Solved] All Sheets not showing in Page Preview

Discuss the spreadsheet application

[Solved] All Sheets not showing in Page Preview

Postby steverd » Mon Mar 21, 2011 3:29 am

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
Last edited by Hagar Delest on Mon Mar 21, 2011 5:34 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice ver 3.3, Windows 7
steverd
 
Posts: 2
Joined: Mon Mar 21, 2011 3:11 am

Re: All Sheets not showing in Page Preview

Postby thomasjk » Mon Mar 21, 2011 5:35 am

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".
Tom K.
Windows 7 Home Premium
LibreOffice 4.2.3.3
thomasjk
Moderator
 
Posts: 3602
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: All Sheets not showing in Page Preview

Postby steverd » Mon Mar 21, 2011 3:56 pm

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.
OpenOffice ver 3.3, Windows 7
steverd
 
Posts: 2
Joined: Mon Mar 21, 2011 3:11 am

Re: [Solved] All Sheets not showing in Page Preview

Postby jimbokea » Thu Nov 28, 2013 11:11 am

ok - got it - but it didn't help - but solved as in last reply.
OPenOffice 3.3 on Windows XP professional
jimbokea
 
Posts: 55
Joined: Fri Jul 15, 2011 1:10 am


Return to Calc

Who is online

Users browsing this forum: Richarda44 and 30 guests