search and replace in Spreadsheet

[serge]

Our customers using the spreadsheet copy/paste values in the Spreadsheet (ASP. NET CORE)

 

Sometimes pasted decimal separator is ".", sometimes is the ",".

Is there a way to search and replace the pasted values from "," to ".", or, if not, to search and replace in Spreadsheet ?

[Aleksandar]

Hello Serge,

Currently the Spreadsheet does not provide a search functionality, however there is a Feature Request for providing support for searching. If this matches your requirement I will urge you to vote on it. If not you may submit a Feature Request, providing as many details as possible, so we can monitor the community interest in the requested feature and consider it for future implementation.

That said, with the current implementation there is a client-side paste event exposed for the Spreadsheet. The event provides reference to the clipboardContent object, representing the content that has been passed from the clipboard to the paste command. This data allows you to prevent the default execution of the paste functionality, manipulate the data and paste it properly in the widget content. You can, for example, add an event handler and replace the comma with a dot:

function onPaste(arg) { 
          arg.clipboardContent.data = arg.clipboardContent.data.map(function (row) {
                return row.map(function (cell) {
                    return {...cell, value: cell.value.replace(",",".")}
                });
            });
        }

Here is a dojo example. Feel free to modify the above suggestion to meet the requirements you have.

Regards,
Aleksandar
Progress Telerik