RadSpreadsheet - Copy - paste numeric values formatted as text from excel

[Giorgos]

When doing a copy / paste of numeric values from excel to RadSpreadsheet initial zero values are lost. So, when I copy for example value 07657656 it gets pasted as 7657656.

Is there any workaround this behavior?

[Peter Milchev]

Hello Giorgos,

One option is to set the format of a given range to text.

Another option is to set the format of the pasted data as text using the OnClientPaste event of the Spreadsheet:

• https://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/client-side-programming/events/overview;

 <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1" OnClientPaste="OnClientPaste"></telerik:RadSpreadsheet>
<script>
    function OnClientPaste(sender, args) {
        var clipboardData = args.get_clipboardContent().data;
        for (var i = 0; i < clipboardData.length; i++) {
            for (var j = 0; j < clipboardData[i].length; j++) {
                var cellData = clipboardData[i][j];
                cellData.format = "@";
            }
        }
    }
</script>

Regards,
Peter Milchev
Progress Telerik

[Giorgos]

Thanks, I used OnClientPaste. It works very well. I tested it with about 6000 rows of pasted data.