Apache OpenOffice (AOO) Bugzilla – Issue 10890
Page Number and Number of Pages are inconsistent across sheets
Last modified: 2003-09-08 16:55:29 UTC
I have a spreadsheet with two sheets, each of which is configured to print on two pages. I have "Page # of ##" in the header of each sheet. This gives "Page 1 of 4", "Page 2 of 4", "Page 1 of 4", "Page 2 of 4". ie. the "#" gives the page number within the sheet, while "##" gives the total number of pages in all sheets. I think these should either be "Page 1 of 2", "Page 2 of 2", "Page 1 of 2", "Page 2 of 2" or "Page 1 of 4", "Page 2 of 4", "Page 3 of 4", "Page 4 of 4". Even better, allow all four of these numbers to be placed in the header.
I've no idea why the author would want all four "page of page" numbers in the same header on each page. That would be useless. Perhaps a reason why?
That's not what I want. I'm just describing what appears in the printed output of each page. The "#" and "##" fields are from two different pagination systems, so putting "Page # of ##" in the header doesn't do anything useful if you have multiple sheets. I'm suggesting added two more fields (let's say "$" and "$$") so you can put "Page # of $$" or "Page $ of ##" in the header and it will either paginate within each sheet or across all sheets. Alternatively, have some way to choose the pagination system.
I can confirm it. I also have recieved a complaint about the page numbering he is talking about in workbooks. Apparently MS E%$#l does it like he is describing. Where if you put Page # of ## in the Header of a 20 page workbook and you only want to print out the 3rd sheet of a total of 4 sheets the header should read "Page 1 of 5" even though the 3rd sheet starts at page 11 and ends at page 15 of the workbook. The way it is now when you printed out the 3rd sheet the first page would read "Page 11 of 20". This feature seems to work for the first sheet as the workbook I am using displays the correct page numbering for the first sheet. If you select the entire workbook to print, only then should it list the total pages for the whole workbook. We are running Red Hat 7.2 with KDE on a thin client network.
Actually, that's not quite my problem, although that's probably a reasonable request. I can't reproduce my problem with a new document. I still have a document which exhibits the problem, but I think I imported it from StarOffice 5.2, so that may be the source of the problem. In your example, I would get "Page 1 of 20" on the first page of the third sheet.
I can confirm the first poster's problem, although I have something more to add. The page number inconsistency happens when a document has multiple worksheets with differing page styles. It should NOT happen when your document has multiple worksheets with the same page style. In such a case, when printed, the page numbers should be the way they should be: sequential across the different worksheets. When the worksheets use different page styles, the page number gets reset to 1 in the first page of each different page style. Either way, the total number of pages is always the total number of pages in the entire document. I will attach files to demonstrate this problem. So stay tuned. Kohei
Created attachment 5681 [details] Multiple worksheets with same page style
Created attachment 5682 [details] Multiple worksheets with different page styles
Hi, this is not a bug. Open the Stylist, select page styles and then the second and the third pagestyle to modify. Go to the sheet tab and untag the checkbox Start with page number. Close the dialog and have a look at the page preview. As you can see, after pressing the last page button, you get page 9 of 9. So closing as Invald. Frank
closed invalid