Spreadsheet Widget: Calculations keep generating random decimals

I checked all 5 forms in your account (Nelson131), but none of your forms has Form Calculation widget or an input table field.

Can you please share the form in question https://www.jotform.com/help/401-Where-to-Find-My-Form-URL?

Looking forward for your response. 

This is caused by the implementation of "numbers" in programming languages (JavaScript in this case), some numbers cannot be represented with perfect accuracy. I am forwarding a ticket to our developers to see if the calculations can be improved in the Spreadsheet widget. Although, we cannot provide an ETA on when this will be addressed.

As a workaround, you may also consider using an Input Table with conditional calculations:

Calculate Values in the Input Table Through Condition

The conditional calculations will have two decimal places in numeric results, so there should not no issue with your calculations.

Hi Nelson,

We have updated the Spreadsheet widget and now the length of numbers with decimal points is fixed. Have a good day!

Regards,

Widgets Team

I've tried it on your form and it no longer adds random decimals.

Can you please send us a sample screenshot of what you see on your end?

I think the browser's cache doesn't allow you to see the fix. Please just clear your browser's cache or test it in the incognito/private mode and everything will be fine.