[Solved] Printout doesn't include last rows

Discuss the spreadsheet application
Locked
johnewbie
Posts: 12
Joined: Thu Mar 08, 2018 3:51 pm

[Solved] Printout doesn't include last rows

Post by johnewbie »

Solved !I have a spreadsheet listing books and authors I have read. When I update it with additional books, I sort the whole list to sort by book names A to Z. Then when I print the entire new list, the last sheet will not print. I scroll down and find 10 sheets but when I print, only 9 are shown on the print command and only 9 print. I even tried to use a different sorting and the same thing happens. John
Last edited by robleyd on Tue Feb 18, 2025 1:19 am, edited 2 times in total.
OpenOffice 4/Windows 10
FJCC
Moderator
Posts: 9624
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Printing spreadsheet

Post by FJCC »

It's hard to say without seeing the document. Do you have the list on ten separate sheet tabs or does it simply print on 10 pages from one spreadsheet tab?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
johnewbie
Posts: 12
Joined: Thu Mar 08, 2018 3:51 pm

Re: Printing spreadsheet

Post by johnewbie »

One spreadsheet, lines 1,2,3 etc filling 10 sheets when I look at the list. When I print this, it only prints the first 9 pages. I am not a Computer Guy, so I don't know how to explain this. John
OpenOffice 4/Windows 10
FJCC
Moderator
Posts: 9624
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Printing spreadsheet

Post by FJCC »

I'm not sure what you mean by "when I look at the list". What list is that?
If you select the menu item Format -> Print Ranges, is the Remove option active? If so, remove any print ranges.
When you select the menu File -> Print, on the General tab, is All Pages selected?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
johnewbie
Posts: 12
Joined: Thu Mar 08, 2018 3:51 pm

Re: Printing spreadsheet

Post by johnewbie »

"All Pages" was not selected. Thanks! John
OpenOffice 4/Windows 10
Locked