Approved
Last Updated: 13 Feb 2019 15:07 by ADMIN
n/a
Created on: 08 Feb 2019 14:08
Category: Spreadsheet
Type: Bug Report
1
Losing precision decimals when copy values from a Excel sheet to Kendo Spreadsheet.

Hello there,

I am developing a Web application using  Kendo UI Spreadsheet control, but I noticed that when I copy some numbers from a Excel sheet to the spreadsheet and then copy back to Excel, the decimal values are quite different, I mean, the decimal precision has been affected.

For example:

I have the following numbers on a Excel sheet:

10.50.3333333330.250.20.1666670.1428570.1250.1111110.10.0909090.0833330.0769230.0714290.0666670.06250.0588240.0555560.052632

Then, I copy them to the Kendo spreadsheet and I got the following:

100.00%50.00%33.33%25.00%20.00%16.67%14.29%12.50%11.11%10.00%9.09%8.33%7.69%7.14%6.67%6.25%5.88%5.56%5.26%

But when I copy them back to Excel I got this:

10.50.33330.250.20.16670.14290.1250.11110.10.09090.08330.07690.07140.06670.06250.05880.05560.0526

Losing many decimals affecting the results of my computation and calculation.

Can you tell me why is this happening?

Thank you some much.

 

 

 

2 comments
ADMIN
Ivan Danchev
Posted on: 13 Feb 2019 15:07
Hello,

Thank you for reporting this issue. We logged it for fixing. I've made this thread visible in our Feedback Portal, which will allow you to track the progress with fixing the bug through the thread status.

I updated your Telerik points for reporting this issue.

Regards,
Ivan Danchev
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
n/a
Posted on: 08 Feb 2019 15:10

Hello,

 

On the previous email, with "losing precision decimals" I meant losing decimal precision.

Sorry I am not a native english speaker.

 

Cheers.