1. Home
  2. Forum
  3. ASP.NET Web Forms (Classic)
  4. Paste into Excel includes separators

Paste into Excel includes separators

I have a grid displaying numbers with separators. "50000" is displayed like "50 000". When I copy these cells and paste them into an Excel spreadsheet the formatting with separators remains and Excel treats them as numbers. Is there any way to get them to be copied as numbers without separators?

Regards / Jonas


1 Reply
RR Ranjithkumar R G Syncfusion Team April 26, 2011 02:03 PM UTC

Hi Jonas,

Thanks for using Syncfusion products.

We would like to know you that copy operation is happening based on browser's default behaviour and the paste operation is happening based on Excel default behaviour. We could not change those behaviours, so we suggest you that please select 'Copy cells without formatting' in Excel while copying cells from grid.

Please let us know your concerns.

Regards,
Ranjithkumar.




Loader.
Up arrow icon