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

How to copy cell value instead of formula


When trying to copy a value from the cell in the SfSpreadsheet control, it copies formula (=A2*B2) instead of value.
I have found CopyPaste property and set DefaultPasteOption = Syncfusion.UI.Xaml.Spreadsheet.PasteOptions.Value, but it looks that it affects only paste.
Is there any way to change copy mode?

3 Replies

KB Kanimozhi Bharathi Syncfusion Team June 9, 2016 12:55 PM UTC

Hi Belikov, 

You can achieve your requirement by customizing the SpreadsheetCopyPaste class and override the Copy method of SpreadsheetCopyPaste to copy the display text instead of formula in a cell. We have prepared a sample for this. Please find the sample link below, 

Kanimozhi B 

BE Belikov June 9, 2016 01:21 PM UTC

It works. Thanks!

KB Kanimozhi Bharathi Syncfusion Team June 10, 2016 03:53 AM UTC

Hi Belikov, 
Thank you for your update. 
Kanimozhi B 

Live Chat Icon For mobile
Up arrow icon