Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

AutoFitHeight of row not working Excel

499 views
Skip to first unread message

martijn...@harmonygroup.eu

unread,
Sep 7, 2015, 4:02:20 AM9/7/15
to
I am working with XSL to transform an incoming xml to an xls format.
Everything works fine except of the autofitheight of a row.

I am using the next syntax:
<xsl:for-each select = "level3/level2/level1">
<Row ss:AutoFitHeight="1">
<Cell ss:StyleID="s10">
<Data ss:Type="String">
<xsl:value-of select="output/description" />
</Data>
</Cell>
</Row>
</xsl:for-each>

the style s10 is:
<Style ss:ID="s10">
<Alignment ss:Vertical="Bottom" ss:WrapText="1"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" />
<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" />
<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" />
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="0.1" />
</Borders>
<Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000" />
</Style>

The actual output is an excel document. The row has height 0 and if you double click between rows you see the actual autofitted row.. Anybody who knows what the problem is?

martijn...@harmonygroup.eu

unread,
Sep 7, 2015, 4:47:07 AM9/7/15
to
Op maandag 7 september 2015 10:02:20 UTC+2 schreef m.ma...@gmail.com:
Removed the default row height on the column properties.
Test ok!

0 new messages