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
[Solved] All Sheets not showing in Page Preview
[Solved] All Sheets not showing in Page Preview
Last edited by Hagar Delest on Mon Mar 21, 2011 5:34 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OpenOffice ver 3.3, Windows 7
Re: All Sheets not showing in Page Preview
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 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
Re: All Sheets not showing in Page Preview
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
Re: [Solved] All Sheets not showing in Page Preview
ok - got it - but it didn't help - but solved as in last reply.
OPenOffice 4.1.1 on Windows 7