When copy from excel, how to force paste only text?

[crosslife]

Already set the NumberFormat

filterRange.NumberFormat = "@";

But when copy numbers from excel, the format is overrided.

[crosslife]

screenshot

Attachment: 20241018183415_WindowShot_f5bf2fb6.zip

[Sreemon Premkumar Muthukrishnan]

Hi crosslife,

To maintain the format of a cell when pasting a value from another cell with a different format, you can set SfSpreadsheet.CopyPaste.DefaultPasteOption to PasteOptions.Value. This ensures that only the value is pasted, without copying the format. Please find the code snippet below.

Code snippet:

spreadsheet.CopyPaste.DefaultPasteOption = PasteOptions.Value;

For more information regarding the paste options, please refer this user guide documentation.

Regards,
Sreemon Premkumar M.