On 12-8-2011 16:31, Ludo Brands wrote: >> Excel needs an encoded LF: >> <Cell><Data ss:Type="String">First line. Second line</Data></Cell> >> >> How can I produce that? >> > > Uses strutils; > ... > Foutputdoc.CreateTextNode(LeftStr(UTF8Decode(AnsiReplaceStr(AnsiReplaceStr(E > F.Field.AsString,#10,' '),#13,'')),32767)); > > Ludo > That's what I thought at first, too ;)
But the & gets encoded again by the XML unit and you get: &#10; _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal