Data updated on server not appearing in spreadsheet

[Remy]

Dear Syncfusion Team,

I am using your spreadsheet component as a front-end display, and Firebase as the database to store the date. When updating the data from the spreadsheet, the changes are reflected instantly on the server (Firebase). However, the other way around doesn't seem to work properly. When updating the data from the server, the change isn't reflected on the spreadsheet. If I double-click a cell to edit its value, I will then see the "updated" value but as soon as I click out of that cell to cancel the "edit" it shows the old value. My explanation might not bee so clear, so I re-created the issue in a Stackblitz project and created a dummy DB on Firebase for you to see the issue. Here is a demonstration :

 

Here is the sample used in the demo :

https://stackblitz.com/edit/angular-jhtxqp-4wdu5f?file=app.component.ts

Thank you,

Remy

[Sangeetha Priya Murugan]

Hi Remy, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported issue and we suspect that you have updated the database value in the spreadsheet model and the UI not refreshed. So, we would suggest you to use the updateCell method to update the value in the cell.  

 

https://ej2.syncfusion.com/angular/documentation/api/spreadsheet/#updatecell 

 

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

 

Regards, 

Sangeetha M 

[Remy]

Hi Sangeetha,

Thank you for your response. I thought this would work out of the box like it does with your grid component (as soon as the data changes on the server, the changes are reflected in the grid). Nonetheless, I coded a logic to detect changes between the new received data and the data that already exists in the spreadsheet to apply the changes manually using updateCell method like you suggested. However, the updateCell method doesn't seem to work on a cell that has wrapping enabled...

In my created() event, one of the lines enables wraping :

this.spreadsheetObj.wrap('A17:E17', true);

The updateCell method doesn't work on this cell. If I comment it out, it works just fine, but then again the text in my cell will overflow outside of the cell instead of breaking to the next line.

Here is a demo : 

https://youtu.be/1iz0fQ5SNhA

Thanks,

Remy

[Sangeetha Priya Murugan]

Hi Remy, 

 

Thank you for your update. 

 

We have already fixed your reported issue(updateCell not worked for wrap applied cells) in our latest patch release (18.4.42). So, we would suggest you to use the latest version to resolve this issue in your end. 

 

https://www.npmjs.com/package/@syncfusion/ej2-spreadsheet  

 

Regards, 

Sangeetha M