cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aaron Magi" <>
Subject HSSF Serializer, problems setting defaultColumnWidth on gmr:Sheet , or ColumnWidth, any suggestions?
Date Thu, 01 Mar 2007 00:12:32 GMT
I am trying to set the default column width on the gmr:Sheet but it is not working.





                <gmr:Sheet ColumnWidth="1, 10240" DefaultColumnWidth="10240" OutlineSymbolsRight="true"
OutlineSymbolsBelow="true" DisplayOutlines="true" HideRowHeader="false" HideColHeader="false"
HideGrid="false" HideZero="false" DisplayFormulas="false">



I have noticed that in excel if I modify the width of the columns and save it as a 2003 xml
document it updates the WORKSHEET <column> and sets the width to “221.25”  I have
tried a variety of values for my default columnWidth and columnWidth but neither change the
Worksheet defaultColumnWidth.


<Worksheet ss:Name="Monthly Schedule Report">

  <Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="11" x:FullColumns="1"

   x:FullRows="1" ss:DefaultColumnWidth="60">

   <Column ss:AutoFitWidth="0" ss:Width="221.25" ss:Span="7"/>



I want to be able to set the width wider for the columns but can’t figure out how to do
this.  I am using cocoon and the HSSF Serializer


Is there a way to set the column width globally, on the gmr:content, or using a gmr:style?


If you need more info please ask.

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.4/705 - Release Date: 2/27/2007 3:24 PM
View raw message