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
688 stars 95 forks source link

Error installing function in custom excel add-in #5061

Open diericd opened 2 weeks ago

diericd commented 2 weeks ago

Provide required information needed to triage your issue

We have developed an Excel Add-In. 2-3 weeks ago it was working fine with the online version of excel. We have not made any change but at 28/10/2024 we noticed that the add-in stop working with the error "error installing functions".

https://appsource.microsoft.com/en-us/product/office/WA200005426

Your Environment

Expected behavior

Custom functions are loaded available from the the add-in.

Current behavior

After the workbook is loaded we get the error "Error installing functions"

Steps to reproduce

  1. Install the "Factry Historian" Add-In https://appsource.microsoft.com/en-us/product/office/WA200005426
  2. The add-in is loaded correctly together with the custom functions
  3. reload the page
  4. We get the error: "Error installing function" and the custom functions are not avaible image

Aditonal info

the manifist url: https://portal.factry.cloud/download/excel-addin/1.0.0/manifest.xml The add-in was bootstrapped yeo-man generator with these options: ? Choose a project type: Excel Custom Functions using a Shared Runtime ? Choose a script type: TypeScript

Link to live example(s)

  1. https://factryio-my.sharepoint.com/:x:/g/personal/diericd_factry_io/EY9eFefufKdNusIYYlBU7CcBY8GcCMvD9FApjUO2kVyAYQ?e=V4odWK

Useful logs

RuizhiSunMS commented 2 weeks ago

Thank you for reporting this issue. It has been put on our backlog #9517235 , the team will investigate and we will reply to you as soon as there is any progress. Thank you for your patience.

RuizhiSunMS commented 1 week ago

@diericd, would you please have a try from your side now? The addin was installed successfully from our side with two different devices.

diericd commented 1 week ago

@diericd, would you please have a try from your side now? The addin was installed successfully from our side with two different devices.

Hi, there isn't a problem with installing the add-in. The problem is that the add-in's custom functions are not loaded when it is already installed and you REFRESH the page: (this issue only occurs on the web version of excel)

image

I've just retested and still have this issue.

Thanks!

RuizhiSunMS commented 1 week ago

@diericd, would you please have a try from your side now? The addin was installed successfully from our side with two different devices.

Hi, there isn't a problem with installing the add-in. The problem is that the add-in's custom functions are not loaded when it is already installed and you REFRESH the page: (this issue only occurs on the web version of excel)

image

I've just retested and still have this issue.

Thanks!

weird... In the morning things went good from our side but this time it occurred again... Have confirmed with team members to go on investigation.