How to copy cell value instead of formula

[Belikov]

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]

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]

It works. Thanks!

[Kanimozhi Bharathi]

Hi Belikov, 

Thank you for your update. 

Regards 

Kanimozhi B