Excel Footer Page Number Is Printed Based on Each Sheet in AutoVue
Last updated on JULY 05, 2017
Applies to:Oracle Autovue for Agile Product Lifecycle Management - Version 20.2.2 and later
Oracle AutoVue Electro-Mechanical Professional - Version 20.2.2 and later
Oracle AutoVue 2D Professional - Version 20.2.2 and later
Oracle AutoVue 3D Professional Advanced - Version 20.2.2 and later
Information in this document applies to any platform.
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.
There are following Excel file :
Sheet 1 : 1 page , Sheet 2 : 2 page , Sheet 3 : 3 page . Total of 6 page on 1
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.
Excel footer page number is printed from the total book.
- Create an Excel file that have multiple page per sheet.
- From the Excel application
Print > Print Preview > Page Setup > Header / Footer tab
- Press Custom Footer button
%Page number / %Total Page number
- Open the Excel file from AutoVue
- Print the Excel file. On print preview, set Native settings (from file) :checked.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms