Protecting XML attributes in excel cells

[MartyK]

Not for [ read < and ] read > - problems with forum rendering tags


Hi,
I have excel 2010 and am building up xml files to read into excel using the xml namespaces urn:schemas-microsoft-comffice:spreadsheet + others.
This gives me an xml doc that can be read into excel.
A typical Cell hold an xml snippet
<CELL><DATA Header="false" Name="Value" ss:Type="String">[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 Header="false" Name="Value" ss:Type="String">[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">[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 Header="false" Name="Comment" ss:Type="String">[Cell][Data ss:Type="String" Name="Comment" Header="false"]user Text Pasted From Comment[/Data][/Cell]
Any Ideas?
Thanks
Marty