JR64857: ?DOCUMENT RECOVERY? KEEPS SHOWING IN EXCEL 2016 SHEET WHEN USING EXCELMACRO IN RPA SCRIPT

APAR status

• Closed as program error.

Error description

• Document Recovery pane keeps showing up even when auto recovery
  option is turned off when using excelMacro command in Excel
  2016.
  
  Steps to recreate:
  Run the following sample script:
  defVar --name office01 --type OfficeApplication
  defVar --name exins --type Excel
  officeOpen --path "C:\RPA\WDGTEST.xlsx" --type "Excel"
  office01=officeapplication
  excelMacro --macro "Range("A1:A2").Merge"
  officeSave --fileformat "Default" --officeapplication
  ${office01}
  officeClose --officeapplication ${office01}
  
  Customer has also tried to disable auto recovery option on
  Excel, but the Document Recovery pane is still showing up on
  Excel 2016. It only work if they remove the excelMacro command
  from the script.
  
  Document Recovery is not displayed anymore if the auto recovery
  option is disabled on Excel 2019 and 365.
  

Local fix

• Not using excelMacro command
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Customers using commands that interact with excel            *
  * spreadsheets.                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * No further information                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• First fixed in 21.0.3 IF001
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  RPA

• Fixed component ID

  5737N5100

Applicable component levels