Thread

Posted on Fri Sep 16 00:48:12 2005 by mlcohen
multi-line cells in a spreadsheet
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
Direct Responses: 1005 | Write a response
Posted on Sat Sep 17 00:30:27 2005 by jmgdoc in response to 998
Re: multi-line cells in a spreadsheet

Interesting feed-back!

Up to now, the getText() and getCellValue() methods could not retrieve more than one text paragraph in a cell.
It was a bug. It's fixed (among other issues) in 2.008, to be released soon.
Write a response