When using the automation API to add annotations in OnlyOffice, it works in Word but encounters issues in Excel. The annotations are not bound to the cells. What could be the reason for this?

Docs API
1

image
image881×687 90.8 KB

The content within the blue box was added through OnlyOffice, while the content within the red box was added through Automation API
image
image789×407 32.1 KB

2

Hello, @dingnan !

Please try using the range-based Spreadsheet API example from the documentation for cell-bound comments: AddComment | ONLYOFFICE

This method is intended for adding a comment to a specific cell/range in a spreadsheet. Please test it on your side and let us know whether it works correctly in your case.

3

This method is useful, but previously when I was working with doc documents, I could pass a custom parameter, UserData, through AddComment to save the business data I needed to use. When needed, I could retrieve this parameter through annotations. However, after switching to this method in Excel, I can no longer pass custom parameters. Is there a more suitable approach?

image
image667×437 32.2 KB