openFromJson() doesn't return a promise, so how do I know when it is complete?

[John]

Which event will fire after calling openFromJson() so that I can continue to manipulate the spreadsheet object.  For example:

ss.openFromJson({file: myData});
ss.hideColumn(2,2,true);   //<-- throws error about unassigned properties 



[Janakiraman Sakthivel]

Hi John, 

 

We can achieve your requirement by using the setTimeout function as shown below. 

 

[index.ts]:  

loadBtn.element.onclick = (): void => { 

        spreadsheet.openFromJson({ file: response.jsonObject }); 

        setTimeout((): void => { 

          spreadsheet.hideColumn(2,2,true); 

        }, 1000); 

    } 

  

For your convenience, we have modified your sample based on your requirement. Please find the link below. 

 

Sample Link: https://stackblitz.com/edit/ez12gm-7qmmam?file=index.ts 

 

Video Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/hide-columns-1658683193 

 

Could you please check the above links and get back to us, if you need any further assistance on this. 

 

Regards, 

Janakiraman S. 

[John]

That seems like a kludge fix to me.  So basically, I'm just guessing at how long I should wait for the task to be completed?   What if it is very large spreadsheet one time and a small one the next?   Is there no EVENT that let's me know exactly when it is complete?

[Sangeetha Priya Murugan]

Hi John, 

 

Currently we don’t have any event after openFromJson method completes. However, we will check the feasibility of this requirement and update you the further details on March 14^th, 2022. We appreciate your patience until then. 

 

Regards, 

Sangeetha M 

[Sangeetha Priya Murugan]

 

Hi John, 

 

Currently we don’t have any event after the openFromJson method completes. So, we suggest you to use the setColumn method instead of using hideColumn method. SetColumn method sets the hidden property as true in model level. When we load the Json data using openFromJson method cells are re-rendered again, so only the script error occurs. To avoid this, please use setColumn method as like as below. 

 

 

 

loadBtn.element.onclick = (): void => { 

  spreadsheet.openFromJson({ file: response.jsonObject }); 

  var sheet = spreadsheet.getActiveSheet(); 

  setColumn(sheet, 2, { hidden: true }); // set the hidden property as true for particular column in spreadsheet model 

}; 

 

For your convenience, we have prepared the sample based on our above suggestions. Please find the link below. 

 

Sample Link:  https://stackblitz.com/edit/ez12gm-wb6rvr?file=index.ts  

 

Could you please check the above details and get back to us, if you need any further assistance on this. 

 

Regards, 

Sangeetha M