Printing all sheets in book

Discuss the spreadsheet application

Printing all sheets in book

Postby metehanist » Fri Apr 01, 2011 3:37 pm

Hi,

First, sorry for my bad english :(

I downloaded and installed Ooo 3.3.0 on windows xp. When i want print a sheet, calc printing all sheets in book.

I checked; "Tools > Options > Open Office Calc > Print >>> Disable empty pages for print AND Print only selected pages. (My language version is Turkish)

But, this options dont work.

And i select any cells in calc and press CTRL+P. Printing dialog cant shown "Print Selected Area"

How can i do?

Thanks,
Open Office 3.3.0 on Windows XP
metehanist
 
Posts: 2
Joined: Fri Apr 01, 2011 3:27 pm

Re: Calc; printing all sheets in book

Postby metehanist » Mon Apr 04, 2011 9:37 am

Don't have a solution or idea? :(
Open Office 3.3.0 on Windows XP
metehanist
 
Posts: 2
Joined: Fri Apr 01, 2011 3:27 pm

Re: Calc; printing all sheets in book

Postby jrkrideau » Mon Apr 04, 2011 2:34 pm

metehanist wrote:Don't have a solution or idea? :(


Reset your print range perhaps.

Format > Print Range > Edit
AOO 4.0.1, Ubuntu 13.04
jrkrideau
 
Posts: 1910
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Calc; printing all sheets in book

Postby Emmadw » Wed Apr 06, 2011 5:47 pm

I have the same problem.

I've got a spreadsheet that was created in a previous version, and have just upgraded to Open Office 3.3.0 (English).

In the past, it was relatively straight forward to select a set of cells, to then print them & just the cells on the sheet I wanted appeared. Today, I got the same cells on all the sheets. Like the original poster, I'd double checked that it was indeed "Print only selected sheets" was selected.

I also tried removing the print range & re-creating it. (several times!)

In the end, the only thing that worked was to hide the data on the other sheets - then I just got the one I wanted. From my point of view, it's not really a problem, as I don't actually need those sheets at the moment; however, I could see that if you were using the other sheets on a regular basis, it would be a pain.
Open office 3.3.
Windows XP
Emmadw
 
Posts: 2
Joined: Wed Apr 06, 2011 5:40 pm

Re: Calc; printing all sheets in book

Postby Villeroy » Wed Apr 06, 2011 6:43 pm

I can not reproduce any of the problems with any of my files nor newly created file in any version (currently I have 2.4.3 and 3.3). Apart from the new dialog layout, I can not find the slightest difference between 3.3 and older versions.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17261
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc; printing all sheets in book

Postby Emmadw » Thu Apr 07, 2011 9:47 am

Thanks ... I'll assume it's me being dense & that I've solved it by hiding the other sheets.
Open office 3.3.
Windows XP
Emmadw
 
Posts: 2
Joined: Wed Apr 06, 2011 5:40 pm

Re: Calc; printing all sheets in book

Postby Villeroy » Thu Apr 07, 2011 10:29 am

You can easily upload your problem document here. Remove any confidential content, save it under a new name and hit the "Upload attachment" tab when you post the next message.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17261
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc; printing all sheets in book

Postby seleroglu » Wed Dec 14, 2011 4:12 pm

I have the same problem. "Print only selected pages" settings doesn't work. I did reset print range several times. its working OOffice 3.2 but 3.3
OpenOffice 3.3 on Windows 2003 Server
seleroglu
 
Posts: 2
Joined: Wed Dec 14, 2011 3:54 pm

Re: Calc; printing all sheets in book

Postby seleroglu » Wed Dec 14, 2011 4:20 pm

Hi, this problem has only OpenOffice 3.3 Turkish version. it's working on OpenOffice 3.3 English version...
OpenOffice 3.3 on Windows 2003 Server
seleroglu
 
Posts: 2
Joined: Wed Dec 14, 2011 3:54 pm

Re: Calc; printing all sheets in book

Postby erm_oren » Tue Dec 27, 2011 2:56 pm

Same.

I've created a test document - sheet 1 contains the word "Page 1", sheet 2 contains "Page 2".

When printing, it always prints both in the 3.3.0 Hebrew version, but in the 3.3.0 English version it works fine.

I've noticed that the print dialog is different between the english and hebrew versions - the english version has both the "Range and copies" and "Thereof print" sections, while the hebrew version has only the "Number of copies" section. I this might be the origin of the problem, maybe a different print dialog made it through to the compilation?
OpenOffice 3.3.0 on Windows XP
erm_oren
 
Posts: 1
Joined: Tue Dec 27, 2011 2:50 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests