Apache OpenOffice (AOO) Bugzilla – Issue 12710
Page breaks do not work in Calc when you have "Fit Printout On Number Of Pages" selected
Last modified: 2010-03-24 15:28:46 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.
Hi, 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 sense. Best regards Frank
closed invalid
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? Regards, Brad
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 Frank
invalid as Excel works in the same way.
*** Issue 13503 has been marked as a duplicate of this issue. ***
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" option. PLEASE RECONSIDER THIS AS A MOST DESIRABLE ENHANCEMENT, if necessary with an additional option to override manual page breaks. Many thanks, Bernard Moreton
*** Issue 52052 has been marked as a duplicate of this issue. ***
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.
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.
Anyone care to comment on my last comment? I think this is a valid issue.
Another attempt to have someone look at my comments and comment on them. Thanks. Should I open a new Issue?