Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1410
Copy & Paste to Excel will loose double spaces
posted

Hello

We have Infragistics v. 11.1.20111.2193, Windows 7 and Microsoft Excel 2007.

Scenario:

- Have some cell in XamDataGrid with double spaces within the value (for instance: "abc    xyz")

- Select that cell, CTRL+C

- Paste into the notepad (see that there is a proper value with double space in it)

- Paste into the Microsoft Excel (see that spaces got truncated to be just one).

Now, this is perhaps due to variant formats that resists in the Clipboard. We don't want our customers to worry about Excel clipboard settings.

Is there a way to resolve this issue ? (let the XamDataGrid copy data in the pure-text format only or so?).

Can you guys give me some feedback what to do here?