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?
Hello Lukasz,
The SettingData event of the DataObject can be handled to not include Html since this causes the double spacing to be lost. E.g.:
if (e.Format == DataFormats.Html){ e.CancelCommand();}
I have attached a sample.
Thanks, this is exactly what I needed!