Wrong calculated value on cell

Hello,

We have found a calculation problem.

If, for instance, we put these 4 values on a sheet, and sum them up, the summed value is incorrect.

18174.31

1516311.65

31087.02

39078192.54 (if the value set is 39078192.53 for instance calculation is correct).

As can be seen below. The culture loaded is pt-PT, but this also happens if we do not set any culture, and it default to en-US

Image_4628_1694891842333

We've updated to the latest version (23.1.36.0), and this problem still occurs.

Even if we put it into an empty Spreadsheet, we get this behavior:

Image_4538_1694896545539

The call is simply this:

@Html.EJS().Spreadsheet("spreadsheet").Height("600").Render()


I do not understand this behavior, if we change some values, it sometimes gets the correct value, and another times it doesn't.
Thanks in advance


3 Replies 1 reply marked as answer

VR Vasanth Ravi Syncfusion Team September 18, 2023 12:44 PM UTC

Hi ShareValue,


We have checked your reported issue at our end on the mentioned version. The value has been calculated as expected. Attached video and sample for reference.


Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Spreadsheet_file705592631186471854


Video Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Sum_issue-184653801


We recommend you check with your reported issue once at your end. If still gets replicated kindly share the below requested details.


  1. In what way you have been loading the data to the spreadsheet component.?

  2. Are there any number formats applied to the value which is being calculated.? If yes, share those details.

  3. Replicate the issue on the above attached sample and share it back to us for further validation.

  4. Share the exact scenario in which you were facing the issue. That would be helpful for us to validate further.


Marked as answer

SH ShareValue replied to Vasanth Ravi September 20, 2023 08:46 PM UTC

Just an FYI.

The problem was in the link to the js.

It works with:

<script src="https://cdn.syncfusion.com/ej2/23.1.36/dist/ej2.min.js"></script>

It has this odd behavior with:

<script src="https://cdn.syncfusion.com/ej2/dist/ej2.min.js"></script>



SP Sangeetha Priya Murugan Syncfusion Team September 21, 2023 10:28 AM UTC

Hi ShareValue,


We have stopped our common CDN link refreshing for the ej2.min.js file in our previous releases. And we have refreshed only our version-specified CDN links for our script files. So, we suggest you use our version-specified CDN link for proper functioning.


Loader.
Up arrow icon