Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Even basic custom functions show only #BUSY on Excel #1052

Open
pasunmaa opened this issue Apr 7, 2024 · 5 comments
Open

Even basic custom functions show only #BUSY on Excel #1052

pasunmaa opened this issue Apr 7, 2024 · 5 comments
Labels
custom-functions P0 Fix Immediately

Comments

@pasunmaa
Copy link

pasunmaa commented Apr 7, 2024

ScriptLab has recently updated After that custom functions stopped working. They only show #BUSY.
Microsoft announcement: https://devblogs.microsoft.com/microsoft365dev/update-on-the-future-of-the-script-lab-office-add-in/

Even most simple functions do not work. E.g.
/**

  • Doubles the number
  • @customfunction
  • @param {number} num
  • @returns the number
    */
    function double(num) {

return num *2;
}

Bug Report

  • Host: Excel for Mac, Version 16.83 (24031120) + Excel for Web
  • OS: MacOS Sonoma, Version 14.4.1; node.js v20.12.1
  • Browser: Chrome Version 123.0.6312.107 (Official Build) (x86_64)
  • Environment: (fill out. eg: alpha, beta, prod)

Expected behavior:

Simple custom function would return the correct value from Javascript immediately.

Actual behavior:

I can see only #BUSY in the excel cell

Steps to Reproduce:

  1. Register the function in ScriptLab
  2. Call the function from excel cell
  3. I tried to remove ScriptLab and reinstall it, but it looks like to be removed, but when I restart excel, it appears automatically back.

Failure Logs:

Screenshot:

@wandyezj
Copy link
Member

wandyezj commented Apr 8, 2024

Hello @pasunmaa

Thank you for reporting this issue.

We are working on a fix.

@wandyezj wandyezj added the P0 Fix Immediately label Apr 8, 2024
@wandyezj
Copy link
Member

wandyezj commented Apr 8, 2024

Hello @pasunmaa

I have deployed a fix.

To verify you have the latest update:

  1. Open the Edit taskpane
  2. Click settings (gear on lower right side)
  3. Click About
  4. Check that the Last Updated is Mon, 09 Apr 2024

Please let me know if you are still seeing this issue.

@pasunmaa
Copy link
Author

pasunmaa commented Apr 9, 2024

I'm seeing
Last Updated: 'Mon, 08 Apr 2024 20:30:06 GMT'
Commit: Merged PR 2889339: Updates
Environment: CDN Production

and still getting #BUSY (on Excel for Mac). I tried to reload the plug-in from i > Reload menu.

@pasunmaa
Copy link
Author

Hello @wandyezj,

I tried to remove the add-in completely and wish to reinstall from 'empty table'. I faced other issues:
image
Add-in further information and Rate and review links do not work: "This o15.officeredir.microsoft.com page can’t be found"

When I chose remove, it disappeared gracefully from the above windows. When I press close, the script lab menu disappears too, as expected. Then exit Excel. All fine, but when I restart with excel file containing custom functions it is back again.

@pasunmaa
Copy link
Author

Back on business.
This version seems to work.
Last Updated: 'Wed, 10 Apr 2024 23:22:34 GMT'
Commit: Merged PR 2896729: Cleanup Environments
Environment: CDN Production

ping @wandyezj

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
custom-functions P0 Fix Immediately
Projects
None yet
Development

No branches or pull requests

2 participants