How to disable SfSpreadsheet's copy-paste behavior and implement custom logic instead.

[crosslife]

When copying an entire row from SfSpreadsheet in one WPF application and pasting it into SfSpreadsheet in another process, it triggers a crash. I want to implement my own logic using the system clipboard as an intermediary.

[Manikanda Akash Munisamy]

Hi crosslife,

We have reviewed the reported scenario, where copying an entire row from one WPF SfSpreadsheet to another causes a crash. We are currently validating this scenario, and we will update further details by December 06, 2024.

If you wish to implement custom Copy-Paste logic in your application, you can refer to the following KB article:

KB Article: How to copy a cell value instead of formula in WPF Spreadsheet?

If you have any further questions or require additional assistance, please let us know.

Regards,

Manikanda Akash

[Manikanda Akash Munisamy]

Hi crosslife,

We have checked the reported issue "ArgumentException Thrown When Pasting an Entire Row in SfSpreadsheet" as a defect. We have logged a bug, and it will be fixed in our Essential Studio 2024 Volume 4 Main Release.

You can track the status of this report through the following feedback link,

Feedback Link: ArgumentException Thrown When Pasting an Entire Row in SfSpreadsheet in WPF | Feedback Portal

Note: The provided feedback link is private, and you need to log in to view this feedback.

We will let you know once it is released. We appreciate your patience until then.

Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.

Regards,

Manikanda Akash

[crosslife]

This documentation appears to be outdated, and the link to the SpreadsheetCopyPaste documentation is no longer accessible. I'd like to know which namespace this class belongs to and which NuGet package should be referenced when using it in WPF.

[Manikanda Akash Munisamy]

Hi crosslife,

We apologize for the inconvenience caused. The API link provided in the earlier KB article for SpreadsheetCopyPaste is currently inaccessible. We kindly recommend referring to the updated API link below. Additionally, we will ensure the KB article is updated with the correct link soon.

API Link - Class SpreadsheetCopyPaste - WPF API Reference | Syncfusion

It is not necessary to install a separate NuGet package to access SpreadsheetCopyPaste, as it is included under the Syncfusion.UI.Xaml.Spreadsheet namespace. The Syncfusion.SfSpreadsheet.WPF package is sufficient to utilize this feature.

If you have further concerns or require any additional assistance, please feel free to let us know.

Regards,

Manikanda Akash

[Malini Selvarasu]

Hi crosslife,

We are glad to announce that our Essential Studio® 2024 Volume 4 Main Release V28.1.33 is rolled out with the fix for the issue "ArgumentException Thrown When Pasting an Entire Row in SfSpreadsheet" and is available for download under the following link.

https://www.syncfusion.com/forums/195512/essential-studio-2024-volume-4-main-release-v28-1-33-is-available-for-download

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.

Root Cause Details:
Recently, we made some changes to resolve the issue where the copy cells and fill series operations were not working as expected when performed within hidden rows. However, these changes affected the existing behavior of the copy cells and fill series operations. As a result, we reverted the changes related to hidden rows to restore the original functionality. Now, the issue has been resolved, and everything is working properly.

Regards,
Malini Selvarasu