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?
</rPr><t>Blah Blah Blah</t>