search

OfficeDev / office-js

A repo and NPM package for Office.js, corresponding to a copy of what gets published to the official "evergreen" Office.js CDN, at https://appsforoffice.microsoft.com/lib/1/hosted/office.js.
https://learn.microsoft.com/javascript/api/overview
Other
690 stars 95 forks source link

Task pane stays empty for specific workbooks - since last semi-annual update #3223

Open Alex0cean opened 1 year ago

Alex0cean commented 1 year ago

Provide required information needed to triage your issue

Since last semi-annual update, task pane stays empty for our add-in if you open a workbook which contains a function which is calculated at opening time. Happens only on Excel Windows desktop app. Previous semi-annual version was also working fine. User has to manually reload the task pane, then it works again. Seems to be a regression!

Your Environment

Steps to reproduce

  1. Deploy SAP Analytics Cloud add-in: https://appsource.microsoft.com/en-us/product/office/WA200000169?tab=overview&exp=ubp8
  2. open attached workbook (contains custom function including INDIRECT formula which is calculated on opening the workbook.
  3. Try SAP Analytics Cloud -> Sign-in
  4. Task pane opens, but stays empty. You can now reload it from the side context menu, then it works again.

MSTaskpaneIssueWorkbook.xlsx

donlvMSFT commented 1 year ago

Hi @Alex0cean , I want to confirm the Semi-annual version is Version 2208? I tried the steps but couldn't repro, I get the result that the version is not supported. image

Alex0cean commented 1 year ago

Hi @donlvMSFT ,

in version Semi-Annual Enterprise Channel 2208 15601.20578, it throws the error. It used to work in Semi-Annual Enterprise Channel 2202 14931.20944 without issues.

If you get the "not supported" message, I assume you are using IE runtime, not WebView2, right? The add-in is not supporting IE anymore.

Best, Alex

donlvMSFT commented 1 year ago

This issue is been fixed on latest office version, and Product group is working on triage on SA channel.