When copying multiple cells in Excel, commas within the cell content will be lost when pasting into Spreadsheet


3 Replies

CR crosslife December 11, 2024 07:52 AM UTC

demo project.


Attachment: SyncfusionDemo_c20f26d1.zip


MS Malini Selvarasu Syncfusion Team December 12, 2024 02:52 PM UTC

Hi crosslife,

We are currently analyzing the scenario you reported and require additional time to validate it. We will provide an update on or before December 14, 2024.

We appreciate your patience in the meantime.
Regards,
Malini Selvarasu


MS Malini Selvarasu Syncfusion Team December 14, 2024 09:43 AM UTC

Hi crosslife,

Based on the information provided, we understand that you have encountered an issue where text containing a comma is not pasted correctly in the Spreadsheet. Upon investigation, we found that when content is copied from an external source, SfSpreadsheet does not support paste formatting options (such as format settings). This limitation is outlined in the user guide documentation. You can refer to the link below for more details:
If you require the formatting to be applied, we recommend using the "Format Cells" option in the ribbon to set the desired formatting before pasting the text. Additionally, instead of pasting the content from Excel, loading the Excel file directly into the spreadsheet will ensure that the formats are applied correctly. Thank you for your understanding.
Regards,
Malini Selvarasu

Loader.
Up arrow icon