An error occurs when copying cells with colored text from Excel and pasting them into SfSpreadsheet.

[crosslife]

An error occurs when copying cells with colored text from Excel and pasting them into SfSpreadsheet.

Here I have already set all cells' format to plain text.

var worksheet = spreadsheet.ActiveSheet;

worksheet.UsedRange.NumberFormat = "@";

[Sreemon Premkumar Muthukrishnan]

Hi crosslife,

We were able to replicate the reported issue when pasting text that contains a semicolon. We are currently validating it in the source. We need some additional time for validation and will provide you with further details by November 15, 2024.

We appreciate your patience until then.

Regards,
Sreemon Premkumar M.

[Sreemon Premkumar Muthukrishnan]

Hi crosslife,

We have created a bug report for the reported issue “Warning message box appears when pasting a content with semicolon when NumberFormat is set to Text”. We will include this fix in our upcoming Weekly NuGet release which is scheduled for December 10, 2024.

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

Feedback Link: Warning message box appears when pasting a content with semicolon when NumberFormat is set to Text in WPF | Feedback Portal

Note: The provided feedback link is private, and you need to login 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,
Sreemon Premkumar M.

[Sreemon Premkumar Muthukrishnan]

Hi crosslife,

We would like to let you know that Essential Studio Weekly NuGet packages (v27.2.5) has been published in nuget.org with the fix for the issue “Warning message box appears when pasting a content with semicolon when NumberFormat is set to Text”. Please let us know if you have any concerns in this.

Root Cause Details:

The reported problem occurs when setting the data using the formula property, which causes an exception that is displayed when pasting text. We have resolved the issue by validating the data before pasting it and setting it into the value or formula property in the CellRange. Additionally, we have removed the message box to avoid displaying a warning message when pasting in SfSpreadsheet.

Regards,
Sreemon Premkumar M.