local and remote data is not binding in spreadsheet

[saravanan]

Hi,

I'm working in the spreadsheet and trying to load dataSource in the spreadsheet in e-rangesetting but it is not loading. I tried exactly what was given in documentation but that was also not working. only if I try to import the excel then only data is loading in the spreadsheet. I have attached my code here.

thanks 

Attachment: spreadsheet_8f7f3bbf.zip

[Arunkumar Devendiran]

Hi Saravanan, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported query in that you are trying to dynamically set the data to the spreadsheet by using datasource property. We suspect that you are tried to set the data like two way binding (changing the 'data' property in AppComponent class need to updated in Spreadsheet). We would inform you that currently, we does not have this support on our spreadsheet. We have considered this as improvement in our end and this support will be included in any of our upcoming release. However, we have provided the workaround for your reported scenario, in that we have rendered the spreadsheet when data loaded by setting the ngIf as true. In this way, you can achieve your requirement. Please refer the below sample link. 

 

Sample link: 

https://stackblitz.com/edit/angular-z3bhrc-zpaa63?file=app.component.ts 

 

Please follow the below feedback link. 

https://www.syncfusion.com/feedback/9684/dynamic-data-binding-support 

 

Regards, 

Arunkumar D   

[saravanan]

okay but local data is also not loading for me. in my previous attachment I have commented on one code in html file that was statically binding the data into the spreadsheet datasource that is also not working. this ngIf is also not working please see my attachment. I tried exactly what was in the syncfusion document for local data binding and it was not working so can you please let me know my angular and syncfusion version are correct plus I'm using ubuntu 18.04. 

Attachment: spreadsheet_616f2316.zip

[Arunkumar Devendiran]

Hi Saravanan, 

 

We have checked your reported query and we would inform you that while you are trying to load the data using tag directive(rangesetting) you can facing this kind of issue. So we suggest you to load the data by using sheets property. In this way, you can achieve your requirement. Please refer the below sample link. 

 

Sample link: 

https://stackblitz.com/edit/angular-z3bhrc-ksmkdo?file=app.component.ts 

 

Regards, 

Arunkumar D 

[saravanan]

Thanks for your reply Actually the main problem is I'm using angular CLI version 9 and i degrade it to version 8 and it is working fine 

[Madhan Venkateshan]

Hi Saravanan, 

 

Thanks for your update. 

 

We will fix the reported issue in angular 9 and it will be available in our upcoming patch release after Volume 1 release 2020. You can track the same through the below feedback link. 

 

https://www.syncfusion.com/feedback/12999/rangesettings-tag-directive-is-not-working-in-angular-9 

 

Regards, 

Madhan V