RE : RE : [fpc-pascal] Explicit encoding of LF in XML

2011-08-12 Thread Ludo Brands
> > Uses strutils; > > ... > > > Foutputdoc.CreateTextNode(LeftStr(UTF8Decode(AnsiReplaceStr(AnsiReplac > > eStr(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: >

Re: RE : [fpc-pascal] Explicit encoding of LF in XML

2011-08-12 Thread Reinier Olislagers
On 12-8-2011 16:31, Ludo Brands wrote: >> Excel needs an encoded LF: >> First line. Second line >> >> How can I produce that? >> > > Uses strutils; > ... > Foutputdoc.CreateTextNode(LeftStr(UTF8Decode(AnsiReplaceStr(AnsiReplaceStr(E > F.Field.AsString,#10,' '),#13,'')),32767)); > > Ludo > That's

RE : [fpc-pascal] Explicit encoding of LF in XML

2011-08-12 Thread Ludo Brands
> All, > > Looking at multiline support of text/string cells for export > to Excel XML format. > > My code, such as: > TDOMElement(FieldNode).SetAttribute('ss:Type', 'String'); > FNode := > Foutputdoc.CreateTextNode(LeftStr(UTF8Decode(EF.Field.AsString > ), 32767)); writes out a cell li

[fpc-pascal] Explicit encoding of LF in XML

2011-08-12 Thread Reinier Olislagers
All, Looking at multiline support of text/string cells for export to Excel XML format. My code, such as: TDOMElement(FieldNode).SetAttribute('ss:Type', 'String'); FNode := Foutputdoc.CreateTextNode(LeftStr(UTF8Decode(EF.Field.AsString), 32767)); writes out a cell like: First line. Second