XML Spreadsheets won't wrap text

Question

I'm using XML Spreadsheets and cannot get the text to wrap

<Cell  ss:StyleID="bordercenter"><Data ss:Type="String"><divstyle="white-space: normal;"> value="Period &#10; <br/>Totals</div></Data></Cell>

When I added "white-space: normal;" it will generate the line break, but doesn't wrap the text until I enable editing and click on the column. Any ideas?

score 0 · Accepted Answer · answered May 30 '17 at 19:08

Apparently, the wrap Text attribute in the Style ID works

<Style ss:ID="bordercenter">
                <Font ss:Size="10" ss:Bold="1"/>
                <Alignment ss:Horizontal="Center"  ss:WrapText="1"/>
                <Borders>
                   <Border ss:Position="Bottom" 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="1"/>
                   <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
              </Borders>
            </Style>

Adding the ss:WrapText="1" in the alignment made it work perfectly.

XML Spreadsheets won't wrap text

1 Answers1