BoldSign®Effortlessly integrate e-signatures into your app with the BoldSign® API. Create a sandbox account!
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
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:
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
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.
In what way you have been loading the data to the
spreadsheet component.?
Are there any number formats applied to the value
which is being calculated.? If yes, share those details.
Replicate the issue on the above attached sample and
share it back to us for further validation.
Share the exact scenario in
which you were facing the issue. That would be helpful for us to validate
further.
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>
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.