[Solved] Calc not printing specific sheets from book

Discuss the spreadsheet application
Locked
rwscid
Posts: 4
Joined: Mon Jan 25, 2016 10:53 pm

[Solved] Calc not printing specific sheets from book

Post by rwscid »

 Edit: Split from Calc not printing specific sheets from book because your problem is different. For you, Print Preview doesn't show the sheet. In the other topic Print Preview does show the sheet. Please do not post in another's topic unless you are helping to solve their problem for them.
-- MrProgrammer, forum moderator  

This problem just popped up for me, also. Open Office version 4.1.15

I copied a sheet to a new sheet. Made some minor adjustments to the header. moved new sheet to the left of the original sheet.

Print Preview does not show me the new sheet, still shows all the original sheets.

Print does the same thing.

Very frustrating, I've never encountered this problem before.
Last edited by Hagar Delest on Thu Feb 06, 2025 9:09 am, edited 1 time in total.
Reason: tagged solved.
OpenOffice 4.1.0
Windows Vista
User avatar
RoryOF
Moderator
Posts: 35210
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc not printing specific sheets from book

Post by RoryOF »

Try Saving the modified file, Close and re-open.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
User avatar
Lupp
Volunteer
Posts: 3756
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Calc not printing specific sheets from book

Post by Lupp »

Are there >Format>Print Ranges set for the "old" sheets?
Print ranges aren't copied with the sheet.
This is the case with AOO 4.1.7.
Recent LibreOffice behaves differently.
On Windows 10: LibreOffice 25.8.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
rwscid
Posts: 4
Joined: Mon Jan 25, 2016 10:53 pm

Re: Calc not printing specific sheets from book

Post by rwscid »

Two problems solved - Print Preview and Print now both working correctly, after closing and re-opening. Thanks Lupp!
OpenOffice 4.1.0
Windows Vista
Locked