I'm back, causing trouble again...
I want to read a cell that has multiple lines in it, which was created by first increasing the height of the row and then using ctrl-enter to get newlines without leaving the cell. The xml created looks likes:
<table:table-cell table:style-name="ce3">
<text:p>Foo1</text:p>
<text:p>foo2</text:p>
<text:p>foo3</text:p>
<text:p>foo4</text:p>
</table:table-cell>
but getCellValue is only returning Foo1. This one would actually be very useful to me, especially if it could be printed straight to an output file with the newlines intact.
Thanks,
Matt