Issue 12710 - Page breaks do not work in Calc when you have "Fit Printout On Number Of Pages" selected
Summary: Page breaks do not work in Calc when you have "Fit Printout On Number Of Page...
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.2
Hardware: PC Linux, all
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
: 13503 52052 (view as issue list)
Depends on:
Reported: 2003-03-27 06:31 UTC by capstone737
Modified: 2010-03-24 15:28 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description capstone737 2003-03-27 06:31:04 UTC
I have a Calc spreadsheet that is 2.5 pages long, and I have selected "Fit
Printout On Number Of Pages" and chosen 4 as the maximum number. I have done
this as I plan to make changes and add data to it and it will grow somewhat.

However, when I add another page break (and so make the document 3.5 pages long
ie fit on 4 pages), the page break doesn't work and you can't see the page break
in "Page Break Preview". I have tried to increase the page number on "Fit
Printout On Number Of Pages" to 10, but it still cancels the page breaks that I
have inserted.

I have tried this in Red Hat 8.0, Windows 95 and Win2KSP3 and it is the same in
each version.
Comment 1 frank 2003-03-27 09:58:55 UTC

this works as intended.

Extract from the help system :

AutoFit printout to page number
Choose this option to specify the maximum number of pages on which the
entire document is to be printed. The document will be scaled to fit
the defined number of pages to be printed.


So this will apply if you have a sheet with data which extends the
range of pages given. In this case the data will be scaled to fit the
number of pages you have set. And therefore manual page breaks make no

Best regards

Comment 2 frank 2003-03-27 10:02:53 UTC
closed invalid
Comment 3 capstone737 2003-03-29 01:24:21 UTC
I have been trying to introduce OpenOffice at my work as a replacement
to MS Office, and this was brought to my attention my one of the
managers. He complained that you can do this in Exdel with no problems.

Is your statement, "this works as intended", final then?

Comment 4 frank 2003-03-31 09:19:32 UTC
Hi Brad,

the answer is yes. This is as Excel works in the same way !

1. Open a new excel sheet and insert some numbers to fit about 2 pages.
2. Set a manual Page break a about the second half of the 2nd page
3. Use page break preview to observe what's going on.
4. Got ot file Page Setup and set fit to pages 1 wide and 4 long. Press Ok
5. As you can see, the manual page break is gone.

Best regards

Comment 5 frank 2003-03-31 09:19:57 UTC
invalid as Excel works in the same way.
Comment 6 frank 2003-04-16 14:29:06 UTC
*** Issue 13503 has been marked as a duplicate of this issue. ***
Comment 7 bernardmoreton 2003-04-30 11:20:06 UTC
Regardless of whether Excel works in the same way, it is a nonsense 
to be able (with problematic trial and error) to scale a percentage 
reduction to fit to one page wide and retain the manual break, but 
not to be able to do it in one fell swoop with the "fit to N pages" 
necessary with an additional option to override manual page breaks.

Many thanks,
Bernard Moreton
Comment 8 niklas.nebel 2005-07-18 11:35:29 UTC
*** Issue 52052 has been marked as a duplicate of this issue. ***
Comment 9 robbk 2009-03-03 08:40:24 UTC
OK, guys, a new attempt to reopen this issue several years later. There are
circumstances where Excel and OpenOffice *do* behave differently in this regard.
Our CEO is an Excel power user and is reluctant to switch to OOo, partly due to
this issue. Say you want to fit the sheet to one page wide and you don't care
how many pages long. Excel will let you manually change the vertical page break
(row break) while remembering the "fit to page width" attribute. Calc will not.

1. Open OOo Calc and enter lots of data, both in colums and rows.
2. Choose "Format > Page > Sheet > Scale > Scaling mode: Fit print range(s) to
width/height > Width in pages: 1 > Height in pages: 400"
3. Choose "View > Page break preview"
4. Try to grab one of the page breaks with the mouse and move it. It doesn't work.
5. Choose "Insert > Manual break > Row break". Nothing happens (why isn't the
menu item greyed out?)
6. Choose "View > Normal"
7. Save the same file in Excel format and open it in Excel.
8. Choose "File > Page setup > Paper format" (I'm translating from German here
since I can't easily switch languages in MSOffice)
9. Note that it says "Scale: Fit: 1 page(s) wide and 400 page(s) high" (my
translation) indicating that the settings were correctly taken over from Calc.
10. Hit "OK".
11. Choose "View > Page break preview" (my translation)
12. Grab one of the page breaks with the mouse and move it. It works in Excel as
desired. A solid blue line is a manual page break, and a dotted blue line is a
page break determined by Excel.
13. Position the cursor in a different row and choose "Insert > Page break" (my
translation). A solid blue line is inserted at the cursor position as desired.

Please reopen this issue. Thanks.
Comment 10 robbk 2009-06-08 13:49:56 UTC
This issue was marked "invalid as Excel works in the same way". I have described
how Excel does not work in the same way (see previous post). Can someone please
look at this issue again? Or should I open a new issue? Thanks.
Comment 11 robbk 2010-01-22 07:30:08 UTC
Anyone care to comment on my last comment? I think this is a valid issue.
Comment 12 robbk 2010-03-24 15:28:46 UTC
Another attempt to have someone look at my comments and comment on them. Thanks.
Should I open a new Issue?