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

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.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms