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: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Paste a range including cell comments to Excel spreadsheet

Thread ID:

Created:

Updated:

Platform:

Replies:

150933 Jan 24,2020 06:00 PM UTC Feb 12,2020 05:06 PM UTC WinForms 7
loading
Tags: Spreadsheet
Spotty
Asked On January 24, 2020 06:06 PM UTC

Copy/Paste values spreadsheet to spreadsheet appear to work within Syncfusion spreadsheet (including comments)  and copy/Paste from syncfusion spreadsheet to Excel spreadsheet appeared to copy the values but the comments didnt copy or the coloring of the cells.

Am I missing an overload of one of the methods ?

Kanimozhi Bharathi [Syncfusion]
Replied On January 27, 2020 11:45 AM UTC

Hi Spotty, 
 
We were able to reproduce the issue of  “Formatting of cell ranges are not copied in the Clipboard” while using CopyToClipboard method. After validating, we could find that this issue is related with XlsIO team. Hence we have forwarded internally to the respective team and will update you with further details by January 29,2020. 
 
Regards, 
Kanimozhi B 


Arulpriya Ramalingam [Syncfusion]
Replied On January 29, 2020 11:34 AM UTC

Hi Spooty, 
 
Thank you for your patience, 
 
We confirmed that reported scenario is a defect from our end. We have logged a bug report for this issue “Formatting of cell ranges are not copied in the Clipboard” Here we have provided private feedback link, we request you to log in to view the link further      
   
    
The fix will be available in our upcoming 2020Volume1 release which is scheduled to be rolled out at the end of February, 2020. Would waiting for the official release is OK for you? Otherwise, we can provide a patch in the reported version v17.4.0.39 on 12nd February, 2020. If you have any more specification replication procedure or a scenario to be tested you can add it as a comment in the portal also if the version is not correct, please specify the version in which you need the patch.    
 
Moreover, we do not have the support to copy the comment text to clipboard and currently we do not have any immediate plan to implement the same. 
 
Regards,   
Arulpriya   


Spotty
Replied On February 5, 2020 05:57 PM UTC

Its a shame that the comment copy is not going to be supported.   That is a serious ommission as if you copy cells in excel the comments are copied as well.   And obviously for interop between the spreadsheet and excel this would be a very nice feature to avoid hacky workarounds to try and import comments into excel sheet.

Also I would like the patch version to test out as soon as its available.

Kanimozhi Bharathi [Syncfusion]
Replied On February 6, 2020 12:48 PM UTC

Hi Spooty, 
 
Regarding Copying Cell Comments, 
 
XlsIO team is checking the feasibility for CopyToClipboard with comments, So we will update the details on 10 February, 2020.  
 
Regarding Formatting issue, 
 
The patch will be updated as promised on 12nd February, 2020. 
 
Please let me know if you need any clarifications. 
 
Regards, 
Kanimozhi B 


Arulpriya Ramalingam [Syncfusion]
Replied On February 10, 2020 12:20 PM UTC

Hi Spooty,  
  
On further analysis, we found that this is not an issue. As per Microsoft Excel behavior copying comments to clipboard is not supported. So, XlsIO behaves similarly.  
  
Please find the video screen shot for your reference and get back to us, if you have any other queries.  
  
Video screenshot:  
  
Arulpriya 


Spotty
Replied On February 12, 2020 12:45 AM UTC

Hi Spooty,  
  
On further analysis, we found that this is not an issue. As per Microsoft Excel behavior copying comments to clipboard is not supported. So, XlsIO behaves similarly.  
  
Please find the video screen shot for your reference and get back to us, if you have any other queries.  
  
Video screenshot:  
  
Arulpriya 


Your either missing the point or have not tried the scenario as clearly its possible to Cut/Copy/Past Excel cells with comments to another excel cell with the comments being copied.  I've attached a video showing this and have verified that many older versions of excel are able to do this.

I'm either trying to copy/paste cells with comments between Spreadsheets with Syncfusion or between Syncfusion Spreadsheet and Excel.   




Attachment: ExcelCommentCopy_b721c76a.zip

Arulpriya Ramalingam [Syncfusion]
Replied On February 12, 2020 05:06 PM UTC

Hi Spotty, 
 
Thank you for the update. 
 
Regarding Formatting issue,  
  
The patch will be updated as promised on 12nd February, 2020. 
Please make use of the below patch and code snippet to resolve the reported use case at your end. 
 
The issue with "Formatting of cell ranges are not copied in the Clipboard" has been fixed and the patch for this fix can be downloaded from the following location.

Recommended approach - exe will perform automatic configuration
Please find the patch setup from below location:
 
http://syncfusion.com/Installs/support/patch/16.4.0.42/1113341/F150933/SyncfusionPatch_16.4.0.42_1113341_2122020064015096_F150933.exe

Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment
Please find the patch assemblies alone from below location:
 


Assembly Version: 16.4.0.42
Installation Directions :
This patch should replace the files “Syncfusion.XlsIO.Base.dll” under the following folder.
$system drive:\ Files\Syncfusion\Essential Studio\16.4.0.42\precompiledassemblies\16.4.0.42\4.6
Eg : $system drive:\Program Files\Syncfusion\Essential Studio\9.3.0.61\precompiledassemblies\9.3.0.61\4.0

To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.

Note :
To change how you receive bug fixes, ask your license management portal admin to change your project’s patch delivery mode.

https://www.syncfusion.com/account/license

Disclaimer :
Please note that we have created this patch for version 16.4.0.42 specifically to resolve the following issue(s) reported in this/the forums(s). 150933

If you have received other patches for the same version for other products, please apply all patches in the order received.
This fix will be included in our main release 2020Volume1 main release which will be available in end of March 2020..

 
 
Code snippet 
 
//Event subscription 
spreadsheet.CopyPaste.Copied += CopyPaste_Copied; 
 
private void CopyPaste_Copied(object sender, Syncfusion.Windows.Forms.Spreadsheet.Helpers.SpreadsheetCopiedEventArgs e) 
{ 
    //Event customization 
    string copiedRange = GridExcelHelper.ConvertGridRangeToExcelRange(e.Range, e.Grid); 
    (spreadsheet.ActiveSheet.Range[copiedRange] as RangeImpl).CopyToClipboard(); 
} 
I'm either trying to copy/paste cells with comments between Spreadsheets with Syncfusion or between Syncfusion Spreadsheet and Excel.   
Copying comments between the worksheets are working fine at our end and as we updated earlier, the Spreadsheet does not have the support to copy the comments between MS-Excel and Syncfusion spreadsheet. So, we will check for the feasibility for the use case at our end and update you the proper details on 14th February. 
 
Regards, 
Arulpriya 


CONFIRMATION

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

Live Chat Icon For mobile
Live Chat Icon