Telerik MVX - Spreadsheet Component: Copy-Paste of numbers with hidden decimals

1 Answer 6 Views
Spreadsheet
Claudio
Top achievements
Rank 1
Claudio asked on 21 Dec 2021, 05:10 PM

Hello,

 

we would like to know if there is a way to allow the users copy the full value of a number with decimals and not only the value that is visible form the front end (in the following scenarios 13 decimals as you can see from the formula bar and 3 decimals as format).

Below you can see a spreadsheet component in which the numbers displayed are declared as decimals, in the formula bar you can see the real value of the number with 13 decimals, while I've highlighted the cell of interest in the print (cell L25) that as you can see has 3 decimals.

When coping the cell L25 and trying to paste it in the same spreadsheet component (for example S15) the number pasted is formatted the same way of the original cell and in the formula bar I find the same  decimals of the original cell; instead in the moment i try to copy the number in an other spreadsheet component that is in one other page, the pasted number is formatted the same way of the original one, so 3 decimals but I find also just 3 decimals visible from the formula bar instead of the original 13 decimals.

Can you please provide an explanation related to this behavior? How can we arrange that the paste action of values with decimals keep the same format of the original selection and also in the formula bar the same decimals too?

Thanks,

1 Answer, 1 is accepted

Sort by
0
Eyup
Telerik team
answered on 24 Dec 2021, 06:31 AM

Hello Claudio,

 

Thank you for writing to us.

There is a javascript solution which is related to this requirement. Can you check it and let me know your thoughts?
https://docs.telerik.com/kendo-ui/knowledge-base/spreadsheet-paste-only-values

Would this be suitable for you?

Let me know your opinion.

 

Regards,
Eyup
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Spreadsheet
Asked by
Claudio
Top achievements
Rank 1
Answers by
Eyup
Telerik team
Share this question
or