We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Find and Replace for only selected cells in Spreadsheet


I am using Syncfusion Spreadsheet component in React Js application.In that,when I select specific cells which has value as "done" and I selected find to replace the "done" value with some other value like "inprogress" its replacing for the all cells which has "done" to "inprogress".But I want to replace only the selected cells in the sheet. How could I acheive that?,Below I have attached image & zip file for the reference.Please suggest.

Thanks In Advance

process 1_11zon.pngprocess 2_11zon.png

Attachment: 11zon_compressed_f5c3feb1.zip

2 Replies 1 reply marked as answer

SP Sangeetha Priya Murugan Syncfusion Team May 4, 2023 01:53 PM UTC

Hi Arun,

Currently, we don’t have support to switch the active cell within the selected range for Find action like MS Excel. And we need to validate more on your reported issue so we will update you the further details on May 8th, 2023. We appreciate your patience until then.

Marked as answer

SP Sangeetha Priya Murugan Syncfusion Team May 9, 2023 08:03 AM UTC

Hi Arunkumar,

Currently, we don’t have cell navigation support within the selected range in the spreadsheet. Without this support we wouldn’t be able to find and replace for the selected range of cells. Based on the current behavior find and replace works for whole sheet or workbook model. So, we have considered this as a feature, and it will be available in any of our upcoming releases. You can track the status of this feature using below link from our feedback portal,   

Feedback Link:  https://www.syncfusion.com/feedback/43514/provide-support-to-perform-find-and-replace-within-the-selected-range-of-cells

Live Chat Icon For mobile
Up arrow icon