Hi,
I have excel 2010 and am building up xml files to read into excel using the xml namespaces urn:schemas-microsoft-com:office:spreadsheet + others.
This gives me an xml doc that can be read into excel.

A typical Cell hold an xml snippet
Cell><Data ss:Type="String" Name="Value" Header="false">DataInCell</Data></Cell>

If a user types into the cell then the xml becomes
Cell><Data ss:Type="String" Name="Value" Header="false">UserText</Data></Cell>
which is great

if I copy and paste the text from a source outside of excel however it becomes
Cell><Data ss:Type="String">User Text Pasted</Data></Cell>

in otherword the pasting loses my xml attributes in the Data tag.

How can I stop this.
Ideally I wouldnt want to stop the user pasting - I just dont want to lose the attributes

One further problem if I am in excell and copy and paste then I actually overwrite attributes in the destination cell.

so if the source cell had an attribute Name ="Comment" then after the paste the cell would be
Cell><Data ss:Type="String" Name="Comment" Header="false">user Text Pasted From Comment</Data></Cell>

Any Ideas?

Thanks
Martin