How to copy cell value instead of formula

Question

Hello!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?

Kanimozhi Bharathi · Answer

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, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/WPF_(2)409573412 

Regards 
Kanimozhi B

Belikov · Answer

It works. Thanks!

Kanimozhi Bharathi · Answer

Hi Belikov, 
Thank you for your update. 
Regards 
Kanimozhi B