On 12-8-2011 16:31, Ludo Brands wrote:
>> Excel needs an encoded LF:
>> <Cell><Data ss:Type="String">First line.&#10;Second line</Data></Cell>
>>
>> How can I produce that?
>>
> 
> Uses strutils;
> ...
> Foutputdoc.CreateTextNode(LeftStr(UTF8Decode(AnsiReplaceStr(AnsiReplaceStr(E
> F.Field.AsString,#10,'&#10;'),#13,'')),32767));
> 
> Ludo
> 
That's what I thought at first, too ;)

But the & gets encoded again by the XML unit and you get:
&amp;#10;
_______________________________________________
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Reply via email to