copying spreadsheet cells with complex formatting

Posted on 2009-11-19 21:50:21-08 by kjlassoc
copying spreadsheet cells with complex formatting
Hi, I want to copy cells from one location to another. I can do this easily enough if I only want the cell's text contents as plain text (without formatting) to be copied. However, I have some cells which contain a number of nested "text:span"s with their own styles associated with them. For example, here's the XML of a cell I want to copy:

<table:table-cell office:value-type="string" table:style-name="ce9">
<text:p>Did you know that you can access your office from your Blackberry? Go to
<text:span text:style-name="T3">http://bberry.office.com</text:span>
<text:span text:style-name="T4"> </text:span>
<text:span text:style-name="T2">to access your</text:span>
<text:span text:style-name="T1"> </text:span>
<text:span text:style-name="T2">office on your Blackberry or any hand-held device with an internet connection.</text:span>
</text:p>
</table:table-cell>

I obtained this cell's XML by calling $Doc->getTableCell($sheet, $coord); How do I another cell's contents with the the contents returned by getTableCell?
If I use $Doc->cellValue to assign a new value then I only see plain text.

Thanks
Direct Responses: Write a response