Excel Footer Page Number Is Printed Based on Each Sheet in AutoVue (Doc ID 2149434.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Goal

Actual Behavior
Excel footer page number is printed by each sheet in AutoVue, not from the total book.

When there is multiple sheet set with multiple pages for each sheet on Excel file, when you set a footer with "page number / total page number", it will be printed with the total page that exists in the Excel book. However, this rule does not apply when printing on AutoVue. In AutoVue, print it with Native settings (from file) checked on print properties, it will print the footer with page number within each sheet.

For example,

There are following Excel file :

Sheet 1 : 1 page , Sheet 2 : 2 page , Sheet 3 : 3 page . Total of 6 page on 1
Book

All sheet is set with footer setting to display "page number / total page number" In above case, when printing the Excel file, the footer will display

x / 6

x is the page number. Since there are 6 page in total for this Excel book, it will show total page number 6. When you print the Excel file in AutoVue, it will show

x / y

x is the page number within the Excel sheet / y is the total page number within the Excel sheet. For Sheet 1 it will be printed as 1/1. For Sheet 2 it will be printed as 1/2 , 2/2.

Expected Behavior
Excel footer page number is printed from the total book.

Step

1. Create an Excel file that have multiple page per sheet.
2. From the Excel application
   
   Print > Print Preview > Page Setup > Header / Footer tab
   
   
3. Press Custom Footer button
4. Select
   
   %Page number / %Total Page number
   
   
5. Open the Excel file from AutoVue
6. Print the Excel file. On print preview, set Native settings (from file) :checked.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.