[Asc.plugin.callCommand] is invalid in plugin

Plugins
, , ,
1

I am preparing to load an Excel document containing multiple sheet pages. In the plugin, I wrote the callCommand command in the init method to try to cut the Excel document to the specific sheet index page, but I failed. This code did not take effect. I have looked at the official document example, but I am not sure if it is due to my configuration error or if my community version does not support it. I urgently need your help. Thank you

(function (window, undefined) {
  var AscPlugin = window.Asc.plugin;

  AscPlugin.init = function (initData) {
     Asc.plugin.callCommand(
        () => {
          const targetSheet = Api.GetSheet('sheet2'); 
          targetSheet.SetActive(); // Activate specific sheet pages
        },
        true,
        true,
        (returnValue) => {}
      );
  };
})(window, undefined);

my onlyoffice version: community 8.2.2.22
Doesn’t the community support plugin usage?
Why isn’t this method executed

2

Hello @hulianzaixian123

Plugins are supported in all versions, however, you are using outdated one. Please update your instance to the actual version 8.3.2 and check the situation again.

UPD: Due to current recalculation logic, setting sheet as active is considered to be a change, but it is not getting rendered automatically after callCommand call. To fix it, please add calculation to the end of callCommand and check if it works for you:

(function (window, undefined) {
  window.Asc.plugin.init = function () {
    Asc.plugin.callCommand(function () {
        const targetSheet = Api.GetSheet("Sheet2");
        targetSheet.SetActive(); // Activate specific sheet pages
        Api.asc_calculate(1);
      }, true, true, (returnValue) => {}
    );
  };
})(window, undefined);
4

I tried it, but when the Excel document was initially loaded, it still didn’t automatically switch to the specific sheet page, and the asc_calculate method didn’t take effect. Is this method supported in version 8.2? Or what should I do if I want to automatically switch to a specific sheet page after the initial loading of an Excel document? Is there corresponding code support? Thank you

5

Would you mind sharing your current implementation for better understanding?

UPD: Also, please specify in which product you intend to use the plugin, e.g. Desktop Editors or Document Server.

6

hello@Constantine ,Thank you for your patience
I just tried it out and the code miraculously worked. It’s strange, thank you very much

1 Like
7

I am glad to know.