That will teach me to test :)
We need to come up with a strategy to handle different charsets, date formats, etc. explicitly. Perhaps with properties to indicate which to use if it cannot be determined on the fly.
Alex
>I'm sorry, I did'nt test my changes carefully.
>With my changes Excel show each character as two characters and Openoffice 2 hangs. To fix this
>I changed xml_file_header to
>
>
TEXT TO lcRetVal TEXTMERGE NOSHOW PRETEXT 2
><?xml version="1.0" encoding="Windows-<<TRANSFORM(CPCURRENT())>>"?>
><?mso-application progid="Excel.Sheet"?>
>ENDTEXT
>
>
>and conversion in .Render() to
>
>
cContents = ;
>STRCONV(strt(strt(strt(cContentsToBeRendered,'&','&'),'>','>' ),'<','<'),6)
>
>However, this does not allow to implement fontcharset.
>Any idea how to create xml file which has UTF-8, UTF-16 or similar encoding?
>
>Empty line is shown between each detail line.
>How to remove those empty lines ?
>
>>Later I'll extract the default code in ApplyExcelStyle which really should be outside the class because it is specific to my situation.
>
>I changed the code so it works without Excel installed, just creates file. Openoffice can open generated files also.