Hi,
I'm using POI-HSSF to create Excel documents, which works wonderfully. I
have one issue/question, though:
I would like to have a footer that spans two lines. It seems, however, that
either HSSF or Excel ignore the newline.
Code:
String footer = "Data as of " + todayReadable + "; \n" +
"Data assembled by " + userName;
poiFooter = poiSheet.getFooter();
poiFooter.setLeft(pageNumbers(left));
The values of the variables aren't really relevant. I've tried using \r\n
instead of \n, but to no avail as well.
Is there a way to insert a newline into a footer? If not, is this an issue
in POI (and might it be fixed at some point) or is it something in Excel (I
_am_ able to insert a newline when creating a footer in Excel, so it seems
it is possible in Excel)?
Thanks!
Frans
> ING/WIA/OPS/IT/R&F/LR&CRDB
> Location Code NA 05.61
> P.O. Box 1800, 1000 BV Amsterdam, The Netherlands
> T +31 20 56 35388, F +31 20 56 35884
> E [EMAIL PROTECTED]
>
>
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.
Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
