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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to copy cell value instead of formula

Thread ID:





124411 Jun 8,2016 08:57 AM UTC Jun 10,2016 03:53 AM UTC WPF 3
Tags: SfSpreadsheet
Asked On June 8, 2016 08:57 AM UTC


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 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 

Replied On June 9, 2016 01:21 PM UTC

It works. Thanks!

Kanimozhi Bharathi [Syncfusion]
Replied On June 10, 2016 03:53 AM UTC

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon