Worksheet selection event

[Rahal Ekanayaka]

Is there any event triggered for worksheet selection. Use case is that I want to load each worksheets upon click on each worksheet. Would be great if you could give any documentation links.

[Janakiraman Sakthivel]

Hi Rahal Ekanayaka,  

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported requirement and we suspect that you want an event trigger for worksheet selection. And it can be achieved in our spreadsheet by using the actionBegin event. For your convenience, we have prepared the sample. Please refer the below sample and code snippet. 

Sample link: https://stackblitz.com/edit/angular-joejqe?file=app.component.html 

CODE SNIPPETS: 

 

 <ejs-spreadsheet #default [openUrl]="openUrl" [saveUrl]="saveUrl" (created)="created()" (actionBegin)="actionBegin()" (select)="select()"> </ejs-spreadsheet> 

    actionBegin(args) { 

        console.log("actionBegin", args); 

    } 

    select(args) { 

        console.log("cell or range of cells is selected", args); 

    } 

 

API link: https://ej2.syncfusion.com/angular/documentation/api/spreadsheet/#actionbegin 

 

If you want an event to be triggered while selecting a cell or range of cells, use select event. 

 

API link: https://ej2.syncfusion.com/angular/documentation/api/spreadsheet/#select 

 

Could you please check the above sample and get back to us if we misunderstood your requirement or if you need any further assistance on this? 

 

Regards, 

Janakiraman S. 

[Rahal Ekanayaka]

Hi Janakiraman,

Thank you for your reply. This what I exactly need. However when I follow actionBegin event binding I get following issue. Can you please help?

Angular version - 12

typescript version - 4.3

ej2-angular-spreadsheet - 19.2

Error: src/app/app.component.html:2:63 - error TS2722: Cannot invoke an object which is possibly 'undefined'.

[Janakiraman Sakthivel]

Hi Rahal Ekanayaka, 

 

Thank you for your update. 

 

We have checked your reported query and we are not able to replicate your issue on our end based on your provided versions. For your convenience, we have prepared a sample based on your provided version details. Please find the link below. 

 

Sample Link: https://stackblitz.com/edit/angular-joejqe-baortj?file=app.component.html  

 

"@syncfusion/ej2-angular-spreadsheet": "^19.2.62", 

 

"devDependencies": { 

    "@angular/cli": "12.2.6", 

    "typescript": "4.3.5" 

  } 

 

 

Before we proceed further, please share the below details. 

 

1. If possible, try to reproduce the reported issue in provided sample or share the issue reproducible sample. 

 

2. Please share the codes, if you have done any customization in sample level. 

 

3. Please share us the video demonstration of this issue.  

 

Could you please get back to us with the above requested information, based on that we will check and provide you a better solution quickly. 

 

Regards, 

Janakiraman S.

[Rahal Ekanayaka]

Hi

After I set strictTemplates = false in tsconfig.json file(this file automatically generated when you create new project from angular CLI) everything works fine. However I couldn't find tsconfig.json in your sample.

Thank you!

[Janakiraman Sakthivel]

Hi Rahal Ekanayaka, 

 

Thank you for your update. 

 

We are happy to hear that your issue has been resolved. In our previous update, we shared a stackblitz sample, so the tsconfig.json file was missing in that. For your convenience, we have prepared the sample and video demonstration of this. Please find the links below. 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/168869/ze/Spreadsheet2044711397-1440159427 

 

Video Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/SCREEN~3-1967651014 

 

Please get back to us, if you need further assistance. 

 

Regards, 

Janakiraman S. 

[Rahal Ekanayaka]

Hi Janakiraman,

With the help of your sample I was able to resolve my issue. Than

[Janakiraman Sakthivel]

Hi Rahal Ekanayaka, 

 

Thanks for the update. 

 

We are happy to hear that your issue has been resolved. Please feel free to contact us if you need any further assistance on this. 

 

Regards, 

Janakiraman S.