I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
Posted on 2005-09-15 21:48:12-07 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 2005-09-16 21:30:27-07 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.
Direct Responses: Write a response