Failed to edit cells after setSelectedDataAsync in Excel

Question

I am developing an add-in for Excel using the Office add-ons platform. In this add-in, I write data to a range using the setSelectedDataAsync ** function. It works fine, but after the data is written, I cannot delete or edit the cells (although I can select new ranges) if I did not click anywhere outside the worksheet or double-click the cell. I think the problem is that Excel does not restore focus correctly (the file name at the top of the application remains gray).

Some users seem to think that Excel is becoming irrelevant, which is a problem.

Is this a known issue? Is there any work for this?

** I noticed that setSelectedDataAsync is the path, the path is faster than setting range.values ​​to the matrix, and then ctx.sync (). Am I losing some important functions without using the last method?

Answer 1

This is not a known problem (could not contact the sheet after installing the data). We can consider this.

, setSelectedDataAsync , . values . , , , , .., () . , , .

API ; Excel1.1 ​​ Office 2016, , .

setSelectedDataAsync() API , Excel, Word .., , , , ..