I'm having a problem reading values from a cell when a certain user is pasting into the spreadsheet and keeping the existing formatting. When I target the cell and use the GetValue() method I get no result. When I tore apart the spreadsheet I see that the expected value "Blah Blah Blah" is wrapped in a RichTextRun. Is there another way that I can drill into the details of this cell to get this value?
<si>
<r>
<rPr>
<sz val="8"/>
<rFont val="Arial"/>
<family val="34"/>
</rPr><t>Blah Blah Blah</t>
</r>
</si>