  | | | HSSSFSerializer: Auto row height by WrapText in MergedRegions not supported? | HSSSFSerializer: Auto row height by WrapText in MergedRegions not supported? 2007-11-30 - By Skladovs, Victor
Back Hi, guys! I would appreciate any help of the following problem: I use Cocoon-2 (See http://oon-2.ora-code.com).1.10 and POI-3 (See http://POI-3.ora-code.com).0.1. when I define a <gmr:Style WrapText="1"> for a single cell only, the text is being wrapped and a row gets automatically the height so that the whole text is visible. BUT: when I define a MergedRegion from, say, a one row and two cells and apply a <gmr:Style WrapText="1"> to it, the text is being wrapped though, but the only one row is visible, the height isn't adjusted.. Am I doing something wrong or this feature isn't yet supported? Example: <gmr:MergedRegions>
<gmr:Merge>A1:B1</gmr:Merge>
</gmr:MergedRegions>
<gmr:StyleRegion startRow="0" endRow="0" startCol="0" endCol="1">
<gmr:Style HAlign="2" VAlign="1" WrapText="1" Orient="1" Shade="0" Indent="0" Locked="1" Hidden="0" Fore="0:0:0" Back="FFFF:FFFF:FFFF" PatternColor="0:0:0" Format="General">
<gmr:Font Unit="10" Bold="1" Italic="0" Underline="0" StrikeThrough="0">Helvetica</gmr:Font>
</gmr:Style>
</gmr:StyleRegion>
<gmr:Cell Row="0" Col="0" ValueType="60">This document will explain you what the Cocoon project is about and what we are doing to solve the problems that we encountered in our web engineering experiences, but from an executive perspective, yes, because we all had the problems of managing a web site, dealing with our colleagues, rushing to the graphical guru to have the little GIF with the new title, or calling the web administrator at night because the database is returning errors without reasons</gmr:Cell>
Thanx in advance!
Regards,
Viktor
HIS Hochschul-Informations-System GmbH Goseriede 9 | 30159 Hannover | www.his.de <http://www.his.de/>
Viktor Skladovs Abteilung II Hochschulforschung Informationssysteme und Online-Forschung Telefon +49 (0)511 1220-129 | Fax +49 (0)511 1220-250 E-Mail skladov@(protected)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>Nachricht</TITLE> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.6000.16544" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007>Hi, guys!</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007>I would appreciate any help of the following problem:</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007>I use Cocoon-2 (See http://oon-2.ora-code.com).1.10 and POI-3 (See http://POI-3.ora-code.com).0.1.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007>when I define a <gmr:Style WrapText="1"> for a single cell only, the text is being wrapped and a row gets automatically the height so that the whole text is visible. </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007>BUT: when I define a MergedRegion from, say, a one row and two cells and apply a <gmr:Style WrapText="1"> to it, the text is being wrapped though, but the only one row is visible, the height isn't adjusted..</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007>Am I doing something wrong or this feature isn't yet supported?</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007>Example:</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=468422114-30112007><FONT color=#0000ff size=1> <P><</FONT><FONT color=#800000 size=1>gmr:MergedRegions</FONT><FONT color=#0000ff size=1>></P></FONT><FONT size=1> <P></FONT><FONT color=#0000ff size=1><</FONT><FONT color=#800000 size=1>gmr:Merge</FONT><FONT color=#0000ff size=1>></FONT><FONT size=1>A1:B1</FONT><FONT color=#0000ff size=1></</FONT><FONT color=#800000 size=1>gmr:Merge</FONT><FONT color=#0000ff size=1>></P></FONT><FONT size=1> <P></FONT><FONT color=#0000ff size=1></</FONT><FONT color=#800000 size=1>gmr:MergedRegions</FONT><FONT color=#0000ff size=1>></P></FONT></SPAN></FONT></DIV> <DIV><FONT size=2><SPAN class=468422114-30112007><FONT color=#0000ff> <P><FONT face=Arial size=1><</FONT></FONT><FONT face=Arial><FONT size=1> <FONT color=#800000>gmr:StyleRegion</FONT><FONT color=#ff0000> startRow</FONT><FONT color=#0000ff>="<SPAN class=468422114-30112007>0</SPAN>"</FONT><FONT color=#ff0000> endRow</FONT><FONT color=#0000ff>="<SPAN class=468422114-30112007>0</SPAN>"</FONT><FONT color=#ff0000> startCol</FONT><FONT color=#0000ff>="</FONT>0<FONT color=#0000ff>"</FONT><FONT color=#ff0000> endCol</FONT><FONT color=#0000ff>="</FONT>1<FONT color=#0000ff>"></P></FONT></FONT></FONT> <P><FONT face=Arial><FONT color=#0000ff size=1><</FONT><FONT color=#800000 size=1>gmr:Style</FONT><FONT color=#ff0000 size=1> HAlign</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>2</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> VAlign</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>1</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> WrapText</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>1</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Orient</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>1</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Shade</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>0</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Indent</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>0</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Locked</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>1</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Hidden</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>0</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Fore</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>0:0:0</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Back</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>FFFF:FFFF:FFFF</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> PatternColor</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>0:0:0</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Format</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>General</FONT><FONT color=#0000ff size=1>"></P></FONT></FONT><FONT size=1> <P></FONT><FONT face=Arial><FONT color=#0000ff size=1><</FONT><FONT color=#800000 size=1>gmr:Font</FONT><FONT color=#ff0000 size=1> Unit</FONT> <FONT color=#0000ff size=1>="</FONT><FONT size=1>10</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Bold</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>1</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Italic</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>0</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> Underline</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>0</FONT><FONT color=#0000ff size=1>"</FONT><FONT color=#ff0000 size=1> StrikeThrough</FONT><FONT color=#0000ff size=1>="</FONT><FONT size=1>0</FONT><FONT color=#0000ff size=1>"></FONT><FONT size=1>Helvetica</FONT><FONT color=#0000ff size=1></</FONT><FONT color=#800000 size=1>gmr:Font</FONT><FONT color=#0000ff size=1>></P></FONT></FONT><FONT size=1> <P></FONT><FONT face=Arial><FONT color=#0000ff size=1></</FONT><FONT color=#800000 size=1>gmr:Style</FONT><FONT color=#0000ff size=1>></P></FONT></FONT><FONT size=1> <P></FONT><FONT face=Arial><FONT color=#0000ff size=1></</FONT><FONT color=#800000 size=1>gmr:StyleRegion</FONT><FONT color=#0000ff size=1>></FONT></FONT></P><FONT color=#0000ff><FONT color=#0000ff> <P><FONT face=Arial size=1><</FONT></FONT><FONT face=Arial><FONT size=1> <FONT color=#800000>gmr:Cell</FONT><FONT color=#ff0000> Row</FONT>="<SPAN class=468422114-30112007>0</SPAN>"<FONT color=#ff0000> Col</FONT><FONT color=#0000ff>="</FONT><FONT color=#000000>0</FONT><FONT color=#0000ff>"</FONT><FONT color=#ff0000> ValueType</FONT><FONT color=#0000ff>="</FONT><FONT color=#000000>60</FONT><FONT color=#0000ff>"></FONT><FONT color=#000000>This document will explain you what the Cocoon project is about and what we are doing to solve the problems that we encountered in our web engineering experiences, but from an executive perspective, yes, because we all had the problems of managing a web site, dealing with our colleagues, rushing to the graphical guru to have the little GIF with the new title, or calling the web administrator at night because the database is returning errors without reasons</FONT><FONT color=#0000ff></</FONT><FONT color=#800000>gmr:Cell</FONT><FONT color=#0000ff>></FONT></FONT></FONT></P> <P><FONT face=Arial><FONT size=1><FONT color=#0000ff></FONT></FONT></FONT> </P> <P><FONT><FONT size=1><FONT color=#0000ff><SPAN class=468422114-30112007><FONT face=Arial color=#000000 size=2>Thanx in advance!</FONT></SPAN></FONT></FONT></FONT></P> <P><FONT face=Arial><FONT color=#000000>R<SPAN class=468422114-30112007>egards,</SPAN></FONT></FONT></P> <P><FONT face=Arial><FONT color=#000000><SPAN class=468422114-30112007>Viktor</SPAN></FONT></FONT></FONT></SPAN></FONT></P>< /DIV> <DIV> </DIV><!-- Converted from text/rtf format --> <P align=left><SPAN lang=de><FONT size=1><FONT face=Verdana color=#006ab2>HIS Hochschul-Informations-System GmbH</FONT><BR><FONT face=Verdana color=#808080>Goseriede 9 | 30159 Hannover |</FONT> </FONT></SPAN><A href="http://www.his.de/"><SPAN lang=de><U><FONT face=Verdana color=#808080 size=1>www.his.de</FONT></U></SPAN></A><SPAN lang=de><BR><BR><FONT face=Verdana color=#808080 size=1>Viktor Skladovs<BR>Abteilung II <SPAN style="FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Verdana; mso-fareast-font -family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi -language: DE; mso-fareast-language: DE; mso-bidi-language: AR-SA" >Hochschulforschung</SPAN><BR><SPAN style="FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Verdana; mso-fareast-font -family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi -language: DE; mso-fareast-language: DE; mso-bidi-language: AR-SA" >Informationssysteme und Online-Forschung</SPAN><BR>Telefon +49 (0)511 1220-129 | Fax +49 (0)511 1220-250</FONT></SPAN><FONT size=1> <BR><SPAN lang=de><FONT face=Verdana color=#808080>E-Mail <A href="mailto:skladov@(protected)">skladov@(protected)</A></FONT></SPAN></FONT></P> <DIV> </DIV></BODY></HTML>
|
|
|