  | | | HSSSFSerializer: Auto row height by WrapText in MergedRegions not supported? | HSSSFSerializer: Auto row height by WrapText in MergedRegions not supported? 2007-12-05 - By Skladovs, Victor
Back Hi, guys! I would appreciate any help in solving the following issue: 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
<!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 size=2> <DIV><FONT face=Arial><SPAN class=468422114-30112007>Hi, guys!</SPAN></FONT></DIV> <DIV><FONT face=Arial><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><SPAN class=468422114-30112007><FONT face=Arial>I would appreciate any help <SPAN class=859473609-05122007>in solving </SPAN>the following <SPAN class=859473609-05122007>issue</SPAN>:</FONT></SPAN></DIV> <DIV><FONT face=Arial><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial><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><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial><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><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><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial><SPAN class=468422114-30112007>Am I doing something wrong or this feature isn't yet supported?</SPAN></FONT></DIV> <DIV><FONT face=Arial><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT face=Arial><SPAN class=468422114-30112007>Example:</SPAN></FONT></DIV> <DIV><FONT face=Arial><SPAN class=468422114-30112007></SPAN></FONT> </DIV> <DIV><FONT size=2><SPAN class=468422114-30112007><FONT color=#0000ff size=1> <P><FONT face=Arial><</FONT></FONT><FONT face=Arial><FONT color=#800000 size=1>gmr:MergedRegions</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: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><FONT size=1> <P></FONT><FONT face=Arial><FONT color=#0000ff size=1></</FONT><FONT color=#800000 size=1>gmr:MergedRegions</FONT><FONT color=#0000ff size=1>></P></FONT></FONT></SPAN></FONT></DIV> <DIV><FONT size=2><SPAN class=468422114-30112007><FONT color=#0000ff> <P><FONT face=Arial size=1><</FONT></FONT><FONT size=1><FONT face=Arial> <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 size=1><FONT face=Arial> <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 size=1><FONT face=Arial color=#0000ff></FONT></FONT> </P> <P><FONT size=+0><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 color=#000000><FONT face=Arial>R<SPAN class=468422114-30112007>egards,</SPAN></FONT></FONT></P> <P><FONT face=Arial color=#000000><SPAN class=468422114-30112007>Viktor</SPAN></FONT></FONT></SPAN></FONT></P></DIV>< /FONT></DIV> <DIV> </DIV></BODY></HTML>
|
|
|