context.sync() Silently Errors After context.workbook.names.load("items") Inside A Named Item Binding

[nickamckenna]

Provide required information needed to triage your issue

Sample Project: demo.zip

For the web version of Excel, if you create a binding using:

context.workbook.bindings.addFromNamedItem(...)

and then in the callback try to do this:

evt.binding.context.workbook.names.load("items");
await evt.binding.context.sync();

officejs silently fails. It does not throw an Exception or return an error. Nothing appears in the console log.

The same problem happens if I try:

const ni2 = evt.binding.context.workbook.names.getItem(newName);

Your Environment

• Platform [PC desktop, Mac, iOS, Office on the web]: Office on the Web
• Host [Excel, Word, PowerPoint, etc.]: Excel
• Office version number: Build 16.0.18417.42305
• Operating System: Windows 11
• Browser (if using Office on the web): Chrome, Edge

Expected behavior

I should be able to retrieve NamedItem objects inside a binding creating against a NamedItem.

Current behavior

OfficeJs fails silently with no error thrown and no information provided.

Steps to reproduce

1. Use the attached sample project demo.zip
2. npm run dev-server
3. Install the Add-In manifest.xml in Excel for the Web
4. Open the Taskpane
5. Type "test1" in a cell in Column C
6. Select the cell you have just typed in
7. Click "Add A Binding To Current Cell" in the TaskPane
8. Insert a column in Excel before Column C (to trigger the callback)
9. Notice that the console.log contains messages "a" and "b", but not "c" or "d" and no error is reported

Link to live example(s)

1. Project attached to this bug report demo.zip

Provide additional details

1. As detailed above

Context

Our Excel Add-In tracks changes to cells. We need to be able to access the NamedItem inside the handler to manage bindings and perform other operations.

Useful logs

demo.zip

[microsoft-github-policy-service]

Thank you for letting us know about this issue. We will take a look shortly. Thanks.

[nickamckenna]

A bit more information. I get the same problem if I try:

const range = evt.binding.getRange();
await evt.binding.context.sync();

[RuizhiSunMS]

Mark it as #9643607 into our backlog