Hi
I am using a display-tag library with an excel export option. In some of
the cells the data can span multiple rows such as
Account Name Start Date End Date Exception Dates
________________________________________________________________
xxxx1 05/05/1999 06/20/2007 04/05/2005
05/04/2006
06/23/2006
....
________________________________________________________________
xxxx2 07/05/1995 06/20/2007 07/05/2005
07/24/2006
06/23/2006
....
________________________________________________________________
...
When I export to Excel, the Exception Dates column has to be displayed
exactly like shown above in bold type. In HTML media this is done using
the <BR> tag (not the embedded displaytag:table which doesn't allow to
export the data). However in the Excel export I cannot use HTML tags
because they get printed right inside the cell. As a workaround for I
used a different media export where I tried putting a space, or even a
comma between each date iteration, but still to no avail - when
exported, the Exception Dates column displays as one unwrapped cell. I
know that in Excel the way to align the row data in such fashion is to
use the ALT-ENTER technique. Does anyone know if it's possible to force
ALT-ENTER during the iteration? Also, has anyone been successful in
controlling the width of the cells? Does it require writing your own
decorators?
Thanks for any advice
Mariya Pustovalova
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user
