BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
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
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:
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: 22.214.171.124
Installation Directions :
This patch should replace the files “Syncfusion.XlsIO.Base.dll” under the following folder.
$system drive:\ Files\Syncfusion\Essential Studio\126.96.36.199\precompiledassemblies\188.8.131.52\4.6
Eg : $system drive:\Program Files\Syncfusion\Essential Studio\184.108.40.206\precompiledassemblies\220.127.116.11\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.
To change how you receive bug fixes, ask your license management portal admin to change your project’s patch delivery mode.
Please note that we have created this patch for version 18.104.22.168 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..
spreadsheet.CopyPaste.Copied += CopyPaste_Copied;
private void CopyPaste_Copied(object sender, Syncfusion.Windows.Forms.Spreadsheet.Helpers.SpreadsheetCopiedEventArgs e)
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.