"Leon Ford" <LeonFord@d...> wrote in message 
news:3DC180DF-D145-47B9-82D8-4634BFB8DACB@m......
> Ok, now that I know how to get the ampersand to show up in this post, I 
> will
> try again.
>
> Excel produces this line when I format the item the way I want it and save
> as XML, which is what I put into my XSL transformation file.
> <Cell ss:StyleID="sHeaders"><Data
> ss:Type="String">Contract&#10;Value&#10;($M)</Data></Cell>
>
> How do I get the transformation to produce this line?
>
> "Leon Ford" wrote:
>
>> I am doing an XSL transformation of a dataset (using a XmlDataDocument) 
>> to
>> create an Excel XML file.  Everything is working fine except that my 
>> header
>> cells are not getting the line breaks like I want.
>>
>> When I explicitly format the headers in excel the way I want them and 
>> save
>> the file as XML, the line built by excel is:
>>
>> <Cell ss:StyleID="sHeaders"><Data
>> ss:Type="String">Contract
>> Value
>> ($M)</Data></Cell>
>>
>> In my XSL transformation file, I have the following line:
>>
>> <Cell ss:StyleID="sHeaders"><Data
>> ss:Type="String">Contract
>> Value
>> ($M)</Data></Cell>
>>
>> When I do the transformation and save the XML file, the line produced is
>> (note the line wrap):
>>
>> <Cell ss:StyleID="sHeaders"><Data ss:Type="String">Contract
>> Value
>> ($M)</Data></Cell>
>>
>> When this is loaded into excel, the linebreaks are gone and the cell text 
>> is
>> all on the same line.
>>
>> I have tried putting in the <xsl:preserve-space elements="*"/> into my 
>> XSL
>> transformation file, as well as XmlDataDocument.PreserveWhitespace = True
>> prior to doing the transformation in my code.  This does not help.
>>
>> The bottom line, is that I need the final XML file to be exactly as show
>> below to have excel load this correctly.
>>
>> <Cell ss:StyleID="sHeaders"><Data
>> ss:Type="String">Contract
>> Value
>> ($M)</Data></Cell>
>>
>>
>> I am using Office 2003, Windows XP, and Visual Studio 2003.
>>
Maybe use:

<xsl:text>&#x0d;</xsl:text>

in between contract and value.

-- 

Joe Fawcett (MVP - XML)

https://mvp.support.microsoft.com/profile=8AA9D5F5-E1C2-44C7-BCE8-8741D22D17A5