[fpc-pascal] Re: XMLXSDExport: line ending in Excel cells

Reinier Olislagers reinierolislagers at gmail.com
Fri Aug 12 13:29:18 CEST 2011


On 12-8-2011 12:32, Reinier Olislagers wrote:
> In Excel text fields, you can generate a line ending by pressing
> Alt-Enter. On export to XML this is written as 

> So far so good.
> 
> If exporting dataset text (memo, string, ..) data to Excel XML text
> fields, which characters do I need to convert to 

> 1. Carriage return + linefeed (#13#10)
> 2. Linefeed (#10)
> 3. All occurrences of #10 and #13#10
> 4. Value of LineEnding constant
> 
Well, seems I had to drink more coffee.


 is line feed encoded in XML. So it doesn't matter, I can just
strip out the #13s - still working on getting those pesky Alt-enters
correctly imported into Excel but it's probably something very stupid...


Reinier



More information about the fpc-pascal mailing list