addDefinedName and removeDefinedName do not trigger actionComplete.

As mentioned in subject, operations on defined names does not trigger actionComplete handler which is not desired, especially when doing collaborative editing. Is that a bug or am I missing something?

My workaround:

spread.on("workbookFormulaOperation", ({ action }) => {
          const actions = [
            "addDefinedName",
            "removeDefinedName"
            "refreshNamedRange",
            "initiateDefinedNames",
          ];
          
          if (actions.some(a => a === action)) {
            // handle
          }
});

2 Replies

SP Sangeetha Priya Murugan Syncfusion Team May 3, 2021 03:06 AM UTC

Hi Marek, 
 
Thank you for contacting Syncfusion support. 
 
We have checked your reported requirement and we confirmed this as improvement and the fix will be available in our Essential studio volume 3 2021 release. we appreciate your patience until then. You can track the status of this improvement using below link from our feedback portal,  
 

Regards, 
Sangeetha M 



AS Aravinthan Seetharaman Syncfusion Team October 5, 2021 08:40 AM UTC

Hi Marek, 
 
We are glad to announce that our Essential Studio 2021 Volume 3 release v19.3.0.43  is rolled out and is available for download under the following link. In this release we have included the improvement [Need to trigger actionComplete event for definedRange actions in spreadsheet] 
  
 
 
 
We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 
 
Regards, 
Aravinthan S

Loader.
Up arrow icon