Mailing List
Home
Forum Home
Maven - Project building tool
Axis - Java SOAP implementation
Lucene - Full-featured text search engine APIs
Cocoon - MVC web framework based on XML/XSL
Fop - Create PDF, PCL, PS, SVG, XML driven by XSL formatting objects.
Log4J - A log library
POI - Java Excel, Word and other Microsoft Office files manipulating library
Oracle database error code ...
Subjects
log4j warning: No appenders could be found
java security AccessControlException: access denied (java io FilePermission clie
java lang InstantiationException: org apache tools ant Main
Apache Axis Tutorial
Subject: Struts <logic iterate >
log4j properties How to parse outpu to multiple files
configuring log4j with BEA Weblogic 8 1
How to use XSL FOP Java together
JSP precompile
Proposal: Adding jar manifest classpath in jar and war plugins
Servlet File Download dialog problem (IE6,Adobe 6 0)
java security AccessControlException: access denied (java io FilePermission
Unsupported major minor version 48 0 problem while running the an
   telope task
Subject: axis wsdl2java Ant Task usage
net sf hibernate MappingException: Error reading resource: test/User hbm xml
Building EAR ANT Script for websphere 5 0
CREATING WAR Files
Classpath problem
jsp data into Excel
Jboss 3 2 3+ vs Tomcat Axis Question
RE: How to include jars and add them into the MANIFEST MF/Class Path
attribute
Printing problem
Subject: InstantiationException
Couldn 't find trusted certificate
Please : How can one install ant 1 6 0 under Eclipse 2 1 ?
Excel: Too many different cell formats
Subject: AXIS: tomcat timeout ?
1 3 final: now giving me java io FileNotFoundException (Too many
open files)
XDoclet, Struts and Maven: Where to start? SOLUTION
Subject: Running junit tests fails
 
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>&nbsp;</DIV>
<DIV><SPAN class=468422114-30112007><FONT face=Arial>I would appreciate any
help&nbsp;<SPAN class=859473609-05122007>in solving&nbsp;</SPAN>the
following&nbsp;<SPAN class=859473609-05122007>issue</SPAN>:</FONT></SPAN></DIV>
<DIV><FONT face=Arial><SPAN class=468422114-30112007></SPAN></FONT>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT face=Arial><SPAN class=468422114-30112007>when I define a
&lt;gmr:Style WrapText="1"&gt; for a single cell only, the text&nbsp;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, &nbsp;a one row and two cells and apply a &lt;gmr:Style
WrapText="1"&gt; 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>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT face=Arial><SPAN
class=468422114-30112007>Example:</SPAN></FONT></DIV>
<DIV><FONT face=Arial><SPAN class=468422114-30112007></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT size=2><SPAN class=468422114-30112007><FONT color=#0000ff size=1>
<P><FONT face=Arial>&lt;</FONT></FONT><FONT face=Arial><FONT color=#800000
size=1>gmr:MergedRegions</FONT><FONT color=#0000ff
size=1>&gt;</P></FONT></FONT><FONT size=1>
<P></FONT><FONT face=Arial><FONT color=#0000ff size=1>&lt;</FONT><FONT
color=#800000 size=1>gmr:Merge</FONT><FONT color=#0000ff size=1>&gt;</FONT>
<FONT
size=1>A1:B1</FONT><FONT color=#0000ff size=1>&lt;/</FONT><FONT color=#800000
size=1>gmr:Merge</FONT><FONT color=#0000ff size=1>&gt;</P></FONT></FONT><FONT
size=1>
<P></FONT><FONT face=Arial><FONT color=#0000ff size=1>&lt;/</FONT><FONT
color=#800000 size=1>gmr:MergedRegions</FONT><FONT color=#0000ff
size=1>&gt;</P></FONT></FONT></SPAN></FONT></DIV>
<DIV><FONT size=2><SPAN class=468422114-30112007><FONT color=#0000ff>
<P><FONT face=Arial size=1>&lt;</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>"&gt;</P></FONT></FONT></FONT>
<P><FONT face=Arial><FONT color=#0000ff size=1>&lt;</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>"&gt;</P></FONT></FONT><FONT size=1>
<P></FONT><FONT face=Arial><FONT color=#0000ff size=1>&lt;</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>"&gt;</FONT><FONT
size=1>Helvetica</FONT><FONT color=#0000ff size=1>&lt;/</FONT><FONT
color=#800000 size=1>gmr:Font</FONT><FONT color=#0000ff
size=1>&gt;</P></FONT></FONT><FONT size=1>
<P></FONT><FONT face=Arial><FONT color=#0000ff size=1>&lt;/</FONT><FONT
color=#800000 size=1>gmr:Style</FONT><FONT color=#0000ff
size=1>&gt;</P></FONT></FONT><FONT size=1>
<P></FONT><FONT face=Arial><FONT color=#0000ff size=1>&lt;/</FONT><FONT
color=#800000 size=1>gmr:StyleRegion</FONT><FONT color=#0000ff
size=1>&gt;</FONT></FONT></P><FONT color=#0000ff><FONT color=#0000ff>
<P><FONT face=Arial size=1>&lt;</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>"&gt;</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>&lt;/</FONT><FONT color=#800000>gmr:Cell</FONT><FONT
color=#0000ff>&gt;</FONT></FONT></FONT></P>
<P><FONT size=1><FONT face=Arial color=#0000ff></FONT></FONT>&nbsp;</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>&nbsp;</DIV></BODY></HTML>

-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)