-
Notifications
You must be signed in to change notification settings - Fork 117
Description
Centralized mode - Triggering range.calculate intermittently triggers errors
An 'ItemNotFound' is intermittently raised while triggering a range calculate from a ribbon action
It doesnt happen with same addin in side load mode
Your Environment
- Platform: PC desktop
- Host : Excel
- Office version number: Microsoft® Excel® for Microsoft 365 MSO (Version 2510 Build 16.0.19328.20266) 64-bit
- Operating System: Microsoft Windows 11 Enterprise 10.0.26100 Build 26100
Expected behavior
range.calculate() shouldnt trigger any error
Current behavior
Intermittently the calculate triggered from a ribbon button is causing an error during the Calculate call :
excel-win32-16.01.js:25 Uncaught (in promise) RichApi.Error: The requested resource doesn't exist.
at new n (excel-win32-16.01.js:25:268587)
at n.processRequestExecutorResponseMessage (excel-win32-16.01.js:25:333822)
at excel-win32-16.01.js:25:331883
Steps to reproduce
A sample addin codebase to replicate the issue is available : https://github.com/dajduprat/rangecalc
- The addin has to be deployed in centralized mode
- Load the addin
- Insert a sample entity from taskpane with Run link
- An entity is inserted in A1
- Repeat several clicks on Calculate range after selecting the A1 range
Link to live example(s)
- https://github.com/dajduprat/rangecalc/blob/main/src/commands/commands.js#L83
- Currently deployed in github using this manifest
Provide additional details
- A workaround consists of retrieving again the same range done here : https://github.com/dajduprat/rangecalc/blob/main/src/commands/commands.js#L67
-
-
Context
For our internal assets and functions we need to trigger calculate call on specific ranges
Useful logs
-
Console errors
excel-win32-16.01.js:25
Uncaught (in promise) RichApi.Error: The requested resource doesn't exist.
at new n (excel-win32-16.01.js:25:268587)
at n.processRequestExecutorResponseMessage (excel-win32-16.01.js:25:333822)
at excel-win32-16.01.js:25:331883
n @ excel-win32-16.01.js:25
(anonymous) @ excel-win32-16.01.js:25
(anonymous) @ excel-win32-16.01.js:25 -
Screenshots
Thank you for taking the time to report an issue. Our triage team will respond to you in less than 72 hours. Normally, response time is <10 hours Monday through Friday. We do not triage on weekends.