Hi Markus,
I never used the ERExcelListPage but when using Apache POI directly you have to
adapt the cell style to accept line breaks:
Workbook wb = ...;
Sheet sheet = ...;
Row row = ...;
Cell cell = ...;
String value = string with line breaks;
CellStyle wrappingStyle = wb.createCellStyle();
wrappingStyle.setWrapText(true);
wrappingStyle.setVerticalAlignment(CellStyle.VERTICAL_TOP);
cell.setCellStyle(wrappingStyle);
cell.setCellValue(value);
row.setHeightInPoints((1 + StringUtils.countMatches(value, \n) *
sheet.getDefaultRowHeightInPoints());
Hope that helps.
jw
Am 04.04.2011 um 12:39 schrieb Markus Ruggiero:
Just a quick question regarding ERExcelListPage: How can I add a line break
inside one Excel cell? I have a toMany relationship where the customer wants
the values of a destination key put into one Excel cell as a single multi
line value. How can I do this? I already have a simple custom component that
puts the values in one cell but I can only add a printable separator (eg |
or , or - or similar) but not a line break.
Thanks for any help
---markus---
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com