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

[Claudio]

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,

[Eyup]

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

[Claudio]

Hello,

we have implemented the solution proposed and it works properly only for "copy-paste" into the same spreadsheet.
Instead, if we copy from another spreadsheet or from an Excel file, it does not work properly and it paste only the visible decimal.

There is a way to paste also hidden decimal when the "copy" source is external to the spreadsheet (other spreadsheet or Excel file)?

Thanks,

[Eyup]

Hi Claudio,

I am glad the provided approach has proven helpful.

As for the new requirement, can you open a formal support ticket and send us a basic runnable version of your app? This will allow us to further investigate this specific behavior you are describing of hidden decimals or copying from external spreadsheet.