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.
Unfortunately, activation email could not send to your email. Please try again.

How to copy cell value instead of formula

Thread ID:





124411 Jun 8,2016 04:57 AM Jun 9,2016 11:53 PM WPF 3
Tags: SfSpreadsheet
Asked On June 8, 2016 04:57 AM


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 [Syncfusion]
Replied On June 9, 2016 08:55 AM

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 

Replied On June 9, 2016 09:21 AM

It works. Thanks!

Kanimozhi Bharathi [Syncfusion]
Replied On June 9, 2016 11:53 PM

Hi Belikov, 
Thank you for your update. 
Kanimozhi B 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.