#Value! appears when changing a cell value

[Omar]

Hello,

So, when I was trying to update a date inside a cell that another cell depend on it displays #Value!

I just trying to SUM two dates and display the result in a third cell.

Thanks for your help,

[Aravinthan Seetharaman]

Hi Omar, 

 

Thanks for contacting Syncfusion Support. 

 

We have checked your reported issue. We can reproduce your reported issue in our end. We can resolve your issue by using SUM formula as like in the below code snippet. 

 

 

spreadsheet.updateCell({ formula: "=SUM(E2:E3)" }, "H3"); 

 

 

For your reference we have prepared sample: 

 

Sample: https://codesandbox.io/s/hungry-antonelli-4x0v3?file=/src/App.vue  

 

However, we will consider this as a defect, and it will be available on our next patch release. We appreciate your patience until then 

 

Regards, 

Aravinthan S 

[Aravinthan Seetharaman]

Hi Omar, 

 

Thanks for the patience. 

 

We are glad to announce that our weekly patch release (18.4.0.43) is rolled out. We have included the fix for your issue [#Value! appears when changing a cell value] in this release. So, we suggest you upgrade our Syncfusion packages to our latest version to resolve this issue in your end. (18.4.0.43) 

 

Please let us know if you need further assistance on this. 

 

Regards, 

Aravinthan S